APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on STANDARD

Line 607: -- Bug 9037817 'STANDARD_TB'

603: ,CURRENCY_CONVERSION_DATE
604: ,CURRENCY_CONVERSION_TYPE
605: ,CURRENCY_CONVERSION_RATE
606: -- ,NULL -- SUMMARIZATION_TEMPLATE_ID
607: -- Bug 9037817 'STANDARD_TB'
608: ,TAXABLE_BASIS_FORMULA
609: ,'STANDARD_TC' -- TAX_CALCULATION_FORMULA
610: ,HISTORICAL_FLAG
611: ,CANCEL_FLAG

Line 609: ,'STANDARD_TC' -- TAX_CALCULATION_FORMULA

605: ,CURRENCY_CONVERSION_RATE
606: -- ,NULL -- SUMMARIZATION_TEMPLATE_ID
607: -- Bug 9037817 'STANDARD_TB'
608: ,TAXABLE_BASIS_FORMULA
609: ,'STANDARD_TC' -- TAX_CALCULATION_FORMULA
610: ,HISTORICAL_FLAG
611: ,CANCEL_FLAG
612: ,'N' -- DELETE_FLAG
613: ,TAX_AMT_INCLUDED_FLAG

Line 701: 'STANDARD', 'STANDARD INVOICES',

697: ,NVL(lines.org_id,-99) INTERNAL_ORGANIZATION_ID
698: ,200 APPLICATION_ID
699: ,'AP_INVOICES' ENTITY_CODE
700: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
701: 'STANDARD', 'STANDARD INVOICES',
702: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
703: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
704: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
705: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409

Line 702: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409

698: ,200 APPLICATION_ID
699: ,'AP_INVOICES' ENTITY_CODE
700: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
701: 'STANDARD', 'STANDARD INVOICES',
702: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
703: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
704: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
705: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
706: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409

Line 703: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409

699: ,'AP_INVOICES' ENTITY_CODE
700: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
701: 'STANDARD', 'STANDARD INVOICES',
702: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
703: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
704: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
705: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
706: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
707: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409

Line 704: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409

700: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
701: 'STANDARD', 'STANDARD INVOICES',
702: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
703: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
704: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
705: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
706: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
707: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
708: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409

Line 705: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409

701: 'STANDARD', 'STANDARD INVOICES',
702: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
703: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
704: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
705: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
706: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
707: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
708: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
709: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409

Line 706: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409

702: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
703: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
704: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
705: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
706: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
707: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
708: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
709: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
710: 'PREPAYMENT', 'PREPAYMENT INVOICES',

Line 707: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409

703: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
704: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
705: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
706: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
707: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
708: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
709: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
710: 'PREPAYMENT', 'PREPAYMENT INVOICES',
711: 'EXPENSE REPORT', 'EXPENSE REPORTS',

Line 708: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409

704: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
705: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
706: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
707: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
708: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
709: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
710: 'PREPAYMENT', 'PREPAYMENT INVOICES',
711: 'EXPENSE REPORT', 'EXPENSE REPORTS',
712: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE

Line 709: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409

705: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
706: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
707: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
708: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
709: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
710: 'PREPAYMENT', 'PREPAYMENT INVOICES',
711: 'EXPENSE REPORT', 'EXPENSE REPORTS',
712: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
713: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE, 'STANDARD', 1,

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

709: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
710: 'PREPAYMENT', 'PREPAYMENT INVOICES',
711: 'EXPENSE REPORT', 'EXPENSE REPORTS',
712: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
713: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE, 'STANDARD', 1,
714: 'PREPAYMENT', 7, 'EXPENSE REPORT', 2, NULL) EVENT_CLASS_MAPPING_ID
715: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
716: 'STANDARD','STANDARD INVOICE CREATED',
717: 'PREPAYMENT','PREPAYMENT INVOICE CREATED',

Line 716: 'STANDARD','STANDARD INVOICE CREATED',

