DBA Data[Home] [Help]

APPS.AP_LINES_UPGRADE_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_S

Line 772: AP_Invoice_Distributions_S.Nextval) New_Dist_ID,

768: Charge_Allocation_ID,
769: NVL(Item_Charge_Alloc_ID, -99),
770: NVL(Item_Charge_Alloc_ID2, -99),
771: DECODE(Charge_Allocation_ID, NULL, Old_Dist_ID,
772: AP_Invoice_Distributions_S.Nextval) New_Dist_ID,
773: Old_Dist_ID,
774: Item_Dist_ID,
775: Allocated_Amount,
776: Allocated_Base_Amount,

Line 1757: AP_Invoice_Distributions_S.NEXTVAL

1753: AID.Invoice_ID Invoice_ID,
1754: AID.Line_Number Invoice_Line_Number,
1755: (CASE
1756: WHEN Line.Line_Type IN ('IPV','ERV') THEN
1757: AP_Invoice_Distributions_S.NEXTVAL
1758: ELSE DECODE(ACA.Charge_Allocation_ID, NULL, AID.Invoice_Distribution_ID,
1759: NVL(ACA.New_Dist_ID, AP_Invoice_Distributions_S.NEXTVAL))
1760: END) AS Invoice_Distribution_ID,
1761: -- AP_Dist_Line_Num_Upg_S.NEXTVAL Distribution_Line_Number,

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

1755: (CASE
1756: WHEN Line.Line_Type IN ('IPV','ERV') THEN
1757: AP_Invoice_Distributions_S.NEXTVAL
1758: ELSE DECODE(ACA.Charge_Allocation_ID, NULL, AID.Invoice_Distribution_ID,
1759: NVL(ACA.New_Dist_ID, AP_Invoice_Distributions_S.NEXTVAL))
1760: END) AS Invoice_Distribution_ID,
1761: -- AP_Dist_Line_Num_Upg_S.NEXTVAL Distribution_Line_Number,
1762: RANK() OVER (PARTITION BY AID.INVOICE_ID, AID.LINE_NUMBER
1763: ORDER BY NVL(ACA.Charge_Allocation_ID, AID.INVOICE_DISTRIBUTION_ID),

Line 2178: AP_INVOICE_DISTRIBUTIONS_S.NEXTVAL) Invoice_Distribution_ID,

2174: AID.Batch_ID Batch_ID,
2175: AID.Invoice_ID Invoice_ID,
2176: AID.Line_Number Invoice_Line_Number,
2177: DECODE(Line.Line_Type, 'TAX', TAA.New_Dist_ID,
2178: AP_INVOICE_DISTRIBUTIONS_S.NEXTVAL) Invoice_Distribution_ID,
2179: -- AP_DIST_LINE_NUM_UPG_S.NEXTVAL Distribution_Line_Number,
2180: RANK() OVER (PARTITION BY AID.INVOICE_ID, AID.LINE_NUMBER
2181: ORDER BY NVL(TAA.Charge_Allocation_ID, AID.Invoice_Distribution_ID),
2182: LINE.Line_Type, TAA.New_Dist_ID) Distribution_Line_Number,