APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on STANDARD

Line 1973: -- 'AFTER_EPD', 'STANDARD_TB_DISCOUNT',

1969: --NULL TAX_RATE_NAME_BEFORE_EXCEPTION,
1970: --NULL EXCEPTION_RATE,
1971: --'N' TAX_APPORTIONMENT_FLAG,
1972: -- DECODE(vat.taxable_basis,
1973: -- 'AFTER_EPD', 'STANDARD_TB_DISCOUNT',
1974: -- 'QUANTITY', 'STANDARD_QUANTITY',
1975: -- 'STANDARD_TB') TAXABLE_BASIS_FORMULA,
1976: -- 'STANDARD_TC' TAX_CALCULATION_FORMULA,
1977: NVL(rates.taxable_basis_formula_code,

Line 1974: -- 'QUANTITY', 'STANDARD_QUANTITY',

1970: --NULL EXCEPTION_RATE,
1971: --'N' TAX_APPORTIONMENT_FLAG,
1972: -- DECODE(vat.taxable_basis,
1973: -- 'AFTER_EPD', 'STANDARD_TB_DISCOUNT',
1974: -- 'QUANTITY', 'STANDARD_QUANTITY',
1975: -- 'STANDARD_TB') TAXABLE_BASIS_FORMULA,
1976: -- 'STANDARD_TC' TAX_CALCULATION_FORMULA,
1977: NVL(rates.taxable_basis_formula_code,
1978: taxes.def_taxable_basis_formula) TAXABLE_BASIS_FORMULA,

Line 1975: -- 'STANDARD_TB') TAXABLE_BASIS_FORMULA,

1971: --'N' TAX_APPORTIONMENT_FLAG,
1972: -- DECODE(vat.taxable_basis,
1973: -- 'AFTER_EPD', 'STANDARD_TB_DISCOUNT',
1974: -- 'QUANTITY', 'STANDARD_QUANTITY',
1975: -- 'STANDARD_TB') TAXABLE_BASIS_FORMULA,
1976: -- 'STANDARD_TC' TAX_CALCULATION_FORMULA,
1977: NVL(rates.taxable_basis_formula_code,
1978: taxes.def_taxable_basis_formula) TAXABLE_BASIS_FORMULA,
1979: NVL(taxes.def_tax_calc_formula,

Line 1976: -- 'STANDARD_TC' TAX_CALCULATION_FORMULA,

1972: -- DECODE(vat.taxable_basis,
1973: -- 'AFTER_EPD', 'STANDARD_TB_DISCOUNT',
1974: -- 'QUANTITY', 'STANDARD_QUANTITY',
1975: -- 'STANDARD_TB') TAXABLE_BASIS_FORMULA,
1976: -- 'STANDARD_TC' TAX_CALCULATION_FORMULA,
1977: NVL(rates.taxable_basis_formula_code,
1978: taxes.def_taxable_basis_formula) TAXABLE_BASIS_FORMULA,
1979: NVL(taxes.def_tax_calc_formula,
1980: 'STANDARD_TC') TAX_CALCULATION_FORMULA,

Line 1980: 'STANDARD_TC') TAX_CALCULATION_FORMULA,

1976: -- 'STANDARD_TC' TAX_CALCULATION_FORMULA,
1977: NVL(rates.taxable_basis_formula_code,
1978: taxes.def_taxable_basis_formula) TAXABLE_BASIS_FORMULA,
1979: NVL(taxes.def_tax_calc_formula,
1980: 'STANDARD_TC') TAX_CALCULATION_FORMULA,
1981: --'N' CANCEL_FLAG,
1982: --'N' PURGE_FLAG,
1983: --'N' DELETE_FLAG,
1984: --'N' SELF_ASSESSED_FLAG,

Line 2633: ,'STANDARD_TB'

2629: ,LEGAL_ENTITY_ID
2630: ,CURRENCY_CONVERSION_DATE
2631: ,CURRENCY_CONVERSION_TYPE
2632: ,CURRENCY_CONVERSION_RATE
2633: ,'STANDARD_TB'
2634: ,'STANDARD_TC'
2635: ,'Y'
2636: ,CANCEL_FLAG
2637: ,'N'

Line 2634: ,'STANDARD_TC'

