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_FLY_TRX_UPGRADE_AP_PKG dependencies on STANDARD

Line 583: ,'STANDARD_TB' -- TAXABLE_BASIS_FORMULA

579: ,CURRENCY_CONVERSION_DATE
580: ,CURRENCY_CONVERSION_TYPE
581: ,CURRENCY_CONVERSION_RATE
582: -- ,NULL -- SUMMARIZATION_TEMPLATE_ID
583: ,'STANDARD_TB' -- TAXABLE_BASIS_FORMULA
584: ,'STANDARD_TC' -- TAX_CALCULATION_FORMULA
585: ,HISTORICAL_FLAG
586: ,CANCEL_FLAG
587: ,'N' -- DELETE_FLAG

Line 584: ,'STANDARD_TC' -- TAX_CALCULATION_FORMULA

580: ,CURRENCY_CONVERSION_TYPE
581: ,CURRENCY_CONVERSION_RATE
582: -- ,NULL -- SUMMARIZATION_TEMPLATE_ID
583: ,'STANDARD_TB' -- TAXABLE_BASIS_FORMULA
584: ,'STANDARD_TC' -- TAX_CALCULATION_FORMULA
585: ,HISTORICAL_FLAG
586: ,CANCEL_FLAG
587: ,'N' -- DELETE_FLAG
588: ,TAX_AMT_INCLUDED_FLAG

Line 676: 'STANDARD', 'STANDARD INVOICES',

672: ,NVL(lines.org_id,-99) INTERNAL_ORGANIZATION_ID
673: ,200 APPLICATION_ID
674: ,'AP_INVOICES' ENTITY_CODE
675: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
676: 'STANDARD', 'STANDARD INVOICES',
677: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
678: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
679: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
680: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409

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

673: ,200 APPLICATION_ID
674: ,'AP_INVOICES' ENTITY_CODE
675: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
676: 'STANDARD', 'STANDARD INVOICES',
677: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
678: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
679: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
680: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
681: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409

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

674: ,'AP_INVOICES' ENTITY_CODE
675: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
676: 'STANDARD', 'STANDARD INVOICES',
677: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
678: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
679: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
680: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
681: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
682: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409

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

675: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
676: 'STANDARD', 'STANDARD INVOICES',
677: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
678: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
679: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
680: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
681: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
682: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
683: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409

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

676: 'STANDARD', 'STANDARD INVOICES',
677: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
678: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
679: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
680: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
681: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
682: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
683: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
684: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409

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

677: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
678: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
679: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
680: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
681: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
682: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
683: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
684: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
685: 'PREPAYMENT', 'PREPAYMENT INVOICES',

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

678: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
679: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
680: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
681: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
682: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
683: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
684: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
685: 'PREPAYMENT', 'PREPAYMENT INVOICES',
686: 'EXPENSE REPORT', 'EXPENSE REPORTS',

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

679: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
680: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
681: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
682: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
683: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
684: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
685: 'PREPAYMENT', 'PREPAYMENT INVOICES',
686: 'EXPENSE REPORT', 'EXPENSE REPORTS',
687: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE

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

680: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
681: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
682: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
683: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
684: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
685: 'PREPAYMENT', 'PREPAYMENT INVOICES',
686: 'EXPENSE REPORT', 'EXPENSE REPORTS',
687: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
688: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE, 'STANDARD', 1,

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

684: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
685: 'PREPAYMENT', 'PREPAYMENT INVOICES',
686: 'EXPENSE REPORT', 'EXPENSE REPORTS',
687: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
688: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE, 'STANDARD', 1,
689: 'PREPAYMENT', 7, 'EXPENSE REPORT', 2, NULL) EVENT_CLASS_MAPPING_ID
690: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
691: 'STANDARD','STANDARD INVOICE CREATED',
692: 'PREPAYMENT','PREPAYMENT INVOICE CREATED',

Line 691: 'STANDARD','STANDARD INVOICE CREATED',

