APPS.AP_LINES_UPGRADE_PKG dependencies on AP_INV_DISTS_SOURCE

Line 614: AP_Inv_Dists_Source AID,

610: ZX_Lines_Summary_S.Nextval)),
611: ZX_Lines_Summary_S.Nextval),
612: NULL) Summary_Tax_Line_ID
613: FROM AP_Invoices_ALL AI,
614: AP_Inv_Dists_Source AID,
615: AP_Inv_Dists_Source AID1,
616: ZX_Rates_B ZXR
617: WHERE AI.Invoice_ID = AID.Invoice_ID
618: AND AID.Parent_Reversal_ID = AID1.Invoice_Distribution_ID (+)

Line 615: AP_Inv_Dists_Source AID1,

611: ZX_Lines_Summary_S.Nextval),
612: NULL) Summary_Tax_Line_ID
613: FROM AP_Invoices_ALL AI,
614: AP_Inv_Dists_Source AID,
615: AP_Inv_Dists_Source AID1,
616: ZX_Rates_B ZXR
617: WHERE AI.Invoice_ID = AID.Invoice_ID
618: AND AID.Parent_Reversal_ID = AID1.Invoice_Distribution_ID (+)
619: AND AID.Tax_Code_ID = ZXR.Source_ID (+)

Line 1429: AP_Inv_Dists_Source AID1,

1425: AP_Dist_Line_GT AID,
1426: RCV_Transactions RCT, -- bug 6896361 added to get rcv_shipment_line_id from this table
1427: PO_Distributions_All PD,
1428: PO_Lines_All PL,
1429: AP_Inv_Dists_Source AID1,
1430: AP_Tax_Codes_All ATC,
1431: ZX_Rates_B ZXR
1432: WHERE AI.Invoice_ID = AID.Invoice_ID
1433: AND NVL(AI.Org_ID,-99) = NVL(ASP.Org_ID,-99)

Line 2322: AP_Inv_Dists_Source AID,

2318: SUM(NVL(ACA.Allocated_Base_Amount,AID.Base_Amount)) Sum_Alloc_Base_Amount,
2319: AID.Tax_Recovery_Rate Rec_NRec_Rate,
2320: AID.Set_Of_Books_ID
2321: FROM AP_Invoices_All AI,
2322: AP_Inv_Dists_Source AID,
2323: AP_Chrg_Allocations_All ACA,
2324: AP_Inv_Dists_Source AID1
2325: WHERE AI.Invoice_ID = AID.Invoice_ID
2326: AND AID.Invoice_Distribution_ID = ACA.Item_Dist_ID

Line 2324: AP_Inv_Dists_Source AID1

2320: AID.Set_Of_Books_ID
2321: FROM AP_Invoices_All AI,
2322: AP_Inv_Dists_Source AID,
2323: AP_Chrg_Allocations_All ACA,
2324: AP_Inv_Dists_Source AID1
2325: WHERE AI.Invoice_ID = AID.Invoice_ID
2326: AND AID.Invoice_Distribution_ID = ACA.Item_Dist_ID
2327: AND AID1.Invoice_Distribution_ID = ACA.Charge_Dist_ID
2328: AND AID1.Line_Type_Lookup_Code = 'TAX'