PORTRAIT OF AN OPTIMISTIC DUDE

Oracle EBS Purchase Order Tables:- PO_LINES_ALL PO_HEADERS_ALL PO_LINE_LOCATIONS_ALL PO_DISTRIBUTIONS_ALL ORG_ORGANIZATION_DEFINITIO...

Oracle EBS Purchase Order Tables:- PO_HEADERS_ALL AP_SUPPLIERS AP_SUPPLIER_SITES_ALL HR_LOCATIONS AP_TERMS PER_ALL_PEOPLE_F HR_OPE...

Oracle EBS AP Open Invoice Tables:- AP_INVOICES_ALL AP_INVOICE_LINES_ALL AP_SUPPLIERS AP_SUPPLIER_SITES_ALL AP_TERMS_TL AP_PAYMENT_...

Oracle EBS EBTAX-Document Classifications Tables:- ZX_FC_TYPES_VL ZX_FC_CODES_DENORM_B SQL Example:- SELECT a.CLASSIFICATION_TYPE_...

Oracle EBS EBTAX-Tax Statuses Tables:- ZX_PARTY_TAX_PROFILE ZX_SUBSCRIPTION_DETAILS ZX_REGIMES_USAGES ZX_MCO_EO_STATUS_V ZX_REGIMES_...

Oracle EBS EBTAX-EBTAX Tax Rules Tables:- ZX_RULES_VL ZX_PROCESS_RESULTS ZX_CONDITION_GROUPS_VL ZX_DET_FACTOR_TEMPL_VL ZX_CONDITIONS...

Oracle EBS EBTAX-EBTAX Tax Rates Tables:- ZX_RATES_VL ZX_ACCOUNTS ZX_RATES_B AP_ZX_RATES_B SQL Example:- SELECT  ratetleo.tax_re...

Oracle EBS EBTAX-Party Tax Profiles Tables:- ZX_REGIMES_USAGES ZX_SUBSCRIPTION_OPTIONS ZX_FIRST_PARTY_ORGS_ALL_V ZX_PARTY_TAX_PROFILE...

Oracle EBS EBTAX-EBTAX TAX REGIME Tables:- ZX_REGIMES_USAGES ZX_SUBSCRIPTION_OPTIONS ZX_FIRST_PARTY_ORGS_ALL_V ZX_PARTY_TAX_PROFILE ...

Oracle EBS EBTAX-Tax Rates Accounts Tables:- ZX_RATES_VL ZX_ACCOUNTS GL_LEDGERS GL_CODE_COMBINATIONS_KFV SQL Example:- SELECT ho...

Oracle EBS EBTAX-Tax Jurisdictions Tables:- ZX_PARTY_TAX_PROFILE ZX_SUBSCRIPTION_DETAILS ZX_REGIMES_USAGES ZX_REGIMES_VL ZX_MCO_EO_T...

Oracle EBS EBTAX-TAXES Tables:- ZX_PARTY_TAX_PROFILE ZX_SUBSCRIPTION_DETAILS ZX_REGIMES_USAGES ZX_MCO_EO_TAXES_V ZX_REPORT_CODES_ASS...

Oracle EBS EBTAX-EBTAX REPTYPE REPCODES Tables:- ZX_REPORTING_TYPES_VL ZX_REPORTING_CODES_VL SQL Example:- SELECT a.reporting_type...

Oracle EBS EBTAX-EBTax Condition Sets Tables:- ZX_MCO_EO_RULES_V ZX_PROCESS_RESULTS ZX_CONDITION_GROUPS_VL ZX_DET_FACTOR_TEMPL_VL ZX...

Oracle EBS EBTAX-EBTax Determining Factors Tables:- ZX_DETERMINING_FACTORS_VL SQL Example:- SELECT Lookup.MEANING  "Determinin...

