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.AP_LINES_UPGRADE_SYNC_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_S

Line 664: AP_Invoice_Distributions_S.Nextval) New_Dist_ID,

660: Charge_Allocation_ID,
661: NVL(Item_Charge_Alloc_ID, -99),
662: NVL(Item_Charge_Alloc_ID2, -99),
663: DECODE(Charge_Allocation_ID, NULL, Old_Dist_ID,
664: AP_Invoice_Distributions_S.Nextval) New_Dist_ID,
665: Old_Dist_ID,
666: Item_Dist_ID,
667: Allocated_Amount,
668: Allocated_Base_Amount,

Line 1594: AP_Invoice_Distributions_S.NEXTVAL

1590: AID.Invoice_ID Invoice_ID,
1591: AID.Line_Number Invoice_Line_Number,
1592: (CASE
1593: WHEN Line.Line_Type IN ('IPV','ERV') THEN
1594: AP_Invoice_Distributions_S.NEXTVAL
1595: ELSE DECODE(ACA.Charge_Allocation_ID, NULL, AID.Invoice_Distribution_ID,
1596: NVL(ACA.New_Dist_ID, AP_Invoice_Distributions_S.NEXTVAL))
1597: END) AS Invoice_Distribution_ID,
1598: -- AP_Dist_Line_Num_Upg_S.NEXTVAL Distribution_Line_Number,

Line 1596: NVL(ACA.New_Dist_ID, AP_Invoice_Distributions_S.NEXTVAL))

1592: (CASE
1593: WHEN Line.Line_Type IN ('IPV','ERV') THEN
1594: AP_Invoice_Distributions_S.NEXTVAL
1595: ELSE DECODE(ACA.Charge_Allocation_ID, NULL, AID.Invoice_Distribution_ID,
1596: NVL(ACA.New_Dist_ID, AP_Invoice_Distributions_S.NEXTVAL))
1597: END) AS Invoice_Distribution_ID,
1598: -- AP_Dist_Line_Num_Upg_S.NEXTVAL Distribution_Line_Number,
1599: RANK() OVER (PARTITION BY AID.INVOICE_ID, AID.LINE_NUMBER
1600: ORDER BY NVL(ACA.Charge_Allocation_ID, AID.INVOICE_DISTRIBUTION_ID),

Line 1999: AP_INVOICE_DISTRIBUTIONS_S.NEXTVAL) Invoice_Distribution_ID,

1995: SELECT AID.Batch_ID Batch_ID,
1996: AID.Invoice_ID Invoice_ID,
1997: AID.Line_Number Invoice_Line_Number,
1998: DECODE(Line.Line_Type, 'TAX', TAA.New_Dist_ID,
1999: AP_INVOICE_DISTRIBUTIONS_S.NEXTVAL) Invoice_Distribution_ID,
2000: -- AP_DIST_LINE_NUM_UPG_S.NEXTVAL Distribution_Line_Number,
2001: RANK() OVER (PARTITION BY AID.INVOICE_ID, AID.LINE_NUMBER
2002: ORDER BY NVL(TAA.Charge_Allocation_ID, AID.Invoice_Distribution_ID),
2003: LINE.Line_Type, TAA.New_Dist_ID) Distribution_Line_Number,