687: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
688: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE, 'STANDARD', 1,
689: 'PREPAYMENT', 7, 'EXPENSE REPORT', 2, NULL) EVENT_CLASS_MAPPING_ID
690: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
691: 'STANDARD','STANDARD INVOICE CREATED',
692: 'PREPAYMENT','PREPAYMENT INVOICE CREATED',
693: 'EXPENSE REPORT','EXPENSE REPORT CREATED',
694: 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
695: ,(CASE

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

695: ,(CASE
696: WHEN inv.invoice_type_lookup_code in
697: ('ADJUSTMENT','CREDIT','DEBIT','INTEREST',
698: 'MIXED','QUICKDEFAULT','PO PRICE ADJUST',
699: 'QUICKMATCH','STANDARD','AWT')
700: THEN 'PURCHASE_TRANSACTION'
701: WHEN inv.invoice_type_lookup_code = 'PREPAYMENT'
702: THEN 'PURCHASE_PREPAYMENTTRANSACTION'
703: WHEN inv.invoice_type_lookup_code='EXPENSE REPORT'

Line 714: 'STANDARD', 'STANDARD INVOICES',

710: ,DECODE(lines.po_line_location_id,
711: NULL, DECODE(lines.line_type_lookup_code,
712: 'PREPAY', 'PREPAY_APPLICATION',
713: DECODE(inv.invoice_type_lookup_code,
714: 'STANDARD', 'STANDARD INVOICES',
715: 'CREDIT','AP_CREDIT_MEMO',
716: 'CREDIT MEMO REQUEST', 'AP_CREDIT_MEMO',
717: 'DEBIT','AP_DEBIT_MEMO',
718: 'PREPAYMENT','PREPAYMENT INVOICES',

Line 720: 'STANDARD INVOICES'

716: 'CREDIT MEMO REQUEST', 'AP_CREDIT_MEMO',
717: 'DEBIT','AP_DEBIT_MEMO',
718: 'PREPAYMENT','PREPAYMENT INVOICES',
719: 'EXPENSE REPORT','EXPENSE REPORTS',
720: 'STANDARD INVOICES'
721: )
722: ),
723: DECODE(poll.shipment_type,
724: 'PREPAYMENT', DECODE(poll.payment_type,

Line 731: 'STANDARD INVOICES')

727: 'RATE', 'FINANCING',
728: 'LUMPSUM', 'FINANCING',
729: DECODE(poll.matching_basis,
730: 'AMOUNT','AMOUNT_MATCHED',
731: 'STANDARD INVOICES')
732: ),
733: DECODE(poll.matching_basis,
734: 'AMOUNT','AMOUNT_MATCHED',
735: 'STANDARD INVOICES')

Line 735: 'STANDARD INVOICES')

731: 'STANDARD INVOICES')
732: ),
733: DECODE(poll.matching_basis,
734: 'AMOUNT','AMOUNT_MATCHED',
735: 'STANDARD INVOICES')
736: )
737: ) LINE_CLASS
738: -- ,NULL APPLICATION_DOC_STATUS
739: ,lines.line_type_lookup_code AP_LINE_LOOKUP_CODE

Line 794: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE

790: ,DECODE(lines.corrected_inv_id, NULL, NULL, 200) ADJUSTED_DOC_APPLICATION_ID
791: ,DECODE(lines.corrected_inv_id, NULL, NULL,
792: 'AP_INVOICES') ADJUSTED_DOC_ENTITY_CODE
793: ,DECODE(lines.corrected_inv_id, NULL, NULL,
794: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE
795: ,lines.corrected_inv_id ADJUSTED_DOC_TRX_ID
796: ,lines.corrected_line_number ADJUSTED_DOC_LINE_ID
797: -- ,NULL ADJUSTED_DOC_NUMBER
798: -- ,NULL ADJUSTED_DOC_DATE

Line 1007: 'STANDARD', 'STANDARD INVOICES',

1003: AND NOT EXISTS (SELECT 1 FROM zx_lines_det_factors zxdet --Bug 6738188
1004: WHERE zxdet.application_id = 200
1005: AND zxdet.entity_code = 'AP_INVOICES'
1006: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
1007: 'STANDARD', 'STANDARD INVOICES',
1008: 'CREDIT' , 'STANDARD INVOICES',
1009: 'DEBIT' , 'STANDARD INVOICES',
1010: 'MIXED' , 'STANDARD INVOICES',
1011: 'ADJUSTMENT','STANDARD INVOICES',

Line 1008: 'CREDIT' , 'STANDARD INVOICES',

1004: WHERE zxdet.application_id = 200
1005: AND zxdet.entity_code = 'AP_INVOICES'
1006: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
1007: 'STANDARD', 'STANDARD INVOICES',
1008: 'CREDIT' , 'STANDARD INVOICES',
1009: 'DEBIT' , 'STANDARD INVOICES',
1010: 'MIXED' , 'STANDARD INVOICES',
1011: 'ADJUSTMENT','STANDARD INVOICES',
1012: 'PO PRICE ADJUST','STANDARD INVOICES',

Line 1009: 'DEBIT' , 'STANDARD INVOICES',

1005: AND zxdet.entity_code = 'AP_INVOICES'
1006: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
1007: 'STANDARD', 'STANDARD INVOICES',
1008: 'CREDIT' , 'STANDARD INVOICES',
1009: 'DEBIT' , 'STANDARD INVOICES',
1010: 'MIXED' , 'STANDARD INVOICES',
1011: 'ADJUSTMENT','STANDARD INVOICES',
1012: 'PO PRICE ADJUST','STANDARD INVOICES',
1013: 'INVOICE REQUEST','STANDARD INVOICES',

Line 1010: 'MIXED' , 'STANDARD INVOICES',

1006: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
1007: 'STANDARD', 'STANDARD INVOICES',
1008: 'CREDIT' , 'STANDARD INVOICES',
1009: 'DEBIT' , 'STANDARD INVOICES',
1010: 'MIXED' , 'STANDARD INVOICES',
1011: 'ADJUSTMENT','STANDARD INVOICES',
1012: 'PO PRICE ADJUST','STANDARD INVOICES',
1013: 'INVOICE REQUEST','STANDARD INVOICES',
1014: 'CREDIT MEMO REQUEST','STANDARD INVOICES',

Line 1011: 'ADJUSTMENT','STANDARD INVOICES',

1007: 'STANDARD', 'STANDARD INVOICES',
1008: 'CREDIT' , 'STANDARD INVOICES',
1009: 'DEBIT' , 'STANDARD INVOICES',
1010: 'MIXED' , 'STANDARD INVOICES',
1011: 'ADJUSTMENT','STANDARD INVOICES',
1012: 'PO PRICE ADJUST','STANDARD INVOICES',
1013: 'INVOICE REQUEST','STANDARD INVOICES',
1014: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
1015: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',

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

1008: 'CREDIT' , 'STANDARD INVOICES',
1009: 'DEBIT' , 'STANDARD INVOICES',
1010: 'MIXED' , 'STANDARD INVOICES',
1011: 'ADJUSTMENT','STANDARD INVOICES',
1012: 'PO PRICE ADJUST','STANDARD INVOICES',
1013: 'INVOICE REQUEST','STANDARD INVOICES',
1014: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
1015: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
1016: 'PREPAYMENT', 'PREPAYMENT INVOICES',

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

1009: 'DEBIT' , 'STANDARD INVOICES',
1010: 'MIXED' , 'STANDARD INVOICES',
1011: 'ADJUSTMENT','STANDARD INVOICES',
1012: 'PO PRICE ADJUST','STANDARD INVOICES',
1013: 'INVOICE REQUEST','STANDARD INVOICES',
1014: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
1015: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
1016: 'PREPAYMENT', 'PREPAYMENT INVOICES',
1017: 'EXPENSE REPORT', 'EXPENSE REPORTS',

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

1010: 'MIXED' , 'STANDARD INVOICES',
1011: 'ADJUSTMENT','STANDARD INVOICES',
1012: 'PO PRICE ADJUST','STANDARD INVOICES',
1013: 'INVOICE REQUEST','STANDARD INVOICES',
1014: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
1015: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
1016: 'PREPAYMENT', 'PREPAYMENT INVOICES',
1017: 'EXPENSE REPORT', 'EXPENSE REPORTS',
1018: 'INTEREST INVOICE', 'INTEREST INVOICES','NA')

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

1011: 'ADJUSTMENT','STANDARD INVOICES',
1012: 'PO PRICE ADJUST','STANDARD INVOICES',
1013: 'INVOICE REQUEST','STANDARD INVOICES',
1014: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
1015: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
1016: 'PREPAYMENT', 'PREPAYMENT INVOICES',
1017: 'EXPENSE REPORT', 'EXPENSE REPORTS',
1018: 'INTEREST INVOICE', 'INTEREST INVOICES','NA')
1019: AND zxdet.trx_id=inv.invoice_id

Line 1683: ,'STANDARD_TC'

1679: -- ,NULL -- REPORTING_CURRENCY_CODE
1680: ,TAX_AMT
1681: ,TAX_AMT_FUNCL_CURR
1682: ,TAX_AMT_TAX_CURR
1683: ,'STANDARD_TC'
1684: -- ,NULL -- TAX_CODE
1685: ,TAX_DATE
1686: ,TAX_DETERMINE_DATE
1687: ,TAX_POINT_DATE

Line 1693: ,'STANDARD_TB' -- TAXABLE_BASIS_FORMULA

1689: -- ,ROUNDING_RULE_CODE
1690: ,TAXABLE_AMT
1691: ,TAXABLE_AMT_FUNCL_CURR
1692: ,TAXABLE_AMT_TAX_CURR
1693: ,'STANDARD_TB' -- TAXABLE_BASIS_FORMULA
1694: ,TRX_DATE
1695: ,TRX_LINE_DATE
1696: ,TRX_LINE_QUANTITY
1697: -- ,NULL -- UNROUNDED_TAX_AMT

Line 1777: 'STANDARD', 'STANDARD INVOICES' ,

1773: NVL(lines1.org_id,-99) INTERNAL_ORGANIZATION_ID
1774: ,200 APPLICATION_ID
1775: ,'AP_INVOICES' ENTITY_CODE
1776: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,
1777: 'STANDARD', 'STANDARD INVOICES' ,
1778: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
1779: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
1780: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
1781: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409

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