Oracle EBS Latam Tax-Latin Tax Categories Tables:- JL_ZZ_AR_TX_CATEGRY_V SQL Example:- SELECT hou.name  "Name" ,jzv.tax_...

Oracle EBS Latam Tax-Latin Tax Lookup Tables:- FND_FLEX_VALUES_VL FND_FLEX_VALUE_SETS SQL Example:- SELECT ffvv.flex_value ,ffvv....

Oracle EBS Latam Tax-LAT JL CITY Tables:- FND_LOOKUP_TYPES_VL FND_LOOKUP_VALUES_VL SQL Example:- SELECT fltv.lookup_type  "Loo...

Oracle EBS Latam Tax-Latin Fiscal Classification Tables:- JL_ZZ_AR_TX_FSC_LOOKUP_V JL_ZZ_AR_TX_FSC_CLS_ALL SQL Example:- SELECT jz...

Oracle EBS Latam Tax-China Golden Tax Rules Tables:- AR_GTA_RULE_HEADERS_ALL AR_GTA_RULE_TRX_TYPES_ALL SQL Example:- SELECT hou.nam...

Oracle EBS Latam Tax-Condition Classes Tables:- JL_ZZ_AR_TX_ATT_CLS_LOOKUP_V JL_ZZ_AR_TX_ATT_CLS_V SQL Example:- SELECT jzav.tax_a...

Oracle EBS Latam Tax-Geography Hierarchy Tables:- HZ_GEOGRAPHIES HZ_GEOGRAPHY_IDENTIFIERS HZ_HIERARCHY_NODES SQL Example:- SELECT ...

Oracle EBS Latam Tax-Company WTH Applicability Tables:- JL_ZZ_AP_COMP_AWT_TYPES SQL Example:- SELECT c.name  "Operating Unit...

Oracle EBS Latam Tax-Latin Tax Profiles Tables:- JL_ZZ_AR_TX_CATEG_ALL JL_ZZ_AR_TX_CUS_CLS_ALL SQL Example:- SELECT DISTINCT ---...

Oracle EBS Latam Tax-Geography Management Tables:- HZ_GEO_STRUCT_MAP_DTL HZ_GEO_STRUCTURE_LEVELS HZ_GEOGRAPHY_TYPES_VL HZ_GEOGRAPHIES...

Oracle EBS Latam Tax-State Province Tables:- FND_LOOKUP_TYPES_VL FND_LOOKUP_VALUES_VL SQL Example:- SELECT fltv.lookup_type ,fltv...

Oracle EBS Latam Tax-China System Profiles Tables:- AR_GTA_SYSTEM_PARAMETERS_ALL AR_GTA_TAX_LIMITS_ALL SQL Example:- SELECT  hou.na...

Oracle EBS Latam Tax-AP Application Tax Options Tables:- ZX_PRODUCT_OPTIONS_ALL SQL Example:- SELECT DISTINCT   b.name  "OU Nam...

Oracle EBS Latam Tax-Latin Tax Groups Tables:- JL_ZZ_AR_TX_GROUPS SQL Example:-  SELECT DISTINCT  b.name "Operating Unit" ...

Oracle EBS Latam Tax-Vat Document Letter Assignment Tables:- JL_AR_AR_DOC_LETTER_ALL SQL Example:- SELECT hou.name  "Operating...

SELECT rct.CUSTOMER_TRX_ID ,rct.TRX_NUMBER ,rctt.CUST_TRX_TYPE_ID ,rct.OLD_TRX_NUMBER ,rctt.NAME ,rctt.DESCRIPTION ,rctt.TYPE FROM ...

Oracle EBS Latam Tax-Source and Type Relationship Tables:- JG_ZZ_AR_SRC_TRX_TY_ALL SQL Example:- SELECT hou.name  "OU NAME...

Oracle EBS Latam Tax-AR Application Tax Options Tables:- ZX_PRODUCT_OPTIONS_ALL SQL Example:- SELECT  b.name "OU Name" ,...