Script to Find All Sundays Date for a given Date Within that Year

DECLARE

   l_date       DATE := '&P_ENTER_ANY_DATE';

   l_first_sunday   DATE;

   l_last_sunday    DATE;

BEGIN

   --Find 1st Sunday

   l_first_sunday := NEXT_DAY (TRUNC (l_date, 'YYYY') - 1, 'SUN');

   --Find last Sunday

   l_last_sunday := NEXT_DAY (ADD_MONTHS (TRUNC (l_date, 'YYYY') - 1, 12), 'SUN') - 7;

   WHILE l_first_sunday <= l_last_sunday

   LOOP

      DBMS_OUTPUT.PUT_LINE ( l_first_sunday);

      l_first_sunday := l_first_sunday + 7;

   END LOOP;

END;

Unapplied and Unresolved Receipts Register report completing with Error

 "Unapplied and Unresolved Receipts" report is the replacement for "Unapplied Receipt Register". When tried to run "Unapplied and Unresolved Receipts" report for the first time, its completed with below error.

Its not a BIDI char set

Its not a BIDI language

Error executing cursor. ORA-06502: PL/SQL: numeric or value error: NULL index table key value 

ORA-06512: at "APPS.FA_RX_PUBLISH", line 2205 

ORA-06512: at line 1

Unable to execute cursor

To resolve this issue Oracle Provided data fix as mentioned in Note "Unapplied and Unresolved Receipts Register Cannot Be Submitted (Doc ID 866105.1)"

Please make sure that you will do testing in test instance.

As per Oracle the error occurs because the concurrent_program_id is null for the reports having report_ids 492 and 493.

1. Please run the following sql

select report_id, application_id, concurrent_program_id,
last_update_date,concurrent_program_name
from fa_rx_reports
where report_id in (492,493);

2. If the query results concurrent_program_id as NULL then please run the following update statement:

Update fa_rx_reports farr
set concurrent_program_id =
(Select concurrent_program_id
From fnd_concurrent_programs
Where application_id = farr.application_id
And concurrent_program_name = farr.concurrent_program_name);

3. Then run the report.

"Unapplied Receipt Register" report completing with Error in Oracle Apps R12

While running "Unapplied Receipts Register" completing with below error in Oracle APPS R12.

REP-0004: Warning: Unable to open user preference file.

MSG-00100: BeforeReport_Procs.Set_Sort_Order

MSG-00200: Total forAGENCY: 

REP-1401: 'report_subtitleformula': Fatal PL/SQL error occurred.

ORA-06502: PL/SQL: numeric or value error

ORA-06512: at "APPS.AR_MO_GLOBAL_CACHE", line 55

ORA-06512: at "APPS.ARP_STANDARD", line 3021

REP-0069: Internal error

REP-57054: In-process job terminated:Terminated with error: m

REP-1401: MSG-00100: BeforeReport_Procs.Set_Sort_Order

MSG-00200: Total forAGENCY: 

REP-1401: 'report_subtitleformula': Fatal PL/SQL error occurred.

ORA-06502: PL/SQL: numeric or value error

ORA-06512: at "APPS.AR_MO_GLOBAL_CACHE", line 55

ORA-06512: at "APPS.ARP_STANDARD", line 3021

Solution: As mentionbed in Oracle Note Document ID 418261.1 "Unapplied Receipt Register" is Obsoleted in R12. 

Below are the comments from Oracle Note.

"In Release 12, the Unapplied Receipt Register has been made Obsoleted. 

The Unapplied and Unresolved Receipts Register is a new RXI report which gives you the ability to change the columns on the report as needed with the Report eXchange Designer responsibility."

