DBA Data[Home] [Help]

APPS.AP_LINES_UPGRADE_SYNC_PKG dependencies on AP_INV_DISTS_SOURCE

Line 589: AP_Inv_Dists_Source AID,

585: DECODE(AID.Reversal_Flag, 'Y', NULL, ZX_Lines_Summary_S.Nextval)),
586: ZX_Lines_Summary_S.Nextval),
587: NULL) Summary_Tax_Line_ID
588: FROM AP_Invoices_ALL AI,
589: AP_Inv_Dists_Source AID,
590: AP_Inv_Dists_Source AID1,
591: ZX_Rates_B ZXR
592: WHERE AI.Invoice_ID IN (SELECT Distinct Invoice_ID
593: FROM AP_Lines_Upg_Sync_Data

Line 590: AP_Inv_Dists_Source AID1,

586: ZX_Lines_Summary_S.Nextval),
587: NULL) Summary_Tax_Line_ID
588: FROM AP_Invoices_ALL AI,
589: AP_Inv_Dists_Source AID,
590: AP_Inv_Dists_Source AID1,
591: ZX_Rates_B ZXR
592: WHERE AI.Invoice_ID IN (SELECT Distinct Invoice_ID
593: FROM AP_Lines_Upg_Sync_Data
594: WHERE Status = 'S')

Line 1369: AP_Inv_Dists_Source AID1,

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

Line 2238: AP_Inv_Dists_Source AID1

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