1774: ,200 APPLICATION_ID
1775: ,'AP_INVOICES' ENTITY_CODE
1776: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,
1777: 'STANDARD', 'STANDARD INVOICES' ,
1778: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
1779: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
1780: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
1781: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
1782: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409

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

1775: ,'AP_INVOICES' ENTITY_CODE
1776: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,
1777: 'STANDARD', 'STANDARD INVOICES' ,
1778: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
1779: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
1780: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
1781: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
1782: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
1783: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409

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

1776: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,
1777: 'STANDARD', 'STANDARD INVOICES' ,
1778: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
1779: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
1780: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
1781: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
1782: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
1783: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
1784: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409

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

1777: 'STANDARD', 'STANDARD INVOICES' ,
1778: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
1779: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
1780: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
1781: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
1782: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
1783: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
1784: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
1785: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409

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

1778: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
1779: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
1780: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
1781: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
1782: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
1783: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
1784: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
1785: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
1786: 'PREPAYMENT','PREPAYMENT INVOICES' ,

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

1779: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
1780: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
1781: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
1782: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
1783: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
1784: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
1785: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
1786: 'PREPAYMENT','PREPAYMENT INVOICES' ,
1787: 'EXPENSE REPORT','EXPENSE REPORTS' ,

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

1780: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
1781: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
1782: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
1783: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
1784: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
1785: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
1786: 'PREPAYMENT','PREPAYMENT INVOICES' ,
1787: 'EXPENSE REPORT','EXPENSE REPORTS' ,
1788: 'INTEREST INVOICE','INTEREST INVOICES','NA') EVENT_CLASS_CODE

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

1781: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
1782: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
1783: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
1784: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
1785: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
1786: 'PREPAYMENT','PREPAYMENT INVOICES' ,
1787: 'EXPENSE REPORT','EXPENSE REPORTS' ,
1788: 'INTEREST INVOICE','INTEREST INVOICES','NA') EVENT_CLASS_CODE
1789: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,

Line 1790: 'STANDARD','STANDARD INVOICE CREATED',