Query to get Dependent Value Set Values for given Independent Value Set in Oracle APPS

  SELECT ffvs_major.flex_value_set_id   major_flex_value_set_id,

         ffvs_major.flex_value_set_name major_flex_value_set_name,

         ffvs_major.description         major_set_description,

         ffvs_major.validation_type     major_validation_type,

         ffv_major.flex_value           major_flex_value,

         ffvt_major.description         major_value_description,

         ffv_major.enabled_flag         major_enabled_flag,

         ffv_major.last_update_date     major_last_update_date,

         ffv_major.last_updated_by      major_last_updated_by,

         ffv_major.attribute1           major_attribute1,

         ffv_major.attribute2           major_attribute2,

         ffv_major.attribute3           major_attribute3

        ,ffvs_minor.flex_value_set_id   minor_flex_value_set_id,

         ffvs_minor.flex_value_set_name minor_flex_value_set_name,

         ffvs_minor.description minor_set_description,

         ffvs_minor.validation_type minor_validation_type,

         ffv_major.flex_value minor_flex_value,

         ffvt_minor.description minor_value_description,

         ffv_minor.enabled_flag minor_enabled_flag,

         ffv_minor.last_update_date minor_last_update_date,

         ffv_minor.last_updated_by minor_last_updated_by,

         ffv_minor.attribute1 minor_attribute1,

         ffv_minor.attribute2 minor_attribute2,

         ffv_minor.attribute3 minor_attribute3

    FROM fnd_flex_value_sets ffvs_major

        ,fnd_flex_values ffv_major

        ,fnd_flex_values_tl ffvt_major

        ,fnd_flex_value_sets ffvs_minor

        ,fnd_flex_values ffv_minor

        ,fnd_flex_values_tl ffvt_minor

   WHERE ffvs_major.flex_value_set_id = ffv_major.flex_value_set_id

     AND ffv_major.flex_value_id = ffvt_major.flex_value_id

     AND ffvt_major.language = USERENV ('LANG')

     AND UPPER(ffvs_major.flex_value_set_name) = 'XX_MAJOR_CATEGORY_VS'

     AND ffvs_major.flex_value_set_id = ffvs_minor.parent_flex_value_set_id

     AND ffv_major.flex_value = 'XX'

     AND ffv_major.flex_value = ffv_minor.parent_flex_value_low

     AND ffvs_minor.flex_value_set_id = ffv_minor.flex_value_set_id

     AND ffv_minor.flex_value_id = ffvt_minor.flex_value_id

     AND ffvt_minor.language = USERENV ('LANG')

ORDER BY ffv_major.flex_value ASC

Query to get Customer Details in Oracle APPS R12

SELECT DISTINCT ou.name ou_name 

      ,ps.customer_id

  ,party.party_name customer_name

      ,hzca.account_number customer_number

  ,hzca.status customer_status

  ,hcsu.location

  ,hcsu.site_use_code

  ,hcsu.status location_status

  ,ps.class

  ,hcsu.site_use_id

  ,hcpc.name customer_profile_name

  ,hzl.address1 address_line1

  ,hzl.address2 address_line2

  ,hzl.address3 address_line3

  ,hzl.city

  ,hzl.state

  ,hzl.postal_code  

  ,ps.customer_site_use_id

  ,party_site.identifying_address_flag

  ,ps.trx_date

  FROM apps.hz_parties party

      ,apps.hz_party_sites party_site

  ,apps.hz_locations hzl

  ,apps.hz_cust_accounts hzca

  ,apps.hz_cust_acct_sites hcas

  ,apps.hz_cust_site_uses hcsu

  ,apps.hz_customer_profiles cust_profile

  ,apps.hz_cust_profile_classes hcpc

  ,apps.ar_payment_schedules_all ps

  ,apps.hr_operating_units ou 

 WHERE party.party_id = hzca.party_id(+) 

   AND party.party_id = cust_profile.party_id 

   AND party.party_id = party_site.party_id 

   AND party_site.party_site_id = hcas.party_site_id 

   AND party_site.location_id = hzl.location_id 

   AND hzca.cust_account_id = hcas.cust_account_id 

   AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id 

   AND hzca.cust_account_id = cust_profile.cust_account_id 

   AND hzca.cust_account_id = ps.customer_id 

   AND cust_profile.profile_class_id = hcpc.profile_class_id 

   AND ps.customer_site_use_id = hcsu.site_use_id 

   AND hcsu.org_id = ou.organization_id

Query to get Supplier Site Level Bank Account in Oracle APPS

SELECT bank_account_name

              ,bank_account_num

  FROM iby_ext_bank_accounts

 WHERE ext_bank_account_id IN ( SELECT ext_bank_account_id

                                  FROM iby_account_owners

                                 WHERE account_owner_party_id

                                    IN ( SELECT party_id

      FROM hz_party_sites

   WHERE party_site_name = 'SUPPLIER_SITE_NAME'

)

)

POS_SUPPLIER_MAPPINGS

