eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on STANDARD

Line 2028: -- 'AFTER_EPD', 'STANDARD_TB_DISCOUNT',

2024: --NULL TAX_RATE_NAME_BEFORE_EXCEPTION,
2025: --NULL EXCEPTION_RATE,
2026: --'N' TAX_APPORTIONMENT_FLAG,
2027: -- DECODE(vat.taxable_basis,
2028: -- 'AFTER_EPD', 'STANDARD_TB_DISCOUNT',
2029: -- 'QUANTITY', 'STANDARD_QUANTITY',
2030: -- 'STANDARD_TB') TAXABLE_BASIS_FORMULA,
2031: -- 'STANDARD_TC' TAX_CALCULATION_FORMULA,
2032: NVL(rates.taxable_basis_formula_code,

Line 2029: -- 'QUANTITY', 'STANDARD_QUANTITY',

2025: --NULL EXCEPTION_RATE,
2026: --'N' TAX_APPORTIONMENT_FLAG,
2027: -- DECODE(vat.taxable_basis,
2028: -- 'AFTER_EPD', 'STANDARD_TB_DISCOUNT',
2029: -- 'QUANTITY', 'STANDARD_QUANTITY',
2030: -- 'STANDARD_TB') TAXABLE_BASIS_FORMULA,
2031: -- 'STANDARD_TC' TAX_CALCULATION_FORMULA,
2032: NVL(rates.taxable_basis_formula_code,
2033: taxes.def_taxable_basis_formula) TAXABLE_BASIS_FORMULA,

Line 2030: -- 'STANDARD_TB') TAXABLE_BASIS_FORMULA,

2026: --'N' TAX_APPORTIONMENT_FLAG,
2027: -- DECODE(vat.taxable_basis,
2028: -- 'AFTER_EPD', 'STANDARD_TB_DISCOUNT',
2029: -- 'QUANTITY', 'STANDARD_QUANTITY',
2030: -- 'STANDARD_TB') TAXABLE_BASIS_FORMULA,
2031: -- 'STANDARD_TC' TAX_CALCULATION_FORMULA,
2032: NVL(rates.taxable_basis_formula_code,
2033: taxes.def_taxable_basis_formula) TAXABLE_BASIS_FORMULA,
2034: NVL(taxes.def_tax_calc_formula,

Line 2031: -- 'STANDARD_TC' TAX_CALCULATION_FORMULA,

2027: -- DECODE(vat.taxable_basis,
2028: -- 'AFTER_EPD', 'STANDARD_TB_DISCOUNT',
2029: -- 'QUANTITY', 'STANDARD_QUANTITY',
2030: -- 'STANDARD_TB') TAXABLE_BASIS_FORMULA,
2031: -- 'STANDARD_TC' TAX_CALCULATION_FORMULA,
2032: NVL(rates.taxable_basis_formula_code,
2033: taxes.def_taxable_basis_formula) TAXABLE_BASIS_FORMULA,
2034: NVL(taxes.def_tax_calc_formula,
2035: 'STANDARD_TC') TAX_CALCULATION_FORMULA,

Line 2035: 'STANDARD_TC') TAX_CALCULATION_FORMULA,

2031: -- 'STANDARD_TC' TAX_CALCULATION_FORMULA,
2032: NVL(rates.taxable_basis_formula_code,
2033: taxes.def_taxable_basis_formula) TAXABLE_BASIS_FORMULA,
2034: NVL(taxes.def_tax_calc_formula,
2035: 'STANDARD_TC') TAX_CALCULATION_FORMULA,
2036: --'N' CANCEL_FLAG,
2037: --'N' PURGE_FLAG,
2038: --'N' DELETE_FLAG,
2039: --'N' SELF_ASSESSED_FLAG,

Line 2691: --Bug 9037817,'STANDARD_TB'

2687: ,LEGAL_ENTITY_ID
2688: ,CURRENCY_CONVERSION_DATE
2689: ,CURRENCY_CONVERSION_TYPE
2690: ,CURRENCY_CONVERSION_RATE
2691: --Bug 9037817,'STANDARD_TB'
2692: ,TAXABLE_BASIS_FORMULA
2693: ,'STANDARD_TC'
2694: ,'Y'
2695: ,CANCEL_FLAG