2630: ,CURRENCY_CONVERSION_DATE
2631: ,CURRENCY_CONVERSION_TYPE
2632: ,CURRENCY_CONVERSION_RATE
2633: ,'STANDARD_TB'
2634: ,'STANDARD_TC'
2635: ,'Y'
2636: ,CANCEL_FLAG
2637: ,'N'
2638: ,'N'

Line 2711: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937

2707: use_nl_with_index(lines AP_INVOICE_LINES_U1)
2708: use_nl_with_index(PTP ZX_PARTY_TAX_PROFILE_U2) */
2709: NVL(lines.org_id,-99) INTERNAL_ORGANIZATION_ID
2710: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2711: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
2712: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
2713: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
2714: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
2715: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937

Line 2712: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937

2708: use_nl_with_index(PTP ZX_PARTY_TAX_PROFILE_U2) */
2709: NVL(lines.org_id,-99) INTERNAL_ORGANIZATION_ID
2710: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2711: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
2712: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
2713: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
2714: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
2715: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
2716: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937

Line 2713: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937

2709: NVL(lines.org_id,-99) INTERNAL_ORGANIZATION_ID
2710: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2711: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
2712: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
2713: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
2714: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
2715: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
2716: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
2717: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937

Line 2714: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937

2710: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2711: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
2712: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
2713: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
2714: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
2715: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
2716: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
2717: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
2718: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937

Line 2715: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937

2711: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
2712: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
2713: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
2714: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
2715: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
2716: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
2717: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
2718: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937
2719: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937

Line 2716: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937

2712: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
2713: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
2714: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
2715: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
2716: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
2717: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
2718: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937
2719: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937
2720: 'PREPAYMENT', 'PREPAYMENT INVOICES',

Line 2717: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937

2713: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
2714: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
2715: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
2716: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
2717: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
2718: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937
2719: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937
2720: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2721: 'EXPENSE REPORT', 'EXPENSE REPORTS',

Line 2718: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937

2714: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
2715: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
2716: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
2717: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
2718: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937
2719: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937
2720: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2721: 'EXPENSE REPORT', 'EXPENSE REPORTS',
2722: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE

Line 2719: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937

2715: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
2716: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
2717: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
2718: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937
2719: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937
2720: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2721: 'EXPENSE REPORT', 'EXPENSE REPORTS',
2722: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
2723: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE, 'STANDARD', 1,

Line 2723: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE, 'STANDARD', 1,

2719: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937
2720: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2721: 'EXPENSE REPORT', 'EXPENSE REPORTS',
2722: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
2723: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE, 'STANDARD', 1,
2724: 'PREPAYMENT', 7, 'EXPENSE REPORT', 2, NULL) EVENT_CLASS_MAPPING_ID
2725: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2726: 'STANDARD','STANDARD INVOICE CREATED',
2727: 'PREPAYMENT','PREPAYMENT INVOICE CREATED',

Line 2726: 'STANDARD','STANDARD INVOICE CREATED',

2722: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
2723: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE, 'STANDARD', 1,
2724: 'PREPAYMENT', 7, 'EXPENSE REPORT', 2, NULL) EVENT_CLASS_MAPPING_ID
2725: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2726: 'STANDARD','STANDARD INVOICE CREATED',
2727: 'PREPAYMENT','PREPAYMENT INVOICE CREATED',
2728: 'EXPENSE REPORT','EXPENSE REPORT CREATED',
2729: 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
2730: ,(CASE

Line 2734: 'QUICKMATCH','STANDARD','AWT')