POS_SUPPLIER_MAPPINGS table holds the mapping between the AP_SUPPLIERS.VENDOR_ID and HZ_PARTIES.PARTY_ID. This is useful in case of two vendors effectively belong to the same HZ_PARTY Record.

SELECT psm.* 

  FROM pos_supplier_mappings  psm

 WHERE psm.party_id = 123456

IBY_EXTERNAL_PAYEES_ALL

This table captures Payment related details of the Supplier. For Example: The Supplier's remittance advice, the default Payment method Code for this supplier or the bank charges in case of SWIFT payments, etc. This information can be setup at Supplier Level or  Supplier Site Level.

SELECT iepa.* 

  FROM iby_external_payees_all iepa 

 WHERE iepa.payee_party_id = 123456

HZ_ORGANIZATION_PROFILES

This table captures additional Supplier information.

Examples are like credit scoring details of Supplier or the No. of Employees working in Supplier Organization.

SELECT hop.* 

  FROM hz_organization_profiles hop

 WHERE hop.party_id = 123456

HZ_PARTY_USG_ASSIGNMENTS

This table stores the Party Usages, for example, party_id of the type SUPPLIER.

SELECT party_id 

      ,party_usg_assignment_id

  ,party_usage_code 

  FROM hz_party_usg_assignments 

 WHERE party_id = 123456;

Supplier Type Employee not showing any List Of values while creating in Oracle APPS

This is from Oracle Note Doc ID 2395382.1:

The contingent workers will not be directly visible in the suppliers form.

The functional reason is that Contingent Worker (CW) Employees are different from Company Employees. In case of Contingent workers you generally work with the company that has provided the CW. Also there are many restrictions for the Employee type Suppliers (like we don’t show the address, most of the fields are non editable etc.) that may not apply to CW. As such the way to do this would be to establish a Supplier and then relate this Supplier to the Contingent worker in the HR form.

If the customers requirement is to create Employee type suppliers, the such CW need to be made as a employees and not CW.

Unable to create Employee Type Supplier in Oracle APPS R12

While creating Employee Type Supplier, Supplier Type not showing "Supplier used to process expense payments to internal employees" from list of values and showing only "Standard supplier".

Please follow Oracle Support Note "R12:AP: Suppliers Form: Unable To Create Or View An Employee Type Supplier (Doc ID 1371295.1)" to resolve the issue.

Pricing Data Bulk Loader in Oracle APPS

The pricing data bulk loader imports data from the following interface tables:

• QP_INTERFACE_LIST_HEADERS
• QP_INTERFACE_LIST_LINES
• QP_INTERFACE_QUALIFIERS 
• QP_INTERFACE_PRICING_ATTRIBS 
• QP_INTERFACE_ERRORS

QP_INTERFACE_LIST_HEADERS: This table captures the Price List header data.

QP_INTERFACE_LIST_LINES: Price list line data is captured in this interface table.

QP_INTERFACE_QUALIFIERS: This table contains the header qualifiers associated with the price lists to be imported. 

QP_INTERFACE_PRICING_ATTRIBS: The product and pricing attributes data is captured in this table. 

How To Find the XML Publisher Temporary Directory Via SQL in Oracle APPS?

Navigate: XML Publisher -> Administrator Properties -> General -> Temporary Directory

SELECT value

FROM   XDO_CONFIG_VALUES

WHERE  property_code = 'SYSTEM_TEMP_DIR';

Steps to define Auto Lockbox in Oracle APPS

• Define the Bank, Bank Branch and Bank Account 
• Define Receipt Class for Auto Lockbox 
• Define Receipt Source
• Define Autocash Ruleset
• Define Customer, attach the receipt method and create the customer bank account (Branch number and account number combination decides the MICR number) 
• Define Lockbox 
• Navigation: Setup --> Receipts --> Lockboxes --> Lockboxes
• Define Transmission Formats 
• Navigation: Setup --> Receipts --> Lockboxes --> Transmission Formats
• Control file changes
• Run Autolockbox 
• Submit Validation 
• Submit Post Quickcash

Asset Retirement Types in Oracle APPS

Type	Description	Rules
Unit retirement	Retire assets by unit, either all units or some units of a multiple-unit asset. The cost retired is automatically calculated for each unit retired.	Not allowed in tax books.
Cost retirement	Retire assets by cost. The units remain unchanged and the retired cost is spread evenly among the units.	Allowed in both corporate and tax books.
Source line retirement	Retire an asset that was imported as a source line by retiring the asset cost based on the source line.	Allowed for both partial and full retirements.

 

