APPS.AP_LINES_UPGRADE_PKG dependencies on AP_CHRG_ALLOCATIONS_ALL

Line 921: AP_Chrg_Allocations_All ACA,

917: AI.Set_Of_Books_ID Set_Of_Books_ID,
918: nvl(AID2.Parent_Reversal_ID, AID2.Invoice_Distribution_ID) org_item_id, --8608129
919: AID.parent_reversal_id parent_reversal_id --8608129
920: FROM AP_Invoices_All AI,
921: AP_Chrg_Allocations_All ACA,
922: AP_Dist_Line_GT AID,
923: AP_Chrg_Allocations_All ACA1,
924: AP_Dist_Line_GT AID1,
925: AP_Dist_Line_GT AID2 --8608129

Line 923: AP_Chrg_Allocations_All ACA1,

919: AID.parent_reversal_id parent_reversal_id --8608129
920: FROM AP_Invoices_All AI,
921: AP_Chrg_Allocations_All ACA,
922: AP_Dist_Line_GT AID,
923: AP_Chrg_Allocations_All ACA1,
924: AP_Dist_Line_GT AID1,
925: AP_Dist_Line_GT AID2 --8608129
926: -- AP_Chrg_Allocations_All ACA2
927: WHERE AI.Invoice_ID = AID.Invoice_ID

Line 926: -- AP_Chrg_Allocations_All ACA2

922: AP_Dist_Line_GT AID,
923: AP_Chrg_Allocations_All ACA1,
924: AP_Dist_Line_GT AID1,
925: AP_Dist_Line_GT AID2 --8608129
926: -- AP_Chrg_Allocations_All ACA2
927: WHERE AI.Invoice_ID = AID.Invoice_ID
928: -- AND AID.Line_Type_Lookup_Code IN ('FREIGHT', 'MISCELLANEOUS', 'TAX')
929: AND AID.Invoice_Distribution_ID = ACA.Charge_Dist_ID (+)
930: AND ACA.Item_Dist_ID = ACA1.Charge_Dist_ID (+)

Line 2410: AP_Chrg_Allocations_All ACA,

2406: AID.Tax_Recovery_Rate Rec_NRec_Rate,
2407: AID.Set_Of_Books_ID
2408: FROM AP_Invoices_All AI,
2409: AP_Inv_Dists_Source AID,
2410: AP_Chrg_Allocations_All ACA,
2411: AP_Inv_Dists_Source AID1
2412: WHERE AI.Invoice_ID = AID.Invoice_ID
2413: AND AID.Invoice_Distribution_ID = ACA.Item_Dist_ID
2414: AND AID1.Invoice_Distribution_ID = ACA.Charge_Dist_ID