APPS.AP_LINES_UPGRADE_SYNC_PKG dependencies on AP_INV_DISTS_SOURCE

Line 568: AP_Inv_Dists_Source AID,

564: DECODE(AID.Reversal_Flag, 'Y', NULL, ZX_Lines_Summary_S.Nextval)),
565: ZX_Lines_Summary_S.Nextval),
566: NULL) Summary_Tax_Line_ID
567: FROM AP_Invoices_ALL AI,
568: AP_Inv_Dists_Source AID,
569: AP_Inv_Dists_Source AID1,
570: ZX_Rates_B ZXR
571: WHERE AI.Invoice_ID IN (SELECT Distinct Invoice_ID
572: FROM AP_Lines_Upg_Sync_Data

Line 569: AP_Inv_Dists_Source AID1,

565: ZX_Lines_Summary_S.Nextval),
566: NULL) Summary_Tax_Line_ID
567: FROM AP_Invoices_ALL AI,
568: AP_Inv_Dists_Source AID,
569: AP_Inv_Dists_Source AID1,
570: ZX_Rates_B ZXR
571: WHERE AI.Invoice_ID IN (SELECT Distinct Invoice_ID
572: FROM AP_Lines_Upg_Sync_Data
573: WHERE Status = 'S')

Line 1371: AP_Inv_Dists_Source AID1,

1367: AP_Invoices_All AI,
1368: AP_Dist_Line_GT AID,
1369: PO_Distributions_All PD,
1370: PO_Lines_All PL,
1371: AP_Inv_Dists_Source AID1,
1372: AP_Tax_Codes_All ATC,
1373: ZX_Rates_B ZXR
1374: WHERE AI.Invoice_ID = AID.Invoice_ID
1375: AND NVL(AI.Org_ID,-99) = NVL(ASP.Org_ID,-99)

Line 2240: AP_Inv_Dists_Source AID1

2236: AID.Set_Of_Books_ID
2237: FROM AP_Invoices_All AI,
2238: AP_Dist_Line_GT AID,
2239: AP_Chrg_Allocations_All ACA,
2240: AP_Inv_Dists_Source AID1
2241: WHERE AI.Invoice_ID = AID.Invoice_ID
2242: AND AID.Invoice_Distribution_ID = ACA.Item_Dist_ID
2243: AND AID1.Invoice_Distribution_ID = ACA.Charge_Dist_ID
2244: AND AID1.Line_Type_Lookup_Code = 'TAX'