Asset Retirement Methods in Oracle APPS

Method	Description	Rules
Full retirement	Retire all the units of a multiple-unit asset Retire the entire asset cost	Full cost retirements: allowed for CIP assets. Full unit retirements: not allowed for CIP assets.
Partial retirement	Retire a specified number of units of a multiple-unit asset Retire a portion of the asset cost.	Partial cost retirements: the units remain unchanged and the retired cost is spread evenly among all assignment lines. Partial unit retirements: Oracle Fusion Assets automatically calculates the retired cost. Partial retirements of CIP assets: not allowed.

 

Asset Queue Status in Oracle APPS

Queue Name	Definition
New	New mass addition line created but not yet reviewed.
On Hold or user-defined hold queue	Mass addition line updated or put on hold.
Split	Mass addition line already split into multiple lines.
Merged	Mass addition line already merged into another line.
Cost Adjustment	Mass addition line to be added to an existing asset; ready for posting.
Post	Mass addition line ready to become an asset.
Posted	Mass addition line already posted.
Delete	Mass addition line to be deleted.

Query to extract Purchase Document Types in Oracle APPS

  SELECT haou.name operating_unit,

         flv1.meaning || ' ' || flv2.meaning document_type,

         pdtav.type_name name,

         xtv1.template_name document_types_layout,

         xtv2.template_name contract_terms_layout,

         DECODE (pdtav.can_preparer_approve_flag,  'Y', 'Yes',  'N', 'No')

            can_preparer_approve,

         INITCAP (pdtav.security_level_code) security_level,

         pdtav.document_type_code,

         pdtav.document_subtype

    FROM hr_all_organization_units haou,

         po_document_types_all_vl pdtav,

         fnd_lookup_values flv1,

         fnd_lookup_values flv2,

         xdo_templates_vl xtv1,

         xdo_templates_vl xtv2

   WHERE 1 = 1

         AND haou.organization_id = pdtav.org_id

         AND pdtav.document_type_code = flv1.lookup_code(+)

         AND pdtav.document_subtype = flv2.lookup_code(+)

         AND flv1.lookup_type(+) = 'DOCUMENT TYPE'

         AND flv2.lookup_type(+) =

                DECODE (pdtav.document_type_code,

                        'REQUISITION', 'REQUISITION TYPE',

                        'RFQ', 'RFQ SUBTYPE',

                        'QUOTATION', 'QUOTATION SUBTYPE',

                        'DOCUMENT SUBTYPE')

         AND flv1.language(+) = USERENV ('lang')

         AND flv2.language(+) = USERENV ('lang')

         AND flv1.view_application_id(+) = 201

         AND flv2.view_application_id(+) = 201

         AND flv1.security_group_id(+) = 0

         AND flv2.security_group_id(+) = 0

         AND pdtav.document_template_code = xtv1.template_code(+)

         AND pdtav.contract_template_code = xtv2.template_code(+)

ORDER BY haou.name

        ,pdtav.document_type_code

        ,pdtav.type_name

Query to fetch Elements attached to Employee in Oracle APPS

SELECT pbg.name business_group_name

      ,papf.employee_number

      ,papf.full_name

      ,petf.element_name

      ,peef.effective_start_date

  FROM per_all_people_f papf

      ,per_all_assignments_f paaf

      ,pay_element_entries_f peef

      ,pay_element_types_f petf

      ,per_business_groups pbg

 WHERE papf.person_id = paaf.person_id

   AND papf.business_group_id = pbg.business_group_id

   AND pbg.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')

   AND papf.current_employee_flag = 'Y'

   AND paaf.assignment_id = peef.assignment_id

   AND peef.element_type_id = petf.element_type_id

   AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date AND papf.effective_end_date

   AND TRUNC (SYSDATE) BETWEEN paaf.effective_start_date AND paaf.effective_end_date

   AND TRUNC (SYSDATE) BETWEEN peef.effective_start_date AND peef.effective_end_date

   AND TRUNC (SYSDATE) BETWEEN petf.effective_start_date AND petf.effective_end_date

   AND petf.element_name LIKE 'PF%'

Query to extract values from the User Defined Tables in Oracle APPS