712: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
713: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE, 'STANDARD', 1,
714: 'PREPAYMENT', 7, 'EXPENSE REPORT', 2, NULL) EVENT_CLASS_MAPPING_ID
715: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
716: 'STANDARD','STANDARD INVOICE CREATED',
717: 'PREPAYMENT','PREPAYMENT INVOICE CREATED',
718: 'EXPENSE REPORT','EXPENSE REPORT CREATED',
719: 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
720: ,(CASE

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

720: ,(CASE
721: WHEN inv.invoice_type_lookup_code in
722: ('ADJUSTMENT','CREDIT','DEBIT','INTEREST',
723: 'MIXED','QUICKDEFAULT','PO PRICE ADJUST',
724: 'QUICKMATCH','STANDARD','AWT')
725: THEN 'PURCHASE_TRANSACTION'
726: WHEN inv.invoice_type_lookup_code = 'PREPAYMENT'
727: THEN 'PURCHASE_PREPAYMENTTRANSACTION'
728: WHEN inv.invoice_type_lookup_code='EXPENSE REPORT'

Line 739: 'STANDARD', 'STANDARD INVOICES',

735: ,DECODE(lines.po_line_location_id,
736: NULL, DECODE(lines.line_type_lookup_code,
737: 'PREPAY', 'PREPAY_APPLICATION',
738: DECODE(inv.invoice_type_lookup_code,
739: 'STANDARD', 'STANDARD INVOICES',
740: 'CREDIT','AP_CREDIT_MEMO',
741: 'CREDIT MEMO REQUEST', 'AP_CREDIT_MEMO',
742: 'DEBIT','AP_DEBIT_MEMO',
743: 'PREPAYMENT','PREPAYMENT INVOICES',

Line 745: 'STANDARD INVOICES'

741: 'CREDIT MEMO REQUEST', 'AP_CREDIT_MEMO',
742: 'DEBIT','AP_DEBIT_MEMO',
743: 'PREPAYMENT','PREPAYMENT INVOICES',
744: 'EXPENSE REPORT','EXPENSE REPORTS',
745: 'STANDARD INVOICES'
746: )
747: ),
748: DECODE(poll.shipment_type,
749: 'PREPAYMENT', DECODE(poll.payment_type,

Line 756: 'STANDARD INVOICES')

752: 'RATE', 'FINANCING',
753: 'LUMPSUM', 'FINANCING',
754: DECODE(poll.matching_basis,
755: 'AMOUNT','AMOUNT_MATCHED',
756: 'STANDARD INVOICES')
757: ),
758: DECODE(poll.matching_basis,
759: 'AMOUNT','AMOUNT_MATCHED',
760: 'STANDARD INVOICES')

Line 760: 'STANDARD INVOICES')

756: 'STANDARD INVOICES')
757: ),
758: DECODE(poll.matching_basis,
759: 'AMOUNT','AMOUNT_MATCHED',
760: 'STANDARD INVOICES')
761: )
762: ) LINE_CLASS
763: -- ,NULL APPLICATION_DOC_STATUS
764: ,lines.line_type_lookup_code AP_LINE_LOOKUP_CODE

Line 819: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE

815: ,DECODE(lines.corrected_inv_id, NULL, NULL, 200) ADJUSTED_DOC_APPLICATION_ID
816: ,DECODE(lines.corrected_inv_id, NULL, NULL,
817: 'AP_INVOICES') ADJUSTED_DOC_ENTITY_CODE
818: ,DECODE(lines.corrected_inv_id, NULL, NULL,
819: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE
820: ,lines.corrected_inv_id ADJUSTED_DOC_TRX_ID
821: ,lines.corrected_line_number ADJUSTED_DOC_LINE_ID
822: -- ,NULL ADJUSTED_DOC_NUMBER
823: -- ,NULL ADJUSTED_DOC_DATE

Line 1011: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','PRORATED_TB','STANDARD_TB') TAXABLE_BASIS_FORMULA --Bug 9037817

1007: -- ,NULL TRX_LINE_CURRENCY_CONV_TYPE
1008: -- ,NULL INTERFACE_ENTITY_CODE
1009: -- ,NULL INTERFACE_LINE_ID
1010: -- ,NULL SOURCE_TAX_LINE_ID
1011: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','PRORATED_TB','STANDARD_TB') TAXABLE_BASIS_FORMULA --Bug 9037817
1012: ,DECODE(lines.discarded_flag, 'Y', 'Y', 'N') CANCEL_FLAG
1013: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
1014: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
1015: FROM ap_invoices_all inv,

Line 1033: 'STANDARD', 'STANDARD INVOICES',

1029: AND NOT EXISTS (SELECT 1 FROM zx_lines_det_factors zxdet --Bug 6738188
1030: WHERE zxdet.application_id = 200
1031: AND zxdet.entity_code = 'AP_INVOICES'
1032: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
1033: 'STANDARD', 'STANDARD INVOICES',
1034: 'CREDIT' , 'STANDARD INVOICES',
1035: 'DEBIT' , 'STANDARD INVOICES',
1036: 'MIXED' , 'STANDARD INVOICES',
1037: 'ADJUSTMENT','STANDARD INVOICES',

Line 1034: 'CREDIT' , 'STANDARD INVOICES',

1030: WHERE zxdet.application_id = 200
1031: AND zxdet.entity_code = 'AP_INVOICES'
1032: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
1033: 'STANDARD', 'STANDARD INVOICES',
1034: 'CREDIT' , 'STANDARD INVOICES',
1035: 'DEBIT' , 'STANDARD INVOICES',
1036: 'MIXED' , 'STANDARD INVOICES',
1037: 'ADJUSTMENT','STANDARD INVOICES',
1038: 'PO PRICE ADJUST','STANDARD INVOICES',

Line 1035: 'DEBIT' , 'STANDARD INVOICES',

1031: AND zxdet.entity_code = 'AP_INVOICES'
1032: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
1033: 'STANDARD', 'STANDARD INVOICES',
1034: 'CREDIT' , 'STANDARD INVOICES',
1035: 'DEBIT' , 'STANDARD INVOICES',
1036: 'MIXED' , 'STANDARD INVOICES',
1037: 'ADJUSTMENT','STANDARD INVOICES',
1038: 'PO PRICE ADJUST','STANDARD INVOICES',
1039: 'INVOICE REQUEST','STANDARD INVOICES',

Line 1036: 'MIXED' , 'STANDARD INVOICES',

1032: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
1033: 'STANDARD', 'STANDARD INVOICES',
1034: 'CREDIT' , 'STANDARD INVOICES',
1035: 'DEBIT' , 'STANDARD INVOICES',
1036: 'MIXED' , 'STANDARD INVOICES',
1037: 'ADJUSTMENT','STANDARD INVOICES',
1038: 'PO PRICE ADJUST','STANDARD INVOICES',
1039: 'INVOICE REQUEST','STANDARD INVOICES',
1040: 'CREDIT MEMO REQUEST','STANDARD INVOICES',

Line 1037: 'ADJUSTMENT','STANDARD INVOICES',

1033: 'STANDARD', 'STANDARD INVOICES',
1034: 'CREDIT' , 'STANDARD INVOICES',
1035: 'DEBIT' , 'STANDARD INVOICES',
1036: 'MIXED' , 'STANDARD INVOICES',
1037: 'ADJUSTMENT','STANDARD INVOICES',
1038: 'PO PRICE ADJUST','STANDARD INVOICES',
1039: 'INVOICE REQUEST','STANDARD INVOICES',
1040: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
1041: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',

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

1034: 'CREDIT' , 'STANDARD INVOICES',
1035: 'DEBIT' , 'STANDARD INVOICES',
1036: 'MIXED' , 'STANDARD INVOICES',
1037: 'ADJUSTMENT','STANDARD INVOICES',
1038: 'PO PRICE ADJUST','STANDARD INVOICES',
1039: 'INVOICE REQUEST','STANDARD INVOICES',
1040: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
1041: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
1042: 'PREPAYMENT', 'PREPAYMENT INVOICES',

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

1035: 'DEBIT' , 'STANDARD INVOICES',
1036: 'MIXED' , 'STANDARD INVOICES',
1037: 'ADJUSTMENT','STANDARD INVOICES',
1038: 'PO PRICE ADJUST','STANDARD INVOICES',
1039: 'INVOICE REQUEST','STANDARD INVOICES',
1040: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
1041: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
1042: 'PREPAYMENT', 'PREPAYMENT INVOICES',
1043: 'EXPENSE REPORT', 'EXPENSE REPORTS',

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

1036: 'MIXED' , 'STANDARD INVOICES',
1037: 'ADJUSTMENT','STANDARD INVOICES',
1038: 'PO PRICE ADJUST','STANDARD INVOICES',
1039: 'INVOICE REQUEST','STANDARD INVOICES',
1040: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
1041: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
1042: 'PREPAYMENT', 'PREPAYMENT INVOICES',
1043: 'EXPENSE REPORT', 'EXPENSE REPORTS',
1044: 'INTEREST INVOICE', 'INTEREST INVOICES','NA')

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

1037: 'ADJUSTMENT','STANDARD INVOICES',
1038: 'PO PRICE ADJUST','STANDARD INVOICES',
1039: 'INVOICE REQUEST','STANDARD INVOICES',
1040: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
1041: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
1042: 'PREPAYMENT', 'PREPAYMENT INVOICES',
1043: 'EXPENSE REPORT', 'EXPENSE REPORTS',
1044: 'INTEREST INVOICE', 'INTEREST INVOICES','NA')
1045: AND zxdet.trx_id=inv.invoice_id