1786: 'PREPAYMENT','PREPAYMENT INVOICES' ,
1787: 'EXPENSE REPORT','EXPENSE REPORTS' ,
1788: 'INTEREST INVOICE','INTEREST INVOICES','NA') EVENT_CLASS_CODE
1789: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
1790: 'STANDARD','STANDARD INVOICE CREATED',
1791: 'PREPAYMENT','PREPAYMENT INVOICE CREATED',
1792: 'EXPENSE REPORT','EXPENSE REPORT CREATED',
1793: 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
1794: ,(CASE WHEN inv.invoice_type_lookup_code in

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

1793: 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
1794: ,(CASE WHEN inv.invoice_type_lookup_code in
1795: ('ADJUSTMENT','CREDIT','DEBIT','INTEREST',
1796: 'MIXED','QUICKDEFAULT','PO PRICE ADJUST',
1797: 'QUICKMATCH','STANDARD','AWT')
1798: THEN 'PURCHASE_TRANSACTION'
1799: WHEN (inv.invoice_type_lookup_code =
1800: 'PREPAYMENT')
1801: THEN 'PURCHASE_PREPAYMENTTRANSACTION'

Line 1842: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE

1838: ,DECODE(lines1.corrected_inv_id, NULL, NULL, 200) ADJUSTED_DOC_APPLICATION_ID
1839: ,DECODE(lines1.corrected_inv_id, NULL, NULL,
1840: 'AP_INVOICES') ADJUSTED_DOC_ENTITY_CODE
1841: ,DECODE(lines1.corrected_inv_id, NULL, NULL,
1842: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE
1843: ,lines1.corrected_inv_id ADJUSTED_DOC_TRX_ID
1844: ,lines1.Corrected_Line_Number ADJUSTED_DOC_LINE_ID
1845: -- ,NULL ADJUSTED_DOC_NUMBER
1846: -- ,NULL ADJUSTED_DOC_DATE

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

1946: ,ap_dists.base_amount REC_NREC_TAX_AMT_TAX_CURR
1947: ,DECODE(ap_dists.line_type_lookup_code,
1948: 'REC_TAX', 'AD_HOC_RECOVERY', NULL) RECOVERY_RATE_CODE
1949: ,DECODE(ap_dists.line_type_lookup_code,
1950: 'REC_TAX', 'STANDARD', NULL) RECOVERY_TYPE_CODE
1951: ,NVL(ap_dists.amount,0) TAX_AMT
1952: ,ap_dists.base_amount TAX_AMT_FUNCL_CURR
1953: ,ap_dists.base_amount TAX_AMT_TAX_CURR
1954: -- ,NULL RECOVERY_TYPE_ID

Line 2117: 'STANDARD', 'STANDARD INVOICES',

2113: AND NOT EXISTS -- Bug 6738188
2114: (SELECT 1 FROM zx_lines zxl
2115: WHERE zxl.application_id = 200
2116: AND zxl.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2117: 'STANDARD', 'STANDARD INVOICES',
2118: 'CREDIT' , 'STANDARD INVOICES',
2119: 'DEBIT' , 'STANDARD INVOICES',
2120: 'MIXED' , 'STANDARD INVOICES',
2121: 'ADJUSTMENT','STANDARD INVOICES',

Line 2118: 'CREDIT' , 'STANDARD INVOICES',

2114: (SELECT 1 FROM zx_lines zxl
2115: WHERE zxl.application_id = 200
2116: AND zxl.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2117: 'STANDARD', 'STANDARD INVOICES',
2118: 'CREDIT' , 'STANDARD INVOICES',
2119: 'DEBIT' , 'STANDARD INVOICES',
2120: 'MIXED' , 'STANDARD INVOICES',
2121: 'ADJUSTMENT','STANDARD INVOICES',
2122: 'PO PRICE ADJUST','STANDARD INVOICES',

Line 2119: 'DEBIT' , 'STANDARD INVOICES',

2115: WHERE zxl.application_id = 200
2116: AND zxl.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2117: 'STANDARD', 'STANDARD INVOICES',
2118: 'CREDIT' , 'STANDARD INVOICES',
2119: 'DEBIT' , 'STANDARD INVOICES',
2120: 'MIXED' , 'STANDARD INVOICES',
2121: 'ADJUSTMENT','STANDARD INVOICES',
2122: 'PO PRICE ADJUST','STANDARD INVOICES',
2123: 'INVOICE REQUEST','STANDARD INVOICES',

Line 2120: 'MIXED' , 'STANDARD INVOICES',

2116: AND zxl.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2117: 'STANDARD', 'STANDARD INVOICES',
2118: 'CREDIT' , 'STANDARD INVOICES',
2119: 'DEBIT' , 'STANDARD INVOICES',
2120: 'MIXED' , 'STANDARD INVOICES',
2121: 'ADJUSTMENT','STANDARD INVOICES',
2122: 'PO PRICE ADJUST','STANDARD INVOICES',
2123: 'INVOICE REQUEST','STANDARD INVOICES',
2124: 'CREDIT MEMO REQUEST','STANDARD INVOICES',

Line 2121: 'ADJUSTMENT','STANDARD INVOICES',

2117: 'STANDARD', 'STANDARD INVOICES',
2118: 'CREDIT' , 'STANDARD INVOICES',
2119: 'DEBIT' , 'STANDARD INVOICES',
2120: 'MIXED' , 'STANDARD INVOICES',
2121: 'ADJUSTMENT','STANDARD INVOICES',
2122: 'PO PRICE ADJUST','STANDARD INVOICES',
2123: 'INVOICE REQUEST','STANDARD INVOICES',
2124: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
2125: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',

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

2118: 'CREDIT' , 'STANDARD INVOICES',
2119: 'DEBIT' , 'STANDARD INVOICES',
2120: 'MIXED' , 'STANDARD INVOICES',
2121: 'ADJUSTMENT','STANDARD INVOICES',
2122: 'PO PRICE ADJUST','STANDARD INVOICES',
2123: 'INVOICE REQUEST','STANDARD INVOICES',
2124: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
2125: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
2126: 'PREPAYMENT', 'PREPAYMENT INVOICES',

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

2119: 'DEBIT' , 'STANDARD INVOICES',
2120: 'MIXED' , 'STANDARD INVOICES',
2121: 'ADJUSTMENT','STANDARD INVOICES',
2122: 'PO PRICE ADJUST','STANDARD INVOICES',
2123: 'INVOICE REQUEST','STANDARD INVOICES',
2124: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
2125: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
2126: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2127: 'EXPENSE REPORT', 'EXPENSE REPORTS',

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

2120: 'MIXED' , 'STANDARD INVOICES',
2121: 'ADJUSTMENT','STANDARD INVOICES',
2122: 'PO PRICE ADJUST','STANDARD INVOICES',
2123: 'INVOICE REQUEST','STANDARD INVOICES',
2124: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
2125: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
2126: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2127: 'EXPENSE REPORT', 'EXPENSE REPORTS',
2128: 'INTEREST INVOICE', 'INTEREST INVOICES','NA')

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

2121: 'ADJUSTMENT','STANDARD INVOICES',
2122: 'PO PRICE ADJUST','STANDARD INVOICES',
2123: 'INVOICE REQUEST','STANDARD INVOICES',
2124: 'CREDIT MEMO REQUEST','STANDARD INVOICES',
2125: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
2126: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2127: 'EXPENSE REPORT', 'EXPENSE REPORTS',
2128: 'INTEREST INVOICE', 'INTEREST INVOICES','NA')
2129: AND zxl.trx_id = inv.invoice_id

Line 2724: ,'STANDARD_TB' -- TAXABLE_BASIS_FORMULA

2720: ,CURRENCY_CONVERSION_DATE
2721: ,CURRENCY_CONVERSION_TYPE
2722: ,CURRENCY_CONVERSION_RATE
2723: -- ,NULL -- SUMMARIZATION_TEMPLATE_ID
2724: ,'STANDARD_TB' -- TAXABLE_BASIS_FORMULA
2725: ,'STANDARD_TC' -- TAX_CALCULATION_FORMULA
2726: ,HISTORICAL_FLAG
2727: ,CANCEL_FLAG
2728: ,'N' -- DELETE_FLAG

Line 2725: ,'STANDARD_TC' -- TAX_CALCULATION_FORMULA

2721: ,CURRENCY_CONVERSION_TYPE
2722: ,CURRENCY_CONVERSION_RATE
2723: -- ,NULL -- SUMMARIZATION_TEMPLATE_ID
2724: ,'STANDARD_TB' -- TAXABLE_BASIS_FORMULA
2725: ,'STANDARD_TC' -- TAX_CALCULATION_FORMULA
2726: ,HISTORICAL_FLAG
2727: ,CANCEL_FLAG
2728: ,'N' -- DELETE_FLAG
2729: ,TAX_AMT_INCLUDED_FLAG

Line 2817: 'STANDARD', 'STANDARD INVOICES',

2813: ,NVL(lines.org_id,-99) INTERNAL_ORGANIZATION_ID
2814: ,200 APPLICATION_ID
2815: ,'AP_INVOICES' ENTITY_CODE
2816: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2817: 'STANDARD', 'STANDARD INVOICES',
2818: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
2819: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
2820: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
2821: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409

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

2814: ,200 APPLICATION_ID
2815: ,'AP_INVOICES' ENTITY_CODE
2816: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2817: 'STANDARD', 'STANDARD INVOICES',
2818: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
2819: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
2820: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
2821: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
2822: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409

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

2815: ,'AP_INVOICES' ENTITY_CODE
2816: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2817: 'STANDARD', 'STANDARD INVOICES',
2818: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
2819: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
2820: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
2821: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
2822: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
2823: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409

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

2816: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2817: 'STANDARD', 'STANDARD INVOICES',
2818: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
2819: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
2820: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
2821: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
2822: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
2823: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
2824: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409

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

2817: 'STANDARD', 'STANDARD INVOICES',
2818: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
2819: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
2820: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
2821: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
2822: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
2823: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
2824: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
2825: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409

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

2818: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
2819: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
2820: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
2821: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
2822: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
2823: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
2824: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
2825: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
2826: 'PREPAYMENT', 'PREPAYMENT INVOICES',

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

2819: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
2820: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
2821: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
2822: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
2823: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
2824: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
2825: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
2826: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2827: 'EXPENSE REPORT', 'EXPENSE REPORTS',

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

2820: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
2821: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
2822: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
2823: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
2824: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
2825: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
2826: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2827: 'EXPENSE REPORT', 'EXPENSE REPORTS',
2828: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE

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

2821: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
2822: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
2823: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
2824: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
2825: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
2826: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2827: 'EXPENSE REPORT', 'EXPENSE REPORTS',
2828: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
2829: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE, 'STANDARD', 1,

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

2825: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
2826: 'PREPAYMENT', 'PREPAYMENT INVOICES',
2827: 'EXPENSE REPORT', 'EXPENSE REPORTS',
2828: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
2829: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE, 'STANDARD', 1,
2830: 'PREPAYMENT', 7, 'EXPENSE REPORT', 2, NULL) EVENT_CLASS_MAPPING_ID
2831: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2832: 'STANDARD','STANDARD INVOICE CREATED',
2833: 'PREPAYMENT','PREPAYMENT INVOICE CREATED',

Line 2832: 'STANDARD','STANDARD INVOICE CREATED',

2828: 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
2829: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE, 'STANDARD', 1,
2830: 'PREPAYMENT', 7, 'EXPENSE REPORT', 2, NULL) EVENT_CLASS_MAPPING_ID
2831: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2832: 'STANDARD','STANDARD INVOICE CREATED',
2833: 'PREPAYMENT','PREPAYMENT INVOICE CREATED',
2834: 'EXPENSE REPORT','EXPENSE REPORT CREATED',
2835: 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
2836: ,(CASE

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

2836: ,(CASE
2837: WHEN inv.invoice_type_lookup_code in
2838: ('ADJUSTMENT','CREDIT','DEBIT','INTEREST',
2839: 'MIXED','QUICKDEFAULT','PO PRICE ADJUST',
2840: 'QUICKMATCH','STANDARD','AWT')
2841: THEN 'PURCHASE_TRANSACTION'
2842: WHEN inv.invoice_type_lookup_code = 'PREPAYMENT'
2843: THEN 'PURCHASE_PREPAYMENTTRANSACTION'
2844: WHEN inv.invoice_type_lookup_code='EXPENSE REPORT'

Line 2855: 'STANDARD', 'STANDARD INVOICES',

2851: ,DECODE(lines.po_line_location_id,
2852: NULL, DECODE(lines.line_type_lookup_code,
2853: 'PREPAY', 'PREPAY_APPLICATION',
2854: DECODE(inv.invoice_type_lookup_code,
2855: 'STANDARD', 'STANDARD INVOICES',
2856: 'CREDIT','AP_CREDIT_MEMO',
2857: 'CREDIT MEMO REQUEST', 'AP_CREDIT_MEMO',
2858: 'DEBIT','AP_DEBIT_MEMO',
2859: 'PREPAYMENT','PREPAYMENT INVOICES',

Line 2861: 'STANDARD INVOICES'

2857: 'CREDIT MEMO REQUEST', 'AP_CREDIT_MEMO',
2858: 'DEBIT','AP_DEBIT_MEMO',
2859: 'PREPAYMENT','PREPAYMENT INVOICES',
2860: 'EXPENSE REPORT','EXPENSE REPORTS',
2861: 'STANDARD INVOICES'
2862: )
2863: ),
2864: DECODE(poll.shipment_type,
2865: 'PREPAYMENT', DECODE(poll.payment_type,

Line 2872: 'STANDARD INVOICES')

2868: 'RATE', 'FINANCING',
2869: 'LUMPSUM', 'FINANCING',
2870: DECODE(poll.matching_basis,
2871: 'AMOUNT','AMOUNT_MATCHED',
2872: 'STANDARD INVOICES')
2873: ),
2874: DECODE(poll.matching_basis,
2875: 'AMOUNT','AMOUNT_MATCHED',
2876: 'STANDARD INVOICES')

Line 2876: 'STANDARD INVOICES')

2872: 'STANDARD INVOICES')
2873: ),
2874: DECODE(poll.matching_basis,
2875: 'AMOUNT','AMOUNT_MATCHED',
2876: 'STANDARD INVOICES')
2877: )
2878: ) LINE_CLASS
2879: -- ,NULL APPLICATION_DOC_STATUS
2880: ,lines.line_type_lookup_code AP_LINE_LOOKUP_CODE