Line 2693: ,'STANDARD_TC'

2689: ,CURRENCY_CONVERSION_TYPE
2690: ,CURRENCY_CONVERSION_RATE
2691: --Bug 9037817,'STANDARD_TB'
2692: ,TAXABLE_BASIS_FORMULA
2693: ,'STANDARD_TC'
2694: ,'Y'
2695: ,CANCEL_FLAG
2696: ,'N'
2697: ,'N'

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

2766: use_nl_with_index(lines AP_INVOICE_LINES_U1)
2767: use_nl_with_index(PTP ZX_PARTY_TAX_PROFILE_U2) */
2768: NVL(lines.org_id,-99) INTERNAL_ORGANIZATION_ID
2769: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2770: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
2771: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
2772: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
2773: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
2774: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937

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

2767: use_nl_with_index(PTP ZX_PARTY_TAX_PROFILE_U2) */
2768: NVL(lines.org_id,-99) INTERNAL_ORGANIZATION_ID
2769: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2770: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
2771: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
2772: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
2773: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
2774: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
2775: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937

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

2768: NVL(lines.org_id,-99) INTERNAL_ORGANIZATION_ID
2769: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2770: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
2771: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
2772: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
2773: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
2774: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
2775: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
2776: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937

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

2769: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2770: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
2771: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
2772: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
2773: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
2774: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
2775: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
2776: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
2777: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937

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

2770: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
2771: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
2772: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
2773: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
2774: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
2775: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
2776: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
2777: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937
2778: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937

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

2771: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
2772: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
2773: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
2774: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
2775: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
2776: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
2777: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937
2778: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937
2779: 'PREPAYMENT', 'PREPAYMENT INVOICES',

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

2772: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
2773: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
2774: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
2775: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
2776: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
2777: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937
2778: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937
2779: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2780: 'EXPENSE REPORT', 'EXPENSE REPORTS',

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

2773: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
2774: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
2775: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
2776: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
2777: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937
2778: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937
2779: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2780: 'EXPENSE REPORT', 'EXPENSE REPORTS',
2781: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE

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

2774: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
2775: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
2776: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
2777: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937
2778: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937
2779: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2780: 'EXPENSE REPORT', 'EXPENSE REPORTS',
2781: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
2782: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE, 'STANDARD', 1,

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

2778: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937
2779: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2780: 'EXPENSE REPORT', 'EXPENSE REPORTS',
2781: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
2782: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE, 'STANDARD', 1,
2783: 'PREPAYMENT', 7, 'EXPENSE REPORT', 2, NULL) EVENT_CLASS_MAPPING_ID
2784: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2785: 'STANDARD','STANDARD INVOICE CREATED',
2786: 'PREPAYMENT','PREPAYMENT INVOICE CREATED',

Line 2785: 'STANDARD','STANDARD INVOICE CREATED',