SELECT put.user_table_name

      ,pur.row_low_range_or_name

      ,pui.value

      ,puc.user_column_name

  FROM pay_user_tables put

      ,pay_user_rows_f pur

      ,pay_user_columns puc

      ,pay_user_column_instances_f pui

 WHERE 1=1

   AND pur.user_table_id = put.user_table_id

   AND pui.user_column_id = puc.user_column_id

   AND pui.user_row_id = pur.user_row_id

   AND SYSDATE BETWEEN pur.effective_start_date AND pur.effective_end_date

   AND SYSDATE BETWEEN pui.effective_start_date AND pui.effective_end_date

   --AND put.user_table_name = '<USER_DEFINED_TABLE_NAME>'

   --AND puc.user_column_name = '<USER_DEFINED_COLUMN_NAME>'

   AND puc.user_table_id = put.user_table_id

Query to get the Menu Name in Oracle APPS

SELECT frt.responsibility_name

      ,fm.menu_id

      ,fm.menu_name

  FROM fnd_menus fm

      ,fnd_responsibility fr

  ,fnd_responsibility_tl frt

 WHERE fm.menu_id = fr.menu_id

   AND fr.responsibility_id = frt.responsibility_id

   AND fr.responsibility_id = frt.responsibility_id

   AND frt.responsibility_name = 'Receivables Manager'

Query to find the Descriptive Flex Field (DFF) fields attached to a Context Code in Oracle APPS

SELECT fat.application_name

      ,desc_flex.descriptive_flexfield_name

      ,desc_flex.title

      ,desc_flex_col_usg.descriptive_flex_context_code

      ,desc_flex_col_usg.column_seq_num

      ,desc_flex_col_usg.end_user_column_name

      ,desc_flex_col_usg.application_column_name

      ,desc_flex_col_usg.form_left_prompt

      ,desc_flex_col_usg.form_above_prompt

      ,desc_flex_col_usg.flex_value_set_id value_set_id

      ,flex_vs.flex_value_set_name

      ,flex_vs.validation_type

      ,desc_flex_col_usg.enabled_flag

      ,desc_flex_col_usg.required_flag      

      ,desc_flex_col_usg.display_flag

      ,desc_flex_col_usg.display_size

  FROM fnd_descriptive_flexs_tl desc_flex

      ,fnd_descr_flex_col_usage_vl desc_flex_col_usg

      ,fnd_flex_value_sets flex_vs

      ,fnd_application_tl fat

 WHERE  1=1

   AND desc_flex.descriptive_flexfield_name = desc_flex_col_usg.descriptive_flexfield_name

   AND desc_flex.language = USERENV('LANG')

   AND desc_flex_col_usg.descriptive_flex_context_code = 'CONTRACTS'

   --AND desc_flex_col_usg.descriptive_flexfield_name = 'RA_INTERFACE_LINES'

   AND flex_vs.flex_value_set_id(+) = desc_flex_col_usg.flex_value_set_id

   AND desc_flex_col_usg.application_id = fat.application_id

   AND fat.language = USERENV('LANG')

   --AND fat.application_id = 222

   AND desc_flex.title = 'Line Transaction Flexfield'

ORDER BY desc_flex_col_usg.column_seq_num

Query to list Freight From Discount Excluded Records in Oracle APPS

SELECT supp.vendor_name

      ,supp.segment1 vendor_number

      ,supp.exclude_freight_from_discount vendor_freight_discount_excld

  ,supp_site.vendor_site_code

  ,supp_site.exclude_freight_from_discount vend_sit_freight_dis_excld

  FROM ap_suppliers supp

      ,ap_supplier_sites_all supp_site

 WHERE supp.vendor_id = supp_site.vendor_id

   AND supp.exclude_freight_from_discount  IS NULL

   AND supp_site.exclude_freight_from_discount IS NULL

ORDER BY supp.vendor_name

Query to list Geography's without Jurisdiction's in Oracle APPS EB-Tax

