DBA Data[Home] [Help]

APPS.AP_LINES_UPGRADE_PKG dependencies on AP_CHRG_ALLOCATIONS_ALL

Line 859: AP_Chrg_Allocations_All ACA,

855: END) As ERV_Amount,
856: AI.Invoice_Currency_Code Invoice_Currency_Code,
857: AI.Set_Of_Books_ID Set_Of_Books_ID
858: FROM AP_Invoices_All AI,
859: AP_Chrg_Allocations_All ACA,
860: AP_Dist_Line_GT AID,
861: AP_Chrg_Allocations_All ACA1,
862: AP_Dist_Line_GT AID1
863: -- AP_Chrg_Allocations_All ACA2

Line 861: AP_Chrg_Allocations_All ACA1,

857: AI.Set_Of_Books_ID Set_Of_Books_ID
858: FROM AP_Invoices_All AI,
859: AP_Chrg_Allocations_All ACA,
860: AP_Dist_Line_GT AID,
861: AP_Chrg_Allocations_All ACA1,
862: AP_Dist_Line_GT AID1
863: -- AP_Chrg_Allocations_All ACA2
864: WHERE AI.Invoice_ID = AID.Invoice_ID
865: -- AND AID.Line_Type_Lookup_Code IN ('FREIGHT', 'MISCELLANEOUS', 'TAX')

Line 863: -- AP_Chrg_Allocations_All ACA2

859: AP_Chrg_Allocations_All ACA,
860: AP_Dist_Line_GT AID,
861: AP_Chrg_Allocations_All ACA1,
862: AP_Dist_Line_GT AID1
863: -- AP_Chrg_Allocations_All ACA2
864: WHERE AI.Invoice_ID = AID.Invoice_ID
865: -- AND AID.Line_Type_Lookup_Code IN ('FREIGHT', 'MISCELLANEOUS', 'TAX')
866: AND AID.Invoice_Distribution_ID = ACA.Charge_Dist_ID (+)
867: AND ACA.Item_Dist_ID = ACA1.Charge_Dist_ID (+)

Line 2323: AP_Chrg_Allocations_All ACA,

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
2327: AND AID1.Invoice_Distribution_ID = ACA.Charge_Dist_ID