DBA Data[Home] [Help]

APPS.AP_LINES_UPGRADE_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_S

Line 714: AP_Invoice_Distributions_S.Nextval) New_Dist_ID,

710: Charge_Allocation_ID,
711: NVL(Item_Charge_Alloc_ID, -99),
712: NVL(Item_Charge_Alloc_ID2, -99),
713: DECODE(Charge_Allocation_ID, NULL, Old_Dist_ID,
714: AP_Invoice_Distributions_S.Nextval) New_Dist_ID,
715: Old_Dist_ID,
716: Item_Dist_ID,
717: Allocated_Amount,
718: Allocated_Base_Amount,

Line 1667: AP_Invoice_Distributions_S.NEXTVAL

1663: AID.Invoice_ID Invoice_ID,
1664: AID.Line_Number Invoice_Line_Number,
1665: (CASE
1666: WHEN Line.Line_Type IN ('IPV','ERV') THEN
1667: AP_Invoice_Distributions_S.NEXTVAL
1668: ELSE DECODE(ACA.Charge_Allocation_ID, NULL, AID.Invoice_Distribution_ID,
1669: NVL(ACA.New_Dist_ID, AP_Invoice_Distributions_S.NEXTVAL))
1670: END) AS Invoice_Distribution_ID,
1671: -- AP_Dist_Line_Num_Upg_S.NEXTVAL Distribution_Line_Number,

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

1665: (CASE
1666: WHEN Line.Line_Type IN ('IPV','ERV') THEN
1667: AP_Invoice_Distributions_S.NEXTVAL
1668: ELSE DECODE(ACA.Charge_Allocation_ID, NULL, AID.Invoice_Distribution_ID,
1669: NVL(ACA.New_Dist_ID, AP_Invoice_Distributions_S.NEXTVAL))
1670: END) AS Invoice_Distribution_ID,
1671: -- AP_Dist_Line_Num_Upg_S.NEXTVAL Distribution_Line_Number,
1672: RANK() OVER (PARTITION BY AID.INVOICE_ID, AID.LINE_NUMBER
1673: ORDER BY NVL(ACA.Charge_Allocation_ID, AID.INVOICE_DISTRIBUTION_ID),

Line 2074: AP_INVOICE_DISTRIBUTIONS_S.NEXTVAL) Invoice_Distribution_ID,

2070: AID.Batch_ID Batch_ID,
2071: AID.Invoice_ID Invoice_ID,
2072: AID.Line_Number Invoice_Line_Number,
2073: DECODE(Line.Line_Type, 'TAX', TAA.New_Dist_ID,
2074: AP_INVOICE_DISTRIBUTIONS_S.NEXTVAL) Invoice_Distribution_ID,
2075: -- AP_DIST_LINE_NUM_UPG_S.NEXTVAL Distribution_Line_Number,
2076: RANK() OVER (PARTITION BY AID.INVOICE_ID, AID.LINE_NUMBER
2077: ORDER BY NVL(TAA.Charge_Allocation_ID, AID.Invoice_Distribution_ID),
2078: LINE.Line_Type, TAA.New_Dist_ID) Distribution_Line_Number,