2730: ,(CASE
2731: WHEN inv.invoice_type_lookup_code in
2732: ('ADJUSTMENT','CREDIT','DEBIT','INTEREST',
2733: 'MIXED','QUICKDEFAULT','PO PRICE ADJUST',
2734: 'QUICKMATCH','STANDARD','AWT')
2735: THEN 'PURCHASE_TRANSACTION'
2736: WHEN inv.invoice_type_lookup_code = 'PREPAYMENT'
2737: THEN 'PURCHASE_PREPAYMENTTRANSACTION'
2738: WHEN inv.invoice_type_lookup_code='EXPENSE REPORT'

Line 2746: 'STANDARD', 'STANDARD INVOICES',

2742: ,DECODE(lines.po_line_location_id,
2743: NULL, DECODE(lines.line_type_lookup_code,
2744: 'PREPAY', 'PREPAY_APPLICATION',
2745: DECODE(inv.invoice_type_lookup_code,
2746: 'STANDARD', 'STANDARD INVOICES',
2747: 'CREDIT','AP_CREDIT_MEMO',
2748: 'CREDIT MEMO REQUEST', 'AP_CREDIT_MEMO',
2749: 'DEBIT','AP_DEBIT_MEMO',
2750: 'PREPAYMENT','PREPAYMENT INVOICES',

Line 2752: 'STANDARD INVOICES'

2748: 'CREDIT MEMO REQUEST', 'AP_CREDIT_MEMO',
2749: 'DEBIT','AP_DEBIT_MEMO',
2750: 'PREPAYMENT','PREPAYMENT INVOICES',
2751: 'EXPENSE REPORT','EXPENSE REPORTS',
2752: 'STANDARD INVOICES'
2753: )
2754: ),
2755: DECODE(poll.shipment_type,
2756: 'PREPAYMENT', DECODE(poll.payment_type,

Line 2763: 'STANDARD INVOICES')

2759: 'RATE', 'FINANCING',
2760: 'LUMPSUM', 'FINANCING',
2761: DECODE(poll.matching_basis,
2762: 'AMOUNT','AMOUNT_MATCHED',
2763: 'STANDARD INVOICES')
2764: ),
2765: DECODE(poll.matching_basis,
2766: 'AMOUNT','AMOUNT_MATCHED',
2767: 'STANDARD INVOICES')

Line 2767: 'STANDARD INVOICES')

2763: 'STANDARD INVOICES')
2764: ),
2765: DECODE(poll.matching_basis,
2766: 'AMOUNT','AMOUNT_MATCHED',
2767: 'STANDARD INVOICES')
2768: )
2769: ) LINE_CLASS
2770: ,lines.line_type_lookup_code AP_LINE_LOOKUP_CODE
2771: ,lines.invoice_id TRX_ID

Line 2808: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE

2804: ,DECODE(lines.corrected_inv_id, NULL, NULL, 200) ADJUSTED_DOC_APPLICATION_ID
2805: ,DECODE(lines.corrected_inv_id, NULL, NULL,
2806: 'AP_INVOICES') ADJUSTED_DOC_ENTITY_CODE
2807: ,DECODE(lines.corrected_inv_id, NULL, NULL,
2808: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE
2809: ,lines.corrected_inv_id ADJUSTED_DOC_TRX_ID
2810: ,lines.corrected_line_number ADJUSTED_DOC_LINE_ID
2811: ,DECODE(lines.rcv_transaction_id, NULL, NULL, 707) APPLIED_TO_APPLICATION_ID
2812: ,DECODE(lines.rcv_transaction_id, NULL, NULL,

Line 2965: 'STANDARD', 'STANDARD INVOICES',

2961: (SELECT 1 FROM zx_lines_Det_Factors zxdet
2962: WHERE zxdet.APPLICATION_ID = 200
2963: AND zxdet.ENTITY_CODE = 'AP_INVOICES'
2964: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2965: 'STANDARD', 'STANDARD INVOICES',
2966: 'CREDIT' , 'STANDARD INVOICES',
2967: 'DEBIT' , 'STANDARD INVOICES',
2968: 'MIXED' , 'STANDARD INVOICES',
2969: 'ADJUSTMENT','STANDARD INVOICES',

Line 2966: 'CREDIT' , 'STANDARD INVOICES',

2962: WHERE zxdet.APPLICATION_ID = 200
2963: AND zxdet.ENTITY_CODE = 'AP_INVOICES'
2964: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2965: 'STANDARD', 'STANDARD INVOICES',
2966: 'CREDIT' , 'STANDARD INVOICES',
2967: 'DEBIT' , 'STANDARD INVOICES',
2968: 'MIXED' , 'STANDARD INVOICES',
2969: 'ADJUSTMENT','STANDARD INVOICES',
2970: 'PO PRICE ADJUST','STANDARD INVOICES',

Line 2967: 'DEBIT' , 'STANDARD INVOICES',

2963: AND zxdet.ENTITY_CODE = 'AP_INVOICES'
2964: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2965: 'STANDARD', 'STANDARD INVOICES',
2966: 'CREDIT' , 'STANDARD INVOICES',
2967: 'DEBIT' , 'STANDARD INVOICES',
2968: 'MIXED' , 'STANDARD INVOICES',
2969: 'ADJUSTMENT','STANDARD INVOICES',
2970: 'PO PRICE ADJUST','STANDARD INVOICES',
2971: 'INVOICE REQUEST','STANDARD INVOICES',

Line 2968: 'MIXED' , 'STANDARD INVOICES',

2964: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2965: 'STANDARD', 'STANDARD INVOICES',
2966: 'CREDIT' , 'STANDARD INVOICES',
2967: 'DEBIT' , 'STANDARD INVOICES',
2968: 'MIXED' , 'STANDARD INVOICES',
2969: 'ADJUSTMENT','STANDARD INVOICES',
2970: 'PO PRICE ADJUST','STANDARD INVOICES',
2971: 'INVOICE REQUEST','STANDARD INVOICES',
2972: 'CREDIT MEMO REQUEST','STANDARD INVOICES',

Line 2969: 'ADJUSTMENT','STANDARD INVOICES',

2965: 'STANDARD', 'STANDARD INVOICES',
2966: 'CREDIT' , 'STANDARD INVOICES',
2967: 'DEBIT' , 'STANDARD INVOICES',
2968: 'MIXED' , 'STANDARD INVOICES',
2969: 'ADJUSTMENT','STANDARD INVOICES',
2970: 'PO PRICE ADJUST','STANDARD INVOICES',
2971: 'INVOICE REQUEST','STANDARD INVOICES',
2972: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
2973: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',

Line 2970: 'PO PRICE ADJUST','STANDARD INVOICES',

2966: 'CREDIT' , 'STANDARD INVOICES',
2967: 'DEBIT' , 'STANDARD INVOICES',
2968: 'MIXED' , 'STANDARD INVOICES',
2969: 'ADJUSTMENT','STANDARD INVOICES',
2970: 'PO PRICE ADJUST','STANDARD INVOICES',
2971: 'INVOICE REQUEST','STANDARD INVOICES',
2972: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
2973: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
2974: 'PREPAYMENT', 'PREPAYMENT INVOICES',

Line 2971: 'INVOICE REQUEST','STANDARD INVOICES',

2967: 'DEBIT' , 'STANDARD INVOICES',
2968: 'MIXED' , 'STANDARD INVOICES',
2969: 'ADJUSTMENT','STANDARD INVOICES',
2970: 'PO PRICE ADJUST','STANDARD INVOICES',
2971: 'INVOICE REQUEST','STANDARD INVOICES',
2972: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
2973: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
2974: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2975: 'EXPENSE REPORT', 'EXPENSE REPORTS',

Line 2972: 'CREDIT MEMO REQUEST','STANDARD INVOICES',

2968: 'MIXED' , 'STANDARD INVOICES',
2969: 'ADJUSTMENT','STANDARD INVOICES',
2970: 'PO PRICE ADJUST','STANDARD INVOICES',
2971: 'INVOICE REQUEST','STANDARD INVOICES',
2972: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
2973: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
2974: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2975: 'EXPENSE REPORT', 'EXPENSE REPORTS',
2976: 'INTEREST INVOICE', 'INTEREST INVOICES','NA')

Line 2973: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',

2969: 'ADJUSTMENT','STANDARD INVOICES',
2970: 'PO PRICE ADJUST','STANDARD INVOICES',
2971: 'INVOICE REQUEST','STANDARD INVOICES',
2972: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
2973: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
2974: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2975: 'EXPENSE REPORT', 'EXPENSE REPORTS',
2976: 'INTEREST INVOICE', 'INTEREST INVOICES','NA')
2977: AND zxdet.TRX_ID = inv.invoice_id);

Line 3501: ,'STANDARD_TC'

3497: 'REC_TAX', REC_NREC_TAX_AMT_TAX_CURR, NULL)
3498: ,TAX_AMT
3499: ,TAX_AMT_FUNCL_CURR
3500: ,TAX_AMT_TAX_CURR
3501: ,'STANDARD_TC'
3502: ,TAX_DATE
3503: ,TAX_DETERMINE_DATE
3504: ,TAX_POINT_DATE
3505: ,TAXABLE_AMT

Line 3508: ,'STANDARD_TB'

3504: ,TAX_POINT_DATE
3505: ,TAXABLE_AMT
3506: ,TAXABLE_AMT_FUNCL_CURR
3507: ,TAXABLE_AMT_TAX_CURR
3508: ,'STANDARD_TB'
3509: ,TRX_DATE
3510: ,TRX_LINE_DATE
3511: ,TRX_LINE_QUANTITY
3512: ,'Y'

Line 3592: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937

