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 685: AP_Invoice_Distributions_S.Nextval) New_Dist_ID,

681: Charge_Allocation_ID,
682: NVL(Item_Charge_Alloc_ID, -99),
683: NVL(Item_Charge_Alloc_ID2, -99),
684: DECODE(Charge_Allocation_ID, NULL, Old_Dist_ID,
685: AP_Invoice_Distributions_S.Nextval) New_Dist_ID,
686: Old_Dist_ID,
687: Item_Dist_ID,
688: Allocated_Amount,
689: Allocated_Base_Amount,

Line 1592: AP_Invoice_Distributions_S.NEXTVAL

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

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

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

Line 1997: AP_INVOICE_DISTRIBUTIONS_S.NEXTVAL) Invoice_Distribution_ID,

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