2781: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
2782: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE, 'STANDARD', 1,
2783: 'PREPAYMENT', 7, 'EXPENSE REPORT', 2, NULL) EVENT_CLASS_MAPPING_ID
2784: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2785: 'STANDARD','STANDARD INVOICE CREATED',
2786: 'PREPAYMENT','PREPAYMENT INVOICE CREATED',
2787: 'EXPENSE REPORT','EXPENSE REPORT CREATED',
2788: 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
2789: ,(CASE

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

2789: ,(CASE
2790: WHEN inv.invoice_type_lookup_code in
2791: ('ADJUSTMENT','CREDIT','DEBIT','INTEREST',
2792: 'MIXED','QUICKDEFAULT','PO PRICE ADJUST',
2793: 'QUICKMATCH','STANDARD','AWT')
2794: THEN 'PURCHASE_TRANSACTION'
2795: WHEN inv.invoice_type_lookup_code = 'PREPAYMENT'
2796: THEN 'PURCHASE_PREPAYMENTTRANSACTION'
2797: WHEN inv.invoice_type_lookup_code='EXPENSE REPORT'

Line 2805: 'STANDARD', 'STANDARD INVOICES',

2801: ,DECODE(lines.po_line_location_id,
2802: NULL, DECODE(lines.line_type_lookup_code,
2803: 'PREPAY', 'PREPAY_APPLICATION',
2804: DECODE(inv.invoice_type_lookup_code,
2805: 'STANDARD', 'STANDARD INVOICES',
2806: 'CREDIT','AP_CREDIT_MEMO',
2807: 'CREDIT MEMO REQUEST', 'AP_CREDIT_MEMO',
2808: 'DEBIT','AP_DEBIT_MEMO',
2809: 'PREPAYMENT','PREPAYMENT INVOICES',

Line 2811: 'STANDARD INVOICES'

2807: 'CREDIT MEMO REQUEST', 'AP_CREDIT_MEMO',
2808: 'DEBIT','AP_DEBIT_MEMO',
2809: 'PREPAYMENT','PREPAYMENT INVOICES',
2810: 'EXPENSE REPORT','EXPENSE REPORTS',
2811: 'STANDARD INVOICES'
2812: )
2813: ),
2814: DECODE(poll.shipment_type,
2815: 'PREPAYMENT', DECODE(poll.payment_type,

Line 2822: 'STANDARD INVOICES')

2818: 'RATE', 'FINANCING',
2819: 'LUMPSUM', 'FINANCING',
2820: DECODE(poll.matching_basis,
2821: 'AMOUNT','AMOUNT_MATCHED',
2822: 'STANDARD INVOICES')
2823: ),
2824: DECODE(poll.matching_basis,
2825: 'AMOUNT','AMOUNT_MATCHED',
2826: 'STANDARD INVOICES')

Line 2826: 'STANDARD INVOICES')

2822: 'STANDARD INVOICES')
2823: ),
2824: DECODE(poll.matching_basis,
2825: 'AMOUNT','AMOUNT_MATCHED',
2826: 'STANDARD INVOICES')
2827: )
2828: ) LINE_CLASS
2829: ,lines.line_type_lookup_code AP_LINE_LOOKUP_CODE
2830: ,lines.invoice_id TRX_ID

Line 2867: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE

2863: ,DECODE(lines.corrected_inv_id, NULL, NULL, 200) ADJUSTED_DOC_APPLICATION_ID
2864: ,DECODE(lines.corrected_inv_id, NULL, NULL,
2865: 'AP_INVOICES') ADJUSTED_DOC_ENTITY_CODE
2866: ,DECODE(lines.corrected_inv_id, NULL, NULL,
2867: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE
2868: ,lines.corrected_inv_id ADJUSTED_DOC_TRX_ID
2869: ,lines.corrected_line_number ADJUSTED_DOC_LINE_ID
2870: ,DECODE(lines.rcv_transaction_id, NULL, NULL, 707) APPLIED_TO_APPLICATION_ID
2871: ,DECODE(lines.rcv_transaction_id, NULL, NULL,

Line 2914: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','PRORATED_TB','STANDARD_TB') TAXABLE_BASIS_FORMULA

2910: ,inv.exchange_date CURRENCY_CONVERSION_DATE
2911: ,inv.exchange_rate CURRENCY_CONVERSION_RATE
2912: ,inv.exchange_rate_type CURRENCY_CONVERSION_TYPE
2913: --Bug 9037817
2914: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','PRORATED_TB','STANDARD_TB') TAXABLE_BASIS_FORMULA
2915: ,fnd_curr.minimum_accountable_unit MINIMUM_ACCOUNTABLE_UNIT
2916: ,NVL(fnd_curr.precision,0) PRECISION
2917: ,DECODE(NVL(lines.po_release_id, lines.po_header_id),
2918: NULL, NULL, 201) REF_DOC_APPLICATION_ID

Line 3026: 'STANDARD', 'STANDARD INVOICES',

3022: (SELECT 1 FROM zx_lines_Det_Factors zxdet
3023: WHERE zxdet.APPLICATION_ID = 200
3024: AND zxdet.ENTITY_CODE = 'AP_INVOICES'
3025: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3026: 'STANDARD', 'STANDARD INVOICES',
3027: 'CREDIT' , 'STANDARD INVOICES',
3028: 'DEBIT' , 'STANDARD INVOICES',
3029: 'MIXED' , 'STANDARD INVOICES',
3030: 'ADJUSTMENT','STANDARD INVOICES',

Line 3027: 'CREDIT' , 'STANDARD INVOICES',

3023: WHERE zxdet.APPLICATION_ID = 200
3024: AND zxdet.ENTITY_CODE = 'AP_INVOICES'
3025: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3026: 'STANDARD', 'STANDARD INVOICES',
3027: 'CREDIT' , 'STANDARD INVOICES',
3028: 'DEBIT' , 'STANDARD INVOICES',
3029: 'MIXED' , 'STANDARD INVOICES',
3030: 'ADJUSTMENT','STANDARD INVOICES',
3031: 'PO PRICE ADJUST','STANDARD INVOICES',

Line 3028: 'DEBIT' , 'STANDARD INVOICES',

3024: AND zxdet.ENTITY_CODE = 'AP_INVOICES'
3025: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3026: 'STANDARD', 'STANDARD INVOICES',
3027: 'CREDIT' , 'STANDARD INVOICES',
3028: 'DEBIT' , 'STANDARD INVOICES',
3029: 'MIXED' , 'STANDARD INVOICES',
3030: 'ADJUSTMENT','STANDARD INVOICES',
3031: 'PO PRICE ADJUST','STANDARD INVOICES',
3032: 'INVOICE REQUEST','STANDARD INVOICES',

Line 3029: 'MIXED' , 'STANDARD INVOICES',

3025: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3026: 'STANDARD', 'STANDARD INVOICES',
3027: 'CREDIT' , 'STANDARD INVOICES',
3028: 'DEBIT' , 'STANDARD INVOICES',
3029: 'MIXED' , 'STANDARD INVOICES',
3030: 'ADJUSTMENT','STANDARD INVOICES',
3031: 'PO PRICE ADJUST','STANDARD INVOICES',
3032: 'INVOICE REQUEST','STANDARD INVOICES',
3033: 'CREDIT MEMO REQUEST','STANDARD INVOICES',

Line 3030: 'ADJUSTMENT','STANDARD INVOICES',

3026: 'STANDARD', 'STANDARD INVOICES',
3027: 'CREDIT' , 'STANDARD INVOICES',
3028: 'DEBIT' , 'STANDARD INVOICES',
3029: 'MIXED' , 'STANDARD INVOICES',
3030: 'ADJUSTMENT','STANDARD INVOICES',
3031: 'PO PRICE ADJUST','STANDARD INVOICES',
3032: 'INVOICE REQUEST','STANDARD INVOICES',
3033: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
3034: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',

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

3027: 'CREDIT' , 'STANDARD INVOICES',
3028: 'DEBIT' , 'STANDARD INVOICES',
3029: 'MIXED' , 'STANDARD INVOICES',
3030: 'ADJUSTMENT','STANDARD INVOICES',
3031: 'PO PRICE ADJUST','STANDARD INVOICES',
3032: 'INVOICE REQUEST','STANDARD INVOICES',
3033: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
3034: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
3035: 'PREPAYMENT', 'PREPAYMENT INVOICES',

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

3028: 'DEBIT' , 'STANDARD INVOICES',
3029: 'MIXED' , 'STANDARD INVOICES',
3030: 'ADJUSTMENT','STANDARD INVOICES',
3031: 'PO PRICE ADJUST','STANDARD INVOICES',
3032: 'INVOICE REQUEST','STANDARD INVOICES',
3033: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
3034: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
3035: 'PREPAYMENT', 'PREPAYMENT INVOICES',
3036: 'EXPENSE REPORT', 'EXPENSE REPORTS',

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

3029: 'MIXED' , 'STANDARD INVOICES',
3030: 'ADJUSTMENT','STANDARD INVOICES',
3031: 'PO PRICE ADJUST','STANDARD INVOICES',
3032: 'INVOICE REQUEST','STANDARD INVOICES',
3033: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
3034: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
3035: 'PREPAYMENT', 'PREPAYMENT INVOICES',
3036: 'EXPENSE REPORT', 'EXPENSE REPORTS',
3037: 'INTEREST INVOICE', 'INTEREST INVOICES','NA')

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

3030: 'ADJUSTMENT','STANDARD INVOICES',
3031: 'PO PRICE ADJUST','STANDARD INVOICES',
3032: 'INVOICE REQUEST','STANDARD INVOICES',
3033: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
3034: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
3035: 'PREPAYMENT', 'PREPAYMENT INVOICES',
3036: 'EXPENSE REPORT', 'EXPENSE REPORTS',
3037: 'INTEREST INVOICE', 'INTEREST INVOICES','NA')
3038: AND zxdet.TRX_ID = inv.invoice_id);