3588: use_nl_with_index(status ZX_STATUS_B_U2)
3589: use_nl_with_index(ptp ZX_PARTY_TAX_PROFILE_U2) */
3590: NVL(lines1.org_id,-99) INTERNAL_ORGANIZATION_ID
3591: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3592: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
3593: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
3594: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
3595: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
3596: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937

Line 3593: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937

3589: use_nl_with_index(ptp ZX_PARTY_TAX_PROFILE_U2) */
3590: NVL(lines1.org_id,-99) INTERNAL_ORGANIZATION_ID
3591: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3592: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
3593: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
3594: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
3595: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
3596: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
3597: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937

Line 3594: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937

3590: NVL(lines1.org_id,-99) INTERNAL_ORGANIZATION_ID
3591: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3592: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
3593: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
3594: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
3595: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
3596: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
3597: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
3598: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937

Line 3595: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937

3591: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3592: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
3593: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
3594: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
3595: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
3596: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
3597: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
3598: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
3599: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937

Line 3596: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937

3592: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
3593: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
3594: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
3595: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
3596: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
3597: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
3598: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
3599: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937
3600: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937

Line 3597: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937

3593: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
3594: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
3595: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
3596: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
3597: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
3598: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
3599: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937
3600: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937
3601: 'PREPAYMENT', 'PREPAYMENT INVOICES',

Line 3598: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937

3594: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
3595: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
3596: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
3597: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
3598: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
3599: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937
3600: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937
3601: 'PREPAYMENT', 'PREPAYMENT INVOICES',
3602: 'EXPENSE REPORT', 'EXPENSE REPORTS',

Line 3599: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937

3595: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
3596: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
3597: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
3598: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
3599: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937
3600: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937
3601: 'PREPAYMENT', 'PREPAYMENT INVOICES',
3602: 'EXPENSE REPORT', 'EXPENSE REPORTS',
3603: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE

Line 3600: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937

3596: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
3597: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
3598: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
3599: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937
3600: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937
3601: 'PREPAYMENT', 'PREPAYMENT INVOICES',
3602: 'EXPENSE REPORT', 'EXPENSE REPORTS',
3603: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
3604: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,

Line 3605: 'STANDARD','STANDARD INVOICE CREATED',

3601: 'PREPAYMENT', 'PREPAYMENT INVOICES',
3602: 'EXPENSE REPORT', 'EXPENSE REPORTS',
3603: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
3604: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3605: 'STANDARD','STANDARD INVOICE CREATED',
3606: 'PREPAYMENT','PREPAYMENT INVOICE CREATED',
3607: 'EXPENSE REPORT','EXPENSE REPORT CREATED',
3608: 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
3609: ,(CASE WHEN inv.invoice_type_lookup_code in

Line 3612: 'QUICKMATCH','STANDARD','AWT')