Line 2935: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE

2931: ,DECODE(lines.corrected_inv_id, NULL, NULL, 200) ADJUSTED_DOC_APPLICATION_ID
2932: ,DECODE(lines.corrected_inv_id, NULL, NULL,
2933: 'AP_INVOICES') ADJUSTED_DOC_ENTITY_CODE
2934: ,DECODE(lines.corrected_inv_id, NULL, NULL,
2935: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE
2936: ,lines.corrected_inv_id ADJUSTED_DOC_TRX_ID
2937: ,lines.corrected_line_number ADJUSTED_DOC_LINE_ID
2938: -- ,NULL ADJUSTED_DOC_NUMBER
2939: -- ,NULL ADJUSTED_DOC_DATE

Line 3808: ,'STANDARD_TC'

3804: -- ,NULL -- REPORTING_CURRENCY_CODE
3805: ,TAX_AMT
3806: ,TAX_AMT_FUNCL_CURR
3807: ,TAX_AMT_TAX_CURR
3808: ,'STANDARD_TC'
3809: -- ,NULL -- TAX_CODE
3810: ,TAX_DATE
3811: ,TAX_DETERMINE_DATE
3812: ,TAX_POINT_DATE

Line 3818: ,'STANDARD_TB' -- TAXABLE_BASIS_FORMULA

3814: -- ,ROUNDING_RULE_CODE
3815: ,TAXABLE_AMT
3816: ,TAXABLE_AMT_FUNCL_CURR
3817: ,TAXABLE_AMT_TAX_CURR
3818: ,'STANDARD_TB' -- TAXABLE_BASIS_FORMULA
3819: ,TRX_DATE
3820: ,TRX_LINE_DATE
3821: ,TRX_LINE_QUANTITY
3822: -- ,NULL -- UNROUNDED_TAX_AMT

Line 3902: 'STANDARD', 'STANDARD INVOICES' ,

3898: NVL(lines1.org_id,-99) INTERNAL_ORGANIZATION_ID
3899: ,200 APPLICATION_ID
3900: ,'AP_INVOICES' ENTITY_CODE
3901: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,
3902: 'STANDARD', 'STANDARD INVOICES' ,
3903: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
3904: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
3905: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
3906: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409

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

3899: ,200 APPLICATION_ID
3900: ,'AP_INVOICES' ENTITY_CODE
3901: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,
3902: 'STANDARD', 'STANDARD INVOICES' ,
3903: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
3904: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
3905: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
3906: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
3907: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409

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

3900: ,'AP_INVOICES' ENTITY_CODE
3901: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,
3902: 'STANDARD', 'STANDARD INVOICES' ,
3903: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
3904: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
3905: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
3906: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
3907: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
3908: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409

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

3901: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,
3902: 'STANDARD', 'STANDARD INVOICES' ,
3903: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
3904: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
3905: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
3906: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
3907: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
3908: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
3909: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409

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

3902: 'STANDARD', 'STANDARD INVOICES' ,
3903: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
3904: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
3905: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
3906: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
3907: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
3908: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
3909: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
3910: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409

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

3903: 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
3904: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
3905: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
3906: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
3907: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
3908: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
3909: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
3910: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
3911: 'PREPAYMENT','PREPAYMENT INVOICES' ,

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

3904: 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
3905: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
3906: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
3907: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
3908: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
3909: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
3910: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
3911: 'PREPAYMENT','PREPAYMENT INVOICES' ,
3912: 'EXPENSE REPORT','EXPENSE REPORTS' ,

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

3905: 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
3906: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
3907: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
3908: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
3909: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
3910: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
3911: 'PREPAYMENT','PREPAYMENT INVOICES' ,
3912: 'EXPENSE REPORT','EXPENSE REPORTS' ,
3913: 'INTEREST INVOICE','INTEREST INVOICES','NA') EVENT_CLASS_CODE

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