SELECT * 

  FROM(SELECT geography_type

             ,geography_element2_code state_code

,geography_element3_code county_code

,geography_element4_code city_code

         FROM hz_geographies geography

        WHERE geography.geography_type='STATE'

          AND SYSDATE BETWEEN geography.start_date AND geography.end_date

          AND geography_element1_code='US'

          AND NOT EXISTS (SELECT 1 

                            FROM zx_jurisdictions_b tax_juridiction

                           WHERE tax_juridiction.zone_geography_id=geography.geography_id

                             AND tax_juridiction.tax_regime_code = '<<TAX_REGIME_CODE>>'

                             AND SYSDATE BETWEEN tax_juridiction.effective_from AND NVL(tax_juridiction.effective_to,'31-DEC-4999')

                             AND tax_juridiction.tax=geography.geography_type

)

UNION

    SELECT geography_type

      ,geography_element2_code state_code

  ,geography_element3_code county_code

  ,geography_element4_code city_code

          FROM hz_geographies geography

         WHERE geography.geography_type='COUNTY'

           AND SYSDATE BETWEEN geography.start_date AND geography.end_date

           AND geography_element1_code='US'

           AND NOT EXISTS (SELECT 1 

                             FROM zx_jurisdictions_b tax_juridiction

                            WHERE tax_juridiction.zone_geography_id=geography.geography_id

                              AND tax_juridiction.tax_regime_code='<<TAX_REGIME_CODE>>'

                              AND SYSDATE BETWEEN tax_juridiction.effective_from AND NVL(tax_juridiction.effective_to,'31-DEC-4999')

                              AND tax_juridiction.tax=geography.geography_type

)

UNION

SELECT geography_type

      ,geography_element2_code state_code

  ,geography_element3_code county_code

  ,geography_element4_code city_code

  FROM hz_geographies geography

WHERE geography.geography_type='CITY'

    AND SYSDATE BETWEEN geography.start_date AND geography.end_date

    AND geography_element1_code='US'

    AND NOT EXISTS (SELECT 1 

                      FROM zx_jurisdictions_b tax_juridiction

                     WHERE tax_juridiction.zone_geography_id = geography.geography_id

                       AND tax_juridiction.tax_regime_code='_<<TAX_REGIME_CODE>>'

                       AND SYSDATE BETWEEN tax_juridiction.effective_from AND NVL(tax_juridiction.effective_to,'31-DEC-4999')

                                   AND tax_juridiction.tax=geography.geography_type

                                )

      )

ORDER BY geography_type

        ,state_code

,county_code

,city_code

Query to list Jurisdiction's for which Tax Rates Has been defined in Oracle APPS

SELECT tax

      ,tax_jurisdiction_code

  ,geography_element2_code state_code

  ,geography_element3_code county_code

  ,geography_element4_code city_code

  FROM zx_jurisdictions_b tax_juridiction

      ,hz_geographies geography

 WHERE tax_juridiction.tax_regime_code = '<<TAX_REGIME_CODE>>'

   AND SYSDATE BETWEEN tax_juridiction.effective_from AND NVL(tax_juridiction.effective_to,'31-DEC-4999')

   AND tax_juridiction.zone_geography_id=geography.geography_id

   AND tax_juridiction.tax = geography.geography_type

   AND SYSDATE BETWEEN geography.start_date AND geography.end_date

   AND NOT EXISTS (SELECT 1 

                     FROM zx_rates_b zr

                    WHERE zr.tax_regime_code='<<TAX_REGIME_CODE>>'

                      AND zr.tax_jurisdiction_code = tax_juridiction.tax_jurisdiction_code

  )

ORDER BY tax

        ,tax_jurisdiction_code

,geography_element2_code 

,geography_element3_code

,geography_element4_code

EB-Tax Setup Tables in Oracle APPS

Tax Setup	Table Name
Tax Regimes	ZX_REGIMES_B
Taxes	ZX_TAXES_B
Tax Status	ZX_STATUS_B
Tax Rates	ZX_RATES_B
Tax Jurisdictions	ZX_JURISDICTIONS_B
Tax Rules	ZX_RULES_B

 

EB-Tax Tables in Oracle APPS

TABLE_NAME

ZX_ACCOUNTS

ZX_ACCOUNT_RATES

ZX_ACCT_TX_CLS_DEFS_ALL

ZX_API_CODE_COMBINATIONS

ZX_API_OWNER_STATUSES

ZX_API_REGISTRATIONS

ZX_COMPOUND_ERRORS

ZX_COMPOUND_ERRORS_T

ZX_CONDITIONS

ZX_CONDITION_GROUPS_B

ZX_CONDITION_GROUPS_TL

ZX_CONTENT_CHOICES_TMP

ZX_CONTENT_SOURCES