Line 3563: ,'STANDARD_TC'

3559: 'REC_TAX', REC_NREC_TAX_AMT_TAX_CURR, NULL)
3560: ,TAX_AMT
3561: ,TAX_AMT_FUNCL_CURR
3562: ,TAX_AMT_TAX_CURR
3563: ,'STANDARD_TC'
3564: ,TAX_DATE
3565: ,TAX_DETERMINE_DATE
3566: ,TAX_POINT_DATE
3567: ,TAXABLE_AMT

Line 3570: --Bug 9037817,'STANDARD_TB'

3566: ,TAX_POINT_DATE
3567: ,TAXABLE_AMT
3568: ,TAXABLE_AMT_FUNCL_CURR
3569: ,TAXABLE_AMT_TAX_CURR
3570: --Bug 9037817,'STANDARD_TB'
3571: ,TAXABLE_BASIS_FORMULA
3572: ,TRX_DATE
3573: ,TRX_LINE_DATE
3574: ,TRX_LINE_QUANTITY

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

3652: use_nl_with_index(status ZX_STATUS_B_U2)
3653: use_nl_with_index(ptp ZX_PARTY_TAX_PROFILE_U2) */
3654: NVL(lines1.org_id,-99) INTERNAL_ORGANIZATION_ID
3655: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3656: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
3657: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
3658: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
3659: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
3660: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937

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

3653: use_nl_with_index(ptp ZX_PARTY_TAX_PROFILE_U2) */
3654: NVL(lines1.org_id,-99) INTERNAL_ORGANIZATION_ID
3655: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3656: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
3657: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
3658: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
3659: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
3660: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
3661: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937

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

3654: NVL(lines1.org_id,-99) INTERNAL_ORGANIZATION_ID
3655: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3656: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
3657: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
3658: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
3659: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
3660: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
3661: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
3662: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937

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

3655: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3656: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
3657: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
3658: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
3659: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
3660: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
3661: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
3662: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
3663: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937

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

3656: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937
3657: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
3658: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
3659: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
3660: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
3661: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
3662: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
3663: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937
3664: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937

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

3657: 'CREDIT' , 'STANDARD INVOICES', --Bug 5859937
3658: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
3659: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
3660: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
3661: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
3662: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
3663: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937
3664: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937
3665: 'PREPAYMENT', 'PREPAYMENT INVOICES',

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

3658: 'DEBIT' , 'STANDARD INVOICES', --Bug 5859937
3659: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
3660: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
3661: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
3662: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
3663: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937
3664: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937
3665: 'PREPAYMENT', 'PREPAYMENT INVOICES',
3666: 'EXPENSE REPORT', 'EXPENSE REPORTS',

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

3659: 'MIXED' , 'STANDARD INVOICES', --Bug 5859937
3660: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
3661: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
3662: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
3663: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937
3664: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937
3665: 'PREPAYMENT', 'PREPAYMENT INVOICES',
3666: 'EXPENSE REPORT', 'EXPENSE REPORTS',
3667: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE

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

3660: 'ADJUSTMENT','STANDARD INVOICES', --Bug 5859937
3661: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 5859937
3662: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 5859937
3663: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 5859937
3664: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 5859937
3665: 'PREPAYMENT', 'PREPAYMENT INVOICES',
3666: 'EXPENSE REPORT', 'EXPENSE REPORTS',
3667: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
3668: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,

Line 3669: 'STANDARD','STANDARD INVOICE CREATED',