3906: 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
3907: 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
3908: 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
3909: 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
3910: 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
3911: 'PREPAYMENT','PREPAYMENT INVOICES' ,
3912: 'EXPENSE REPORT','EXPENSE REPORTS' ,
3913: 'INTEREST INVOICE','INTEREST INVOICES','NA') EVENT_CLASS_CODE
3914: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,

Line 3915: 'STANDARD','STANDARD INVOICE CREATED',

3911: 'PREPAYMENT','PREPAYMENT INVOICES' ,
3912: 'EXPENSE REPORT','EXPENSE REPORTS' ,
3913: 'INTEREST INVOICE','INTEREST INVOICES','NA') EVENT_CLASS_CODE
3914: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3915: 'STANDARD','STANDARD INVOICE CREATED',
3916: 'PREPAYMENT','PREPAYMENT INVOICE CREATED',
3917: 'EXPENSE REPORT','EXPENSE REPORT CREATED',
3918: 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
3919: ,(CASE WHEN inv.invoice_type_lookup_code in

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

3918: 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
3919: ,(CASE WHEN inv.invoice_type_lookup_code in
3920: ('ADJUSTMENT','CREDIT','DEBIT','INTEREST',
3921: 'MIXED','QUICKDEFAULT','PO PRICE ADJUST',
3922: 'QUICKMATCH','STANDARD','AWT')
3923: THEN 'PURCHASE_TRANSACTION'
3924: WHEN (inv.invoice_type_lookup_code =
3925: 'PREPAYMENT')
3926: THEN 'PURCHASE_PREPAYMENTTRANSACTION'

Line 3967: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE

3963: ,DECODE(lines1.corrected_inv_id, NULL, NULL, 200) ADJUSTED_DOC_APPLICATION_ID
3964: ,DECODE(lines1.corrected_inv_id, NULL, NULL,
3965: 'AP_INVOICES') ADJUSTED_DOC_ENTITY_CODE
3966: ,DECODE(lines1.corrected_inv_id, NULL, NULL,
3967: 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE
3968: ,lines1.corrected_inv_id ADJUSTED_DOC_TRX_ID
3969: ,lines1.Corrected_Line_Number ADJUSTED_DOC_LINE_ID
3970: -- ,NULL ADJUSTED_DOC_NUMBER
3971: -- ,NULL ADJUSTED_DOC_DATE

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

4071: ,ap_dists.base_amount REC_NREC_TAX_AMT_TAX_CURR
4072: ,DECODE(ap_dists.line_type_lookup_code,
4073: 'REC_TAX', 'AD_HOC_RECOVERY', NULL) RECOVERY_RATE_CODE
4074: ,DECODE(ap_dists.line_type_lookup_code,
4075: 'REC_TAX', 'STANDARD', NULL) RECOVERY_TYPE_CODE
4076: ,NVL(ap_dists.amount,0) TAX_AMT
4077: ,ap_dists.base_amount TAX_AMT_FUNCL_CURR
4078: ,ap_dists.base_amount TAX_AMT_TAX_CURR
4079: -- ,NULL RECOVERY_TYPE_ID