Line 1710: ,'STANDARD_TC'

1706: -- ,NULL -- REPORTING_CURRENCY_CODE
1707: ,TAX_AMT
1708: ,TAX_AMT_FUNCL_CURR
1709: ,TAX_AMT_TAX_CURR
1710: ,'STANDARD_TC'
1711: -- ,NULL -- TAX_CODE
1712: ,TAX_DATE
1713: ,TAX_DETERMINE_DATE
1714: ,TAX_POINT_DATE

Line 1720: -- Bug 9037817 'STANDARD_TB'

1716: -- ,ROUNDING_RULE_CODE
1717: ,TAXABLE_AMT
1718: ,TAXABLE_AMT_FUNCL_CURR
1719: ,TAXABLE_AMT_TAX_CURR
1720: -- Bug 9037817 'STANDARD_TB'
1721: ,TAXABLE_BASIS_FORMULA
1722: ,TRX_DATE
1723: ,TRX_LINE_DATE
1724: ,TRX_LINE_QUANTITY

Line 1806: 'STANDARD', 'STANDARD INVOICES' ,

1802: NVL(lines1.org_id,-99) INTERNAL_ORGANIZATION_ID
1803: ,200 APPLICATION_ID
1804: ,'AP_INVOICES' ENTITY_CODE
1805: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,
1806: 'STANDARD', 'STANDARD INVOICES' ,
1807: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
1808: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
1809: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
1810: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409

Line 1807: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409

1803: ,200 APPLICATION_ID
1804: ,'AP_INVOICES' ENTITY_CODE
1805: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,
1806: 'STANDARD', 'STANDARD INVOICES' ,
1807: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
1808: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
1809: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
1810: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
1811: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409

Line 1808: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409

1804: ,'AP_INVOICES' ENTITY_CODE
1805: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,
1806: 'STANDARD', 'STANDARD INVOICES' ,
1807: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
1808: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
1809: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
1810: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
1811: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
1812: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409

