DBA Data[Home] [Help]

APPS.AP_LINES_UPGRADE_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 670: PO_Distributions_All POD, -- 9196221

666: NULL) Summary_Tax_Line_ID
667: FROM AP_Invoices_ALL AI,
668: AP_Inv_Dists_Source AID,
669: AP_Inv_Dists_Source AID1,
670: PO_Distributions_All POD, -- 9196221
671: ZX_Rates_B ZXR
672: WHERE AI.Invoice_ID = AID.Invoice_ID
673: AND AID.Parent_Reversal_ID = AID1.Invoice_Distribution_ID (+)
674: AND AID.Tax_Code_ID = ZXR.Source_ID (+)

Line 1516: PO_Distributions_All PD,

1512: FROM AP_System_Parameters_All ASP,
1513: AP_Invoices_All AI,
1514: AP_Dist_Line_GT AID,
1515: RCV_Transactions RCT, -- bug 6896361 added to get rcv_shipment_line_id from this table
1516: PO_Distributions_All PD,
1517: PO_Lines_All PL,
1518: AP_Inv_Dists_Source AID1,
1519: AP_Tax_Codes_All ATC,
1520: ZX_Rates_B ZXR

Line 1988: PO_Distributions_All POD --13444893

1984: FROM AP_Invoices_ALL AI,
1985: AP_Dist_Line_GT AID,
1986: AP_Tax_Alloc_Amount_GT ACA,
1987: AP_Line_Temp_GT Line,
1988: PO_Distributions_All POD --13444893
1989: WHERE AI.Invoice_ID = AID.Invoice_ID
1990: AND AID.Line_Type_Lookup_Code IN ('ITEM', 'PREPAY', 'AWT', 'ICMS',
1991: 'IPI', 'FREIGHT', 'MISCELLANEOUS')
1992: AND AID.PO_Distribution_ID = POD.PO_Distribution_ID (+) --13444893