3665: 'PREPAYMENT', 'PREPAYMENT INVOICES',
3666: 'EXPENSE REPORT', 'EXPENSE REPORTS',
3667: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
3668: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3669: 'STANDARD','STANDARD INVOICE CREATED',
3670: 'PREPAYMENT','PREPAYMENT INVOICE CREATED',
3671: 'EXPENSE REPORT','EXPENSE REPORT CREATED',
3672: 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
3673: ,(CASE WHEN inv.invoice_type_lookup_code in

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

3672: 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
3673: ,(CASE WHEN inv.invoice_type_lookup_code in
3674: ('ADJUSTMENT','CREDIT','DEBIT','INTEREST',
3675: 'MIXED','QUICKDEFAULT','PO PRICE ADJUST',
3676: 'QUICKMATCH','STANDARD','AWT')
3677: THEN 'PURCHASE_TRANSACTION'
3678: WHEN (inv.invoice_type_lookup_code =
3679: 'PREPAYMENT')
3680: THEN 'PURCHASE_PREPAYMENTTRANSACTION'

Line 3709: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE

3705: ,DECODE(lines1.corrected_inv_id, NULL, NULL, 200) ADJUSTED_DOC_APPLICATION_ID
3706: ,DECODE(lines1.corrected_inv_id, NULL, NULL,
3707: 'AP_INVOICES') ADJUSTED_DOC_ENTITY_CODE
3708: ,DECODE(lines1.corrected_inv_id, NULL, NULL,
3709: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE
3710: ,lines1.corrected_inv_id ADJUSTED_DOC_TRX_ID
3711: ,lines1.Corrected_Line_Number ADJUSTED_DOC_LINE_ID
3712: ,DECODE(lines1.rcv_transaction_id, NULL, NULL, 707) APPLIED_TO_APPLICATION_ID
3713: ,DECODE(lines1.rcv_transaction_id, NULL, NULL,

Line 3764: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','PRORATED_TB','STANDARD_TB') TAXABLE_BASIS_FORMULA

3760: ,inv.exchange_date TAX_CURRENCY_CONVERSION_DATE
3761: ,inv.exchange_rate TAX_CURRENCY_CONVERSION_RATE
3762: ,inv.exchange_rate_type TAX_CURRENCY_CONVERSION_TYPE
3763: --Bug 9037817
3764: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','PRORATED_TB','STANDARD_TB') TAXABLE_BASIS_FORMULA
3765: ,taxes.tax_id
3766: ,rates.percentage_rate TAX_RATE
3767: ,rates.tax_rate_code
3768: ,rates.tax_rate_id

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

3787: ,ap_dists.base_amount REC_NREC_TAX_AMT_TAX_CURR
3788: ,DECODE(ap_dists.line_type_lookup_code,
3789: 'REC_TAX', 'AD_HOC_RECOVERY', NULL) RECOVERY_RATE_CODE
3790: ,DECODE(ap_dists.line_type_lookup_code,
3791: 'REC_TAX', 'STANDARD', NULL) RECOVERY_TYPE_CODE
3792: ,NVL(ap_dists.amount,0) TAX_AMT
3793: ,ap_dists.base_amount TAX_AMT_FUNCL_CURR
3794: ,ap_dists.base_amount TAX_AMT_TAX_CURR
3795: ,ap_dists1.po_distribution_id REF_DOC_DIST_ID

Line 3938: 'STANDARD', 'STANDARD INVOICES',

3934: AND NOT EXISTS
3935: (SELECT 1 FROM zx_lines zxl
3936: WHERE zxl.application_id = 200
3937: AND zxl.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3938: 'STANDARD', 'STANDARD INVOICES',
3939: 'CREDIT' , 'STANDARD INVOICES',
3940: 'DEBIT' , 'STANDARD INVOICES',
3941: 'MIXED' , 'STANDARD INVOICES',
3942: 'ADJUSTMENT','STANDARD INVOICES',

Line 3939: 'CREDIT' , 'STANDARD INVOICES',

3935: (SELECT 1 FROM zx_lines zxl
3936: WHERE zxl.application_id = 200
3937: AND zxl.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3938: 'STANDARD', 'STANDARD INVOICES',
3939: 'CREDIT' , 'STANDARD INVOICES',
3940: 'DEBIT' , 'STANDARD INVOICES',
3941: 'MIXED' , 'STANDARD INVOICES',
3942: 'ADJUSTMENT','STANDARD INVOICES',
3943: 'PO PRICE ADJUST','STANDARD INVOICES',

Line 3940: 'DEBIT' , 'STANDARD INVOICES',

3936: WHERE zxl.application_id = 200
3937: AND zxl.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3938: 'STANDARD', 'STANDARD INVOICES',
3939: 'CREDIT' , 'STANDARD INVOICES',
3940: 'DEBIT' , 'STANDARD INVOICES',
3941: 'MIXED' , 'STANDARD INVOICES',
3942: 'ADJUSTMENT','STANDARD INVOICES',
3943: 'PO PRICE ADJUST','STANDARD INVOICES',
3944: 'INVOICE REQUEST','STANDARD INVOICES',

Line 3941: 'MIXED' , 'STANDARD INVOICES',

3937: AND zxl.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3938: 'STANDARD', 'STANDARD INVOICES',
3939: 'CREDIT' , 'STANDARD INVOICES',
3940: 'DEBIT' , 'STANDARD INVOICES',
3941: 'MIXED' , 'STANDARD INVOICES',
3942: 'ADJUSTMENT','STANDARD INVOICES',
3943: 'PO PRICE ADJUST','STANDARD INVOICES',
3944: 'INVOICE REQUEST','STANDARD INVOICES',
3945: 'CREDIT MEMO REQUEST','STANDARD INVOICES',

Line 3942: 'ADJUSTMENT','STANDARD INVOICES',

3938: 'STANDARD', 'STANDARD INVOICES',
3939: 'CREDIT' , 'STANDARD INVOICES',
3940: 'DEBIT' , 'STANDARD INVOICES',
3941: 'MIXED' , 'STANDARD INVOICES',
3942: 'ADJUSTMENT','STANDARD INVOICES',
3943: 'PO PRICE ADJUST','STANDARD INVOICES',
3944: 'INVOICE REQUEST','STANDARD INVOICES',
3945: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
3946: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',

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

3939: 'CREDIT' , 'STANDARD INVOICES',
3940: 'DEBIT' , 'STANDARD INVOICES',
3941: 'MIXED' , 'STANDARD INVOICES',
3942: 'ADJUSTMENT','STANDARD INVOICES',
3943: 'PO PRICE ADJUST','STANDARD INVOICES',
3944: 'INVOICE REQUEST','STANDARD INVOICES',
3945: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
3946: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
3947: 'PREPAYMENT', 'PREPAYMENT INVOICES',

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

3940: 'DEBIT' , 'STANDARD INVOICES',
3941: 'MIXED' , 'STANDARD INVOICES',
3942: 'ADJUSTMENT','STANDARD INVOICES',
3943: 'PO PRICE ADJUST','STANDARD INVOICES',
3944: 'INVOICE REQUEST','STANDARD INVOICES',
3945: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
3946: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
3947: 'PREPAYMENT', 'PREPAYMENT INVOICES',
3948: 'EXPENSE REPORT', 'EXPENSE REPORTS',

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

3941: 'MIXED' , 'STANDARD INVOICES',
3942: 'ADJUSTMENT','STANDARD INVOICES',
3943: 'PO PRICE ADJUST','STANDARD INVOICES',
3944: 'INVOICE REQUEST','STANDARD INVOICES',
3945: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
3946: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
3947: 'PREPAYMENT', 'PREPAYMENT INVOICES',
3948: 'EXPENSE REPORT', 'EXPENSE REPORTS',
3949: 'INTEREST INVOICE', 'INTEREST INVOICES','NA')

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

3942: 'ADJUSTMENT','STANDARD INVOICES',
3943: 'PO PRICE ADJUST','STANDARD INVOICES',
3944: 'INVOICE REQUEST','STANDARD INVOICES',
3945: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
3946: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
3947: 'PREPAYMENT', 'PREPAYMENT INVOICES',
3948: 'EXPENSE REPORT', 'EXPENSE REPORTS',
3949: 'INTEREST INVOICE', 'INTEREST INVOICES','NA')
3950: AND zxl.trx_id = inv.invoice_id

Line 4985: 'STANDARD_TC' TAX_CALCULATION_FORMULA,

4981: -- NULL TAX_APPLICABILITY_RESULT_ID,
4982: 'Y' TAX_APPORTIONMENT_FLAG,
4983: 1 TAX_APPORTIONMENT_LINE_NUMBER,
4984: -- NULL TAX_BASE_MODIFIER_RATE,
4985: 'STANDARD_TC' TAX_CALCULATION_FORMULA,
4986: -- NULL TAX_CODE,
4987: taxes.tax_currency_code TAX_CURRENCY_CODE,
4988: poh.rate_date TAX_CURRENCY_CONVERSION_DATE,
4989: poh.rate TAX_CURRENCY_CONVERSION_RATE,

Line 5034: 'STANDARD_TB' TAXABLE_BASIS_FORMULA ,

5030: -- NULL TAX_TYPE_CODE,
5031: -- NULL TAXABLE_AMT,
5032: -- NULL TAXABLE_AMT_FUNCL_CURR,
5033: -- NULL TAXABLE_AMT_TAX_CURR,
5034: 'STANDARD_TB' TAXABLE_BASIS_FORMULA ,
5035: -- NULL TAXING_JURIS_GEOGRAPHY_ID ,
5036: -- NULL THRESH_RESULT_ID,
5037: NVL(poh.currency_code,
5038: poh.base_currency_code) TRX_CURRENCY_CODE,

Line 5691: 'STANDARD_TC' TAX_CALCULATION_FORMULA,

5687: rates.tax_regime_code,
5688: rates.tax
5689: ORDER BY atg.tax_code_id) TAX_APPORTIONMENT_LINE_NUMBER,
5690: -- NULL TAX_BASE_MODIFIER_RATE,
5691: 'STANDARD_TC' TAX_CALCULATION_FORMULA,
5692: -- NULL TAX_CODE,
5693: taxes.tax_currency_code TAX_CURRENCY_CODE,
5694: poh.rate_date TAX_CURRENCY_CONVERSION_DATE,
5695: poh.rate TAX_CURRENCY_CONVERSION_RATE,

Line 5741: 'STANDARD_TB' TAXABLE_BASIS_FORMULA ,

5737: -- NULL TAX_TYPE_CODE,
5738: -- NULL TAXABLE_AMT,
5739: -- NULL TAXABLE_AMT_FUNCL_CURR,
5740: -- NULL TAXABLE_AMT_TAX_CURR,
5741: 'STANDARD_TB' TAXABLE_BASIS_FORMULA ,
5742: -- NULL TAXING_JURIS_GEOGRAPHY_ID ,
5743: -- NULL THRESH_RESULT_ID,
5744: NVL(poh.currency_code,
5745: poh.base_currency_code) TRX_CURRENCY_CODE,

Line 6141: 'STANDARD')) RECOVERY_TYPE_CODE,

6137: ) RECOVERY_RATE_ID,
6138: -- End : Code changes for Bug#13955562 --
6139: DECODE(tmp.rec_flag,'N', NULL,
6140: NVL(rates.recovery_type_code,
6141: 'STANDARD')) RECOVERY_TYPE_CODE,
6142: -- NULL RECOVERY_TYPE_ID,
6143: -- NULL REF_DOC_CURR_CONV_RATE,
6144: -- NULL REF_DOC_DIST_ID,
6145: -- NULL REF_DOC_PER_UNIT_NREC_TAX_AMT,

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

6305: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
6306: AND rates.tax(+) = pohzd.tax
6307: AND rates.content_owner_id(+) = pohzd.content_owner_id
6308: AND rates.rate_type_code(+) = 'RECOVERY'
6309: AND rates.recovery_type_code(+) = 'STANDARD'
6310: AND rates.active_flag(+) = 'Y'
6311: AND rates.effective_from(+) <= sysdate
6312: --Bug#13955562: Added outer join (+) to rates.effective_from and rates.effective_to
6313: AND pohzd.poh_last_update_date BETWEEN rates.effective_from(+)