Line 1809: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409

1805: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,
1806: 'STANDARD', 'STANDARD INVOICES' ,
1807: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
1808: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
1809: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
1810: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
1811: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
1812: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
1813: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409

Line 1810: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409

1806: 'STANDARD', 'STANDARD INVOICES' ,
1807: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
1808: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
1809: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
1810: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
1811: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
1812: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
1813: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
1814: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409

Line 1811: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409

1807: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
1808: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
1809: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
1810: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
1811: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
1812: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
1813: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
1814: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
1815: 'PREPAYMENT','PREPAYMENT INVOICES' ,

Line 1812: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409

1808: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
1809: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
1810: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
1811: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
1812: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
1813: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
1814: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
1815: 'PREPAYMENT','PREPAYMENT INVOICES' ,
1816: 'EXPENSE REPORT','EXPENSE REPORTS' ,

Line 1813: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409

1809: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
1810: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
1811: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
1812: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
1813: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
1814: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
1815: 'PREPAYMENT','PREPAYMENT INVOICES' ,
1816: 'EXPENSE REPORT','EXPENSE REPORTS' ,
1817: 'INTEREST INVOICE','INTEREST INVOICES','NA') EVENT_CLASS_CODE

Line 1814: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409

1810: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
1811: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
1812: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
1813: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
1814: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
1815: 'PREPAYMENT','PREPAYMENT INVOICES' ,
1816: 'EXPENSE REPORT','EXPENSE REPORTS' ,
1817: 'INTEREST INVOICE','INTEREST INVOICES','NA') EVENT_CLASS_CODE
1818: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,

Line 1819: 'STANDARD','STANDARD INVOICE CREATED',