ZX_DATA_UPLOAD_INTERFACE

ZX_DETAIL_TAX_LINES_GT

ZX_DETERMINING_FACTORS_B

ZX_DET_FACTORS_TL

ZX_DET_FACTOR_TEMPL_B

ZX_DET_FACTOR_TEMPL_DTL

ZX_DET_FACTOR_TEMPL_TL

ZX_ERRORS_GT

ZX_EVENT_CLASSES_B

ZX_EVENT_CLASSES_TL

ZX_EVENT_CLASS_PARAMS

ZX_EVNT_CLS_MAPPINGS

ZX_EVNT_CLS_OPTIONS

ZX_EVNT_CLS_TYPS

ZX_EVNT_TYP_MAPPINGS

ZX_EXCEPTIONS

ZX_EXEMPTIONS

ZX_FC_CODES_B

ZX_FC_CODES_CATEG_ASSOC

ZX_FC_CODES_DENORM_B

ZX_FC_CODES_TL

ZX_FC_COUNTRY_DEFAULTS

ZX_FC_TYPES_B

ZX_FC_TYPES_REG_ASSOC

ZX_FC_TYPES_TL

ZX_FORMULA_B

ZX_FORMULA_DETAILS

ZX_FORMULA_TL

ZX_ID_TCC_MAPPING_ALL

ZX_IMPORT_TAX_LINES_GT

ZX_ITM_DISTRIBUTIONS_GT

ZX_JURISDICTIONS_B

ZX_JURISDICTIONS_GT

ZX_JURISDICTIONS_TL

ZX_LINES

ZX_LINES_DET_FACTORS

ZX_LINES_SUMMARY

ZX_PARAMETERS_B

ZX_PARAMETERS_TL

ZX_PARAM_DETAILS

ZX_PARTY_TAX_PROFILE

ZX_PARTY_TYPES

ZX_PO_REC_DIST

ZX_PROCESS_RESULTS

ZX_PRODUCT_OPTIONS_ALL

ZX_PRVDR_HDR_EXTNS_GT

ZX_PRVDR_LINE_EXTNS_GT

ZX_PTNR_LOCATION_INFO_GT

ZX_PTNR_NEG_LINE_GT

ZX_PTNR_NEG_TAX_LINE_GT

ZX_PURGE_TRANSACTIONS_GT

ZX_RATES_B

ZX_RATES_TL

ZX_REGIMES_USAGES

ZX_REGIME_RELATIONS

ZX_REGISTRATIONS

ZX_REPORTING_CODES_B

ZX_REPORTING_CODES_TL

ZX_REPORTING_TYPES_B

ZX_REPORTING_TYPES_TL

ZX_REPORT_CODES_ASSOC

ZX_REPORT_TYPES_USAGES

ZX_REP_ACTG_EXT_T

ZX_REP_CONTEXT_T

ZX_REP_MATRIX_EXT_T

ZX_REP_TRX_DETAIL_T

ZX_REP_TRX_JX_EXT_T

ZX_REVERSE_DIST_GT

ZX_REVERSE_TRX_LINES_GT

ZX_RULES_B

ZX_RULES_TL

ZX_SERVICE_TYPES

ZX_SIM_CONDITIONS

ZX_SIM_PROCESS_RESULTS

ZX_SIM_PURGE

ZX_SIM_RULES_B

ZX_SIM_RULES_TL

ZX_SIM_RULE_CONDITIONS

ZX_SIM_TRX_DISTS

ZX_SRVC_SBSCRPTN_EXCLS

ZX_SRVC_SUBSCRIPTIONS

ZX_SRVC_TYP_PARAMS

ZX_STATUS_B

ZX_STATUS_TL

ZX_SUBSCRIPTION_DETAILS

ZX_SUBSCRIPTION_OPTIONS

ZX_TAXES_B

ZX_TAXES_TL

ZX_TAX_PRIORITIES_T

ZX_TAX_RELATIONS_T

ZX_TRANSACTION

ZX_TRANSACTION_LINES

ZX_TRANSACTION_LINES_GT

ZX_TRX_HEADERS_GT

ZX_TRX_LINE_APP_REGIMES

ZX_TRX_PRE_PROC_OPTIONS_GT

ZX_TRX_TAX_LINK_GT

ZX_UPDATE_CRITERIA_RESULTS

ZX_VALIDATION_ERRORS_GT