3608: 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
3609: ,(CASE WHEN inv.invoice_type_lookup_code in
3610: ('ADJUSTMENT','CREDIT','DEBIT','INTEREST',
3611: 'MIXED','QUICKDEFAULT','PO PRICE ADJUST',
3612: 'QUICKMATCH','STANDARD','AWT')
3613: THEN 'PURCHASE_TRANSACTION'
3614: WHEN (inv.invoice_type_lookup_code =
3615: 'PREPAYMENT')
3616: THEN 'PURCHASE_PREPAYMENTTRANSACTION'

Line 3645: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE

3641: ,DECODE(lines1.corrected_inv_id, NULL, NULL, 200) ADJUSTED_DOC_APPLICATION_ID
3642: ,DECODE(lines1.corrected_inv_id, NULL, NULL,
3643: 'AP_INVOICES') ADJUSTED_DOC_ENTITY_CODE
3644: ,DECODE(lines1.corrected_inv_id, NULL, NULL,
3645: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE
3646: ,lines1.corrected_inv_id ADJUSTED_DOC_TRX_ID
3647: ,lines1.Corrected_Line_Number ADJUSTED_DOC_LINE_ID
3648: ,DECODE(lines1.rcv_transaction_id, NULL, NULL, 707) APPLIED_TO_APPLICATION_ID
3649: ,DECODE(lines1.rcv_transaction_id, NULL, NULL,

Line 3724: 'REC_TAX', 'STANDARD', NULL) RECOVERY_TYPE_CODE

3720: ,ap_dists.base_amount REC_NREC_TAX_AMT_TAX_CURR
3721: ,DECODE(ap_dists.line_type_lookup_code,
3722: 'REC_TAX', 'AD_HOC_RECOVERY', NULL) RECOVERY_RATE_CODE
3723: ,DECODE(ap_dists.line_type_lookup_code,
3724: 'REC_TAX', 'STANDARD', NULL) RECOVERY_TYPE_CODE
3725: ,NVL(ap_dists.amount,0) TAX_AMT
3726: ,ap_dists.base_amount TAX_AMT_FUNCL_CURR
3727: ,ap_dists.base_amount TAX_AMT_TAX_CURR
3728: ,ap_dists1.po_distribution_id REF_DOC_DIST_ID

Line 3852: 'STANDARD', 'STANDARD INVOICES',

3848: AND NOT EXISTS
3849: (SELECT 1 FROM zx_lines zxl
3850: WHERE zxl.application_id = 200
3851: AND zxl.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3852: 'STANDARD', 'STANDARD INVOICES',
3853: 'CREDIT' , 'STANDARD INVOICES',
3854: 'DEBIT' , 'STANDARD INVOICES',
3855: 'MIXED' , 'STANDARD INVOICES',
3856: 'ADJUSTMENT','STANDARD INVOICES',

Line 3853: 'CREDIT' , 'STANDARD INVOICES',

3849: (SELECT 1 FROM zx_lines zxl
3850: WHERE zxl.application_id = 200
3851: AND zxl.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3852: 'STANDARD', 'STANDARD INVOICES',
3853: 'CREDIT' , 'STANDARD INVOICES',
3854: 'DEBIT' , 'STANDARD INVOICES',
3855: 'MIXED' , 'STANDARD INVOICES',
3856: 'ADJUSTMENT','STANDARD INVOICES',
3857: 'PO PRICE ADJUST','STANDARD INVOICES',

Line 3854: 'DEBIT' , 'STANDARD INVOICES',

3850: WHERE zxl.application_id = 200
3851: AND zxl.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3852: 'STANDARD', 'STANDARD INVOICES',
3853: 'CREDIT' , 'STANDARD INVOICES',
3854: 'DEBIT' , 'STANDARD INVOICES',
3855: 'MIXED' , 'STANDARD INVOICES',
3856: 'ADJUSTMENT','STANDARD INVOICES',
3857: 'PO PRICE ADJUST','STANDARD INVOICES',
3858: 'INVOICE REQUEST','STANDARD INVOICES',

Line 3855: 'MIXED' , 'STANDARD INVOICES',

3851: AND zxl.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3852: 'STANDARD', 'STANDARD INVOICES',
3853: 'CREDIT' , 'STANDARD INVOICES',
3854: 'DEBIT' , 'STANDARD INVOICES',
3855: 'MIXED' , 'STANDARD INVOICES',
3856: 'ADJUSTMENT','STANDARD INVOICES',
3857: 'PO PRICE ADJUST','STANDARD INVOICES',
3858: 'INVOICE REQUEST','STANDARD INVOICES',
3859: 'CREDIT MEMO REQUEST','STANDARD INVOICES',

Line 3856: 'ADJUSTMENT','STANDARD INVOICES',

3852: 'STANDARD', 'STANDARD INVOICES',
3853: 'CREDIT' , 'STANDARD INVOICES',
3854: 'DEBIT' , 'STANDARD INVOICES',
3855: 'MIXED' , 'STANDARD INVOICES',
3856: 'ADJUSTMENT','STANDARD INVOICES',
3857: 'PO PRICE ADJUST','STANDARD INVOICES',
3858: 'INVOICE REQUEST','STANDARD INVOICES',
3859: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
3860: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',

Line 3857: 'PO PRICE ADJUST','STANDARD INVOICES',

3853: 'CREDIT' , 'STANDARD INVOICES',
3854: 'DEBIT' , 'STANDARD INVOICES',
3855: 'MIXED' , 'STANDARD INVOICES',
3856: 'ADJUSTMENT','STANDARD INVOICES',
3857: 'PO PRICE ADJUST','STANDARD INVOICES',
3858: 'INVOICE REQUEST','STANDARD INVOICES',
3859: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
3860: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
3861: 'PREPAYMENT', 'PREPAYMENT INVOICES',

Line 3858: 'INVOICE REQUEST','STANDARD INVOICES',

3854: 'DEBIT' , 'STANDARD INVOICES',
3855: 'MIXED' , 'STANDARD INVOICES',
3856: 'ADJUSTMENT','STANDARD INVOICES',
3857: 'PO PRICE ADJUST','STANDARD INVOICES',
3858: 'INVOICE REQUEST','STANDARD INVOICES',
3859: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
3860: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
3861: 'PREPAYMENT', 'PREPAYMENT INVOICES',
3862: 'EXPENSE REPORT', 'EXPENSE REPORTS',

Line 3859: 'CREDIT MEMO REQUEST','STANDARD INVOICES',

3855: 'MIXED' , 'STANDARD INVOICES',
3856: 'ADJUSTMENT','STANDARD INVOICES',
3857: 'PO PRICE ADJUST','STANDARD INVOICES',
3858: 'INVOICE REQUEST','STANDARD INVOICES',
3859: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
3860: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
3861: 'PREPAYMENT', 'PREPAYMENT INVOICES',
3862: 'EXPENSE REPORT', 'EXPENSE REPORTS',
3863: 'INTEREST INVOICE', 'INTEREST INVOICES','NA')

Line 3860: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',

3856: 'ADJUSTMENT','STANDARD INVOICES',
3857: 'PO PRICE ADJUST','STANDARD INVOICES',
3858: 'INVOICE REQUEST','STANDARD INVOICES',
3859: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
3860: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
3861: 'PREPAYMENT', 'PREPAYMENT INVOICES',
3862: 'EXPENSE REPORT', 'EXPENSE REPORTS',
3863: 'INTEREST INVOICE', 'INTEREST INVOICES','NA')
3864: AND zxl.trx_id = inv.invoice_id

Line 4905: 'STANDARD_TC' TAX_CALCULATION_FORMULA,

4901: rates.tax
4902: ORDER BY atg.tax_code_id),
4903: 1) TAX_APPORTIONMENT_LINE_NUMBER,
4904: -- NULL TAX_BASE_MODIFIER_RATE,
4905: 'STANDARD_TC' TAX_CALCULATION_FORMULA,
4906: -- NULL TAX_CODE,
4907: taxes.tax_currency_code TAX_CURRENCY_CODE,
4908: poh.rate_date TAX_CURRENCY_CONVERSION_DATE,
4909: poh.rate TAX_CURRENCY_CONVERSION_RATE,