1815: 'PREPAYMENT','PREPAYMENT INVOICES' ,
1816: 'EXPENSE REPORT','EXPENSE REPORTS' ,
1817: 'INTEREST INVOICE','INTEREST INVOICES','NA') EVENT_CLASS_CODE
1818: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
1819: 'STANDARD','STANDARD INVOICE CREATED',
1820: 'PREPAYMENT','PREPAYMENT INVOICE CREATED',
1821: 'EXPENSE REPORT','EXPENSE REPORT CREATED',
1822: 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
1823: ,(CASE WHEN inv.invoice_type_lookup_code in

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

1822: 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
1823: ,(CASE WHEN inv.invoice_type_lookup_code in
1824: ('ADJUSTMENT','CREDIT','DEBIT','INTEREST',
1825: 'MIXED','QUICKDEFAULT','PO PRICE ADJUST',
1826: 'QUICKMATCH','STANDARD','AWT')
1827: THEN 'PURCHASE_TRANSACTION'
1828: WHEN (inv.invoice_type_lookup_code =
1829: 'PREPAYMENT')
1830: THEN 'PURCHASE_PREPAYMENTTRANSACTION'

Line 1871: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE

1867: ,DECODE(lines1.corrected_inv_id, NULL, NULL, 200) ADJUSTED_DOC_APPLICATION_ID
1868: ,DECODE(lines1.corrected_inv_id, NULL, NULL,
1869: 'AP_INVOICES') ADJUSTED_DOC_ENTITY_CODE
1870: ,DECODE(lines1.corrected_inv_id, NULL, NULL,
1871: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE
1872: ,lines1.corrected_inv_id ADJUSTED_DOC_TRX_ID
1873: ,lines1.Corrected_Line_Number ADJUSTED_DOC_LINE_ID
1874: -- ,NULL ADJUSTED_DOC_NUMBER
1875: -- ,NULL ADJUSTED_DOC_DATE

Line 1918: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','PRORATED_TB','STANDARD_TB') TAXABLE_BASIS_FORMULA -- Bug 9037817

1914: ,ptp.party_tax_profile_id CONTENT_OWNER_ID
1915: ,inv.exchange_date CURRENCY_CONVERSION_DATE
1916: ,inv.exchange_rate CURRENCY_CONVERSION_RATE
1917: ,inv.exchange_rate_type CURRENCY_CONVERSION_TYPE
1918: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','PRORATED_TB','STANDARD_TB') TAXABLE_BASIS_FORMULA -- Bug 9037817
1919: ,ap_dists.set_of_books_id AP_LEDGER_ID
1920: ,fnd_curr.minimum_accountable_unit MINIMUM_ACCOUNTABLE_UNIT
1921: ,NVL(fnd_curr.precision, 0) PRECISION
1922: ,DECODE(NVL(lines1.po_release_id, lines1.po_header_id),

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

1983: ,ap_dists.base_amount REC_NREC_TAX_AMT_TAX_CURR
1984: ,DECODE(ap_dists.line_type_lookup_code,
1985: 'REC_TAX', 'AD_HOC_RECOVERY', NULL) RECOVERY_RATE_CODE
1986: ,DECODE(ap_dists.line_type_lookup_code,
1987: 'REC_TAX', 'STANDARD', NULL) RECOVERY_TYPE_CODE
1988: ,NVL(ap_dists.amount,0) TAX_AMT
1989: ,ap_dists.base_amount TAX_AMT_FUNCL_CURR
1990: ,ap_dists.base_amount TAX_AMT_TAX_CURR
1991: -- ,NULL RECOVERY_TYPE_ID

Line 2166: 'STANDARD', 'STANDARD INVOICES',

2162: AND NOT EXISTS -- Bug 6738188
2163: (SELECT 1 FROM zx_lines zxl
2164: WHERE zxl.application_id = 200
2165: AND zxl.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2166: 'STANDARD', 'STANDARD INVOICES',
2167: 'CREDIT' , 'STANDARD INVOICES',
2168: 'DEBIT' , 'STANDARD INVOICES',
2169: 'MIXED' , 'STANDARD INVOICES',
2170: 'ADJUSTMENT','STANDARD INVOICES',

Line 2167: 'CREDIT' , 'STANDARD INVOICES',

2163: (SELECT 1 FROM zx_lines zxl
2164: WHERE zxl.application_id = 200
2165: AND zxl.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2166: 'STANDARD', 'STANDARD INVOICES',
2167: 'CREDIT' , 'STANDARD INVOICES',
2168: 'DEBIT' , 'STANDARD INVOICES',
2169: 'MIXED' , 'STANDARD INVOICES',
2170: 'ADJUSTMENT','STANDARD INVOICES',
2171: 'PO PRICE ADJUST','STANDARD INVOICES',

Line 2168: 'DEBIT' , 'STANDARD INVOICES',

2164: WHERE zxl.application_id = 200
2165: AND zxl.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2166: 'STANDARD', 'STANDARD INVOICES',
2167: 'CREDIT' , 'STANDARD INVOICES',
2168: 'DEBIT' , 'STANDARD INVOICES',
2169: 'MIXED' , 'STANDARD INVOICES',
2170: 'ADJUSTMENT','STANDARD INVOICES',
2171: 'PO PRICE ADJUST','STANDARD INVOICES',
2172: 'INVOICE REQUEST','STANDARD INVOICES',

Line 2169: 'MIXED' , 'STANDARD INVOICES',

2165: AND zxl.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2166: 'STANDARD', 'STANDARD INVOICES',
2167: 'CREDIT' , 'STANDARD INVOICES',
2168: 'DEBIT' , 'STANDARD INVOICES',
2169: 'MIXED' , 'STANDARD INVOICES',
2170: 'ADJUSTMENT','STANDARD INVOICES',
2171: 'PO PRICE ADJUST','STANDARD INVOICES',
2172: 'INVOICE REQUEST','STANDARD INVOICES',
2173: 'CREDIT MEMO REQUEST','STANDARD INVOICES',

Line 2170: 'ADJUSTMENT','STANDARD INVOICES',

2166: 'STANDARD', 'STANDARD INVOICES',
2167: 'CREDIT' , 'STANDARD INVOICES',
2168: 'DEBIT' , 'STANDARD INVOICES',
2169: 'MIXED' , 'STANDARD INVOICES',
2170: 'ADJUSTMENT','STANDARD INVOICES',
2171: 'PO PRICE ADJUST','STANDARD INVOICES',
2172: 'INVOICE REQUEST','STANDARD INVOICES',
2173: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
2174: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',

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

2167: 'CREDIT' , 'STANDARD INVOICES',
2168: 'DEBIT' , 'STANDARD INVOICES',
2169: 'MIXED' , 'STANDARD INVOICES',
2170: 'ADJUSTMENT','STANDARD INVOICES',
2171: 'PO PRICE ADJUST','STANDARD INVOICES',
2172: 'INVOICE REQUEST','STANDARD INVOICES',
2173: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
2174: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
2175: 'PREPAYMENT', 'PREPAYMENT INVOICES',

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

2168: 'DEBIT' , 'STANDARD INVOICES',
2169: 'MIXED' , 'STANDARD INVOICES',
2170: 'ADJUSTMENT','STANDARD INVOICES',
2171: 'PO PRICE ADJUST','STANDARD INVOICES',
2172: 'INVOICE REQUEST','STANDARD INVOICES',
2173: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
2174: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
2175: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2176: 'EXPENSE REPORT', 'EXPENSE REPORTS',

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

2169: 'MIXED' , 'STANDARD INVOICES',
2170: 'ADJUSTMENT','STANDARD INVOICES',
2171: 'PO PRICE ADJUST','STANDARD INVOICES',
2172: 'INVOICE REQUEST','STANDARD INVOICES',
2173: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
2174: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
2175: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2176: 'EXPENSE REPORT', 'EXPENSE REPORTS',
2177: 'INTEREST INVOICE', 'INTEREST INVOICES','NA')

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

2170: 'ADJUSTMENT','STANDARD INVOICES',
2171: 'PO PRICE ADJUST','STANDARD INVOICES',
2172: 'INVOICE REQUEST','STANDARD INVOICES',
2173: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
2174: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
2175: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2176: 'EXPENSE REPORT', 'EXPENSE REPORTS',
2177: 'INTEREST INVOICE', 'INTEREST INVOICES','NA')
2178: AND zxl.trx_id = inv.invoice_id

Line 2773: -- Bug 9037817 'STANDARD_TB'

2769: ,CURRENCY_CONVERSION_DATE
2770: ,CURRENCY_CONVERSION_TYPE
2771: ,CURRENCY_CONVERSION_RATE
2772: -- ,NULL -- SUMMARIZATION_TEMPLATE_ID
2773: -- Bug 9037817 'STANDARD_TB'
2774: ,TAXABLE_BASIS_FORMULA
2775: ,'STANDARD_TC' -- TAX_CALCULATION_FORMULA
2776: ,HISTORICAL_FLAG
2777: ,CANCEL_FLAG

Line 2775: ,'STANDARD_TC' -- TAX_CALCULATION_FORMULA

2771: ,CURRENCY_CONVERSION_RATE
2772: -- ,NULL -- SUMMARIZATION_TEMPLATE_ID
2773: -- Bug 9037817 'STANDARD_TB'
2774: ,TAXABLE_BASIS_FORMULA
2775: ,'STANDARD_TC' -- TAX_CALCULATION_FORMULA
2776: ,HISTORICAL_FLAG
2777: ,CANCEL_FLAG
2778: ,'N' -- DELETE_FLAG
2779: ,TAX_AMT_INCLUDED_FLAG

Line 2867: 'STANDARD', 'STANDARD INVOICES',

2863: ,NVL(lines.org_id,-99) INTERNAL_ORGANIZATION_ID
2864: ,200 APPLICATION_ID
2865: ,'AP_INVOICES' ENTITY_CODE
2866: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2867: 'STANDARD', 'STANDARD INVOICES',
2868: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
2869: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
2870: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
2871: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409

Line 2868: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409

2864: ,200 APPLICATION_ID
2865: ,'AP_INVOICES' ENTITY_CODE
2866: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2867: 'STANDARD', 'STANDARD INVOICES',
2868: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
2869: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
2870: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
2871: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
2872: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409

Line 2869: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409

2865: ,'AP_INVOICES' ENTITY_CODE
2866: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2867: 'STANDARD', 'STANDARD INVOICES',
2868: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
2869: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
2870: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
2871: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
2872: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
2873: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409

Line 2870: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409

2866: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2867: 'STANDARD', 'STANDARD INVOICES',
2868: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
2869: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
2870: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
2871: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
2872: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
2873: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
2874: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409

Line 2871: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409

2867: 'STANDARD', 'STANDARD INVOICES',
2868: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
2869: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
2870: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
2871: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
2872: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
2873: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
2874: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
2875: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409

Line 2872: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409

2868: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
2869: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
2870: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
2871: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
2872: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
2873: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
2874: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
2875: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
2876: 'PREPAYMENT', 'PREPAYMENT INVOICES',

Line 2873: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409

2869: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
2870: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
2871: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
2872: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
2873: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
2874: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
2875: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
2876: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2877: 'EXPENSE REPORT', 'EXPENSE REPORTS',

Line 2874: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409

2870: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
2871: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
2872: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
2873: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
2874: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
2875: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
2876: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2877: 'EXPENSE REPORT', 'EXPENSE REPORTS',
2878: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE

Line 2875: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409

2871: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
2872: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
2873: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
2874: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
2875: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
2876: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2877: 'EXPENSE REPORT', 'EXPENSE REPORTS',
2878: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
2879: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE, 'STANDARD', 1,

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

2875: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
2876: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2877: 'EXPENSE REPORT', 'EXPENSE REPORTS',
2878: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
2879: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE, 'STANDARD', 1,
2880: 'PREPAYMENT', 7, 'EXPENSE REPORT', 2, NULL) EVENT_CLASS_MAPPING_ID
2881: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2882: 'STANDARD','STANDARD INVOICE CREATED',
2883: 'PREPAYMENT','PREPAYMENT INVOICE CREATED',

Line 2882: 'STANDARD','STANDARD INVOICE CREATED',

2878: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
2879: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE, 'STANDARD', 1,
2880: 'PREPAYMENT', 7, 'EXPENSE REPORT', 2, NULL) EVENT_CLASS_MAPPING_ID
2881: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2882: 'STANDARD','STANDARD INVOICE CREATED',
2883: 'PREPAYMENT','PREPAYMENT INVOICE CREATED',
2884: 'EXPENSE REPORT','EXPENSE REPORT CREATED',
2885: 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
2886: ,(CASE

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

2886: ,(CASE
2887: WHEN inv.invoice_type_lookup_code in
2888: ('ADJUSTMENT','CREDIT','DEBIT','INTEREST',
2889: 'MIXED','QUICKDEFAULT','PO PRICE ADJUST',
2890: 'QUICKMATCH','STANDARD','AWT')
2891: THEN 'PURCHASE_TRANSACTION'
2892: WHEN inv.invoice_type_lookup_code = 'PREPAYMENT'
2893: THEN 'PURCHASE_PREPAYMENTTRANSACTION'
2894: WHEN inv.invoice_type_lookup_code='EXPENSE REPORT'

Line 2905: 'STANDARD', 'STANDARD INVOICES',

2901: ,DECODE(lines.po_line_location_id,
2902: NULL, DECODE(lines.line_type_lookup_code,
2903: 'PREPAY', 'PREPAY_APPLICATION',
2904: DECODE(inv.invoice_type_lookup_code,
2905: 'STANDARD', 'STANDARD INVOICES',
2906: 'CREDIT','AP_CREDIT_MEMO',
2907: 'CREDIT MEMO REQUEST', 'AP_CREDIT_MEMO',
2908: 'DEBIT','AP_DEBIT_MEMO',
2909: 'PREPAYMENT','PREPAYMENT INVOICES',

Line 2911: 'STANDARD INVOICES'

2907: 'CREDIT MEMO REQUEST', 'AP_CREDIT_MEMO',
2908: 'DEBIT','AP_DEBIT_MEMO',
2909: 'PREPAYMENT','PREPAYMENT INVOICES',
2910: 'EXPENSE REPORT','EXPENSE REPORTS',
2911: 'STANDARD INVOICES'
2912: )
2913: ),
2914: DECODE(poll.shipment_type,
2915: 'PREPAYMENT', DECODE(poll.payment_type,

Line 2922: 'STANDARD INVOICES')

2918: 'RATE', 'FINANCING',
2919: 'LUMPSUM', 'FINANCING',
2920: DECODE(poll.matching_basis,
2921: 'AMOUNT','AMOUNT_MATCHED',
2922: 'STANDARD INVOICES')
2923: ),
2924: DECODE(poll.matching_basis,
2925: 'AMOUNT','AMOUNT_MATCHED',
2926: 'STANDARD INVOICES')

Line 2926: 'STANDARD INVOICES')

2922: 'STANDARD INVOICES')
2923: ),
2924: DECODE(poll.matching_basis,
2925: 'AMOUNT','AMOUNT_MATCHED',
2926: 'STANDARD INVOICES')
2927: )
2928: ) LINE_CLASS
2929: -- ,NULL APPLICATION_DOC_STATUS
2930: ,lines.line_type_lookup_code AP_LINE_LOOKUP_CODE