Line 4955: 'STANDARD_TB' TAXABLE_BASIS_FORMULA ,

4951: -- NULL TAX_TYPE_CODE,
4952: -- NULL TAXABLE_AMT,
4953: -- NULL TAXABLE_AMT_FUNCL_CURR,
4954: -- NULL TAXABLE_AMT_TAX_CURR,
4955: 'STANDARD_TB' TAXABLE_BASIS_FORMULA ,
4956: -- NULL TAXING_JURIS_GEOGRAPHY_ID ,
4957: -- NULL THRESH_RESULT_ID,
4958: NVL(poh.currency_code,
4959: poh.base_currency_code) TRX_CURRENCY_CODE,

Line 5315: 'STANDARD')) RECOVERY_TYPE_CODE,

5311: 'AD_HOC_RECOVERY') RECOVERY_RATE_CODE,
5312: rates.tax_rate_id RECOVERY_RATE_ID,
5313: DECODE(tmp.rec_flag,'N', NULL,
5314: NVL(rates.recovery_type_code,
5315: 'STANDARD')) RECOVERY_TYPE_CODE,
5316: -- NULL RECOVERY_TYPE_ID,
5317: -- NULL REF_DOC_CURR_CONV_RATE,
5318: -- NULL REF_DOC_DIST_ID,
5319: -- NULL REF_DOC_PER_UNIT_NREC_TAX_AMT,

Line 5450: AND rates.recovery_type_code(+) = 'STANDARD'

5446: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
5447: AND rates.tax(+) = pohzd.tax
5448: AND rates.content_owner_id(+) = pohzd.content_owner_id
5449: AND rates.rate_type_code(+) = 'RECOVERY'
5450: AND rates.recovery_type_code(+) = 'STANDARD'
5451: AND rates.active_flag(+) = 'Y'
5452: AND rates.effective_from(+) <= sysdate
5453: AND rates.record_type_code(+) = 'MIGRATED'
5454: AND rates.percentage_rate(+) = NVL(pohzd.p_recovery_rate, pohzd.d_rec_rate)