Line 2985: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE

2981: ,DECODE(lines.corrected_inv_id, NULL, NULL, 200) ADJUSTED_DOC_APPLICATION_ID
2982: ,DECODE(lines.corrected_inv_id, NULL, NULL,
2983: 'AP_INVOICES') ADJUSTED_DOC_ENTITY_CODE
2984: ,DECODE(lines.corrected_inv_id, NULL, NULL,
2985: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE
2986: ,lines.corrected_inv_id ADJUSTED_DOC_TRX_ID
2987: ,lines.corrected_line_number ADJUSTED_DOC_LINE_ID
2988: -- ,NULL ADJUSTED_DOC_NUMBER
2989: -- ,NULL ADJUSTED_DOC_DATE

Line 3070: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','PRORATED_TB','STANDARD_TB') TAXABLE_BASIS_FORMULA --Bug 9037817

3066: ,ptp.party_tax_profile_id CONTENT_OWNER_ID
3067: ,inv.exchange_date CURRENCY_CONVERSION_DATE
3068: ,inv.exchange_rate CURRENCY_CONVERSION_RATE
3069: ,inv.exchange_rate_type CURRENCY_CONVERSION_TYPE
3070: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','PRORATED_TB','STANDARD_TB') TAXABLE_BASIS_FORMULA --Bug 9037817
3071: ,fnd_curr.minimum_accountable_unit MINIMUM_ACCOUNTABLE_UNIT
3072: ,NVL(fnd_curr.precision,0) PRECISION
3073: ,DECODE(NVL(lines.po_release_id, lines.po_header_id),
3074: NULL, NULL, 201) REF_DOC_APPLICATION_ID

Line 3859: ,'STANDARD_TC'

3855: -- ,NULL -- REPORTING_CURRENCY_CODE
3856: ,TAX_AMT
3857: ,TAX_AMT_FUNCL_CURR
3858: ,TAX_AMT_TAX_CURR
3859: ,'STANDARD_TC'
3860: -- ,NULL -- TAX_CODE
3861: ,TAX_DATE
3862: ,TAX_DETERMINE_DATE
3863: ,TAX_POINT_DATE

Line 3869: -- Bug 9037817 'STANDARD_TB'

3865: -- ,ROUNDING_RULE_CODE
3866: ,TAXABLE_AMT
3867: ,TAXABLE_AMT_FUNCL_CURR
3868: ,TAXABLE_AMT_TAX_CURR
3869: -- Bug 9037817 'STANDARD_TB'
3870: ,TAXABLE_BASIS_FORMULA
3871: ,TRX_DATE
3872: ,TRX_LINE_DATE
3873: ,TRX_LINE_QUANTITY

Line 3954: 'STANDARD', 'STANDARD INVOICES' ,

3950: NVL(lines1.org_id,-99) INTERNAL_ORGANIZATION_ID
3951: ,200 APPLICATION_ID
3952: ,'AP_INVOICES' ENTITY_CODE
3953: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,
3954: 'STANDARD', 'STANDARD INVOICES' ,
3955: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
3956: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
3957: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
3958: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409

Line 3955: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409

3951: ,200 APPLICATION_ID
3952: ,'AP_INVOICES' ENTITY_CODE
3953: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,
3954: 'STANDARD', 'STANDARD INVOICES' ,
3955: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
3956: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
3957: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
3958: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
3959: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409

Line 3956: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409

3952: ,'AP_INVOICES' ENTITY_CODE
3953: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,
3954: 'STANDARD', 'STANDARD INVOICES' ,
3955: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
3956: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
3957: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
3958: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
3959: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
3960: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409

Line 3957: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409

3953: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,
3954: 'STANDARD', 'STANDARD INVOICES' ,
3955: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
3956: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
3957: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
3958: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
3959: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
3960: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
3961: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409

Line 3958: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409

3954: 'STANDARD', 'STANDARD INVOICES' ,
3955: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
3956: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
3957: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
3958: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
3959: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
3960: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
3961: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
3962: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409

Line 3959: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409

3955: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
3956: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
3957: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
3958: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
3959: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
3960: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
3961: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
3962: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
3963: 'PREPAYMENT','PREPAYMENT INVOICES' ,

Line 3960: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409

3956: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
3957: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
3958: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
3959: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
3960: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
3961: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
3962: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
3963: 'PREPAYMENT','PREPAYMENT INVOICES' ,
3964: 'EXPENSE REPORT','EXPENSE REPORTS' ,

Line 3961: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409

3957: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
3958: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
3959: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
3960: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
3961: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
3962: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
3963: 'PREPAYMENT','PREPAYMENT INVOICES' ,
3964: 'EXPENSE REPORT','EXPENSE REPORTS' ,
3965: 'INTEREST INVOICE','INTEREST INVOICES','NA') EVENT_CLASS_CODE

Line 3962: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409

3958: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
3959: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
3960: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
3961: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
3962: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
3963: 'PREPAYMENT','PREPAYMENT INVOICES' ,
3964: 'EXPENSE REPORT','EXPENSE REPORTS' ,
3965: 'INTEREST INVOICE','INTEREST INVOICES','NA') EVENT_CLASS_CODE
3966: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,

Line 3967: 'STANDARD','STANDARD INVOICE CREATED',

3963: 'PREPAYMENT','PREPAYMENT INVOICES' ,
3964: 'EXPENSE REPORT','EXPENSE REPORTS' ,
3965: 'INTEREST INVOICE','INTEREST INVOICES','NA') EVENT_CLASS_CODE
3966: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3967: 'STANDARD','STANDARD INVOICE CREATED',
3968: 'PREPAYMENT','PREPAYMENT INVOICE CREATED',
3969: 'EXPENSE REPORT','EXPENSE REPORT CREATED',
3970: 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
3971: ,(CASE WHEN inv.invoice_type_lookup_code in

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

3970: 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
3971: ,(CASE WHEN inv.invoice_type_lookup_code in
3972: ('ADJUSTMENT','CREDIT','DEBIT','INTEREST',
3973: 'MIXED','QUICKDEFAULT','PO PRICE ADJUST',
3974: 'QUICKMATCH','STANDARD','AWT')
3975: THEN 'PURCHASE_TRANSACTION'
3976: WHEN (inv.invoice_type_lookup_code =
3977: 'PREPAYMENT')
3978: THEN 'PURCHASE_PREPAYMENTTRANSACTION'

Line 4019: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE

4015: ,DECODE(lines1.corrected_inv_id, NULL, NULL, 200) ADJUSTED_DOC_APPLICATION_ID
4016: ,DECODE(lines1.corrected_inv_id, NULL, NULL,
4017: 'AP_INVOICES') ADJUSTED_DOC_ENTITY_CODE
4018: ,DECODE(lines1.corrected_inv_id, NULL, NULL,
4019: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE
4020: ,lines1.corrected_inv_id ADJUSTED_DOC_TRX_ID
4021: ,lines1.Corrected_Line_Number ADJUSTED_DOC_LINE_ID
4022: -- ,NULL ADJUSTED_DOC_NUMBER
4023: -- ,NULL ADJUSTED_DOC_DATE

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

4080: ,taxes.tax_currency_code -- TAX_CURRENCY_CODE
4081: ,inv.exchange_date TAX_CURRENCY_CONVERSION_DATE
4082: ,inv.exchange_rate TAX_CURRENCY_CONVERSION_RATE
4083: ,inv.exchange_rate_type TAX_CURRENCY_CONVERSION_TYPE
4084: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','PRORATED_TB','STANDARD_TB') TAXABLE_BASIS_FORMULA
4085: ,taxes.tax_id -- TAX_ID
4086: ,rates.percentage_rate TAX_RATE
4087: ,rates.tax_rate_code -- TAX_RATE_CODE
4088: ,rates.tax_rate_id -- TAX_RATE_ID

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

4126: ,ap_dists.base_amount REC_NREC_TAX_AMT_TAX_CURR
4127: ,DECODE(ap_dists.line_type_lookup_code,
4128: 'REC_TAX', 'AD_HOC_RECOVERY', NULL) RECOVERY_RATE_CODE
4129: ,DECODE(ap_dists.line_type_lookup_code,
4130: 'REC_TAX', 'STANDARD', NULL) RECOVERY_TYPE_CODE
4131: ,NVL(ap_dists.amount,0) TAX_AMT
4132: ,ap_dists.base_amount TAX_AMT_FUNCL_CURR
4133: ,ap_dists.base_amount TAX_AMT_TAX_CURR
4134: -- ,NULL RECOVERY_TYPE_ID