DBA Data[Home] [Help]

APPS.AP_LINES_UPGRADE_SYNC_PKG dependencies on AP_CHRG_ALLOCATIONS_ALL

Line 822: AP_Chrg_Allocations_All ACA,

818: END) As ERV_Amount,
819: AI.Invoice_Currency_Code Invoice_Currency_Code,
820: AI.Set_Of_Books_ID Set_Of_Books_ID
821: FROM AP_Invoices_All AI,
822: AP_Chrg_Allocations_All ACA,
823: AP_Dist_Line_GT AID,
824: AP_Chrg_Allocations_All ACA1,
825: AP_Dist_Line_GT AID1,
826: AP_Chrg_Allocations_All ACA2

Line 824: AP_Chrg_Allocations_All ACA1,

820: AI.Set_Of_Books_ID Set_Of_Books_ID
821: FROM AP_Invoices_All AI,
822: AP_Chrg_Allocations_All ACA,
823: AP_Dist_Line_GT AID,
824: AP_Chrg_Allocations_All ACA1,
825: AP_Dist_Line_GT AID1,
826: AP_Chrg_Allocations_All ACA2
827: WHERE AI.Invoice_ID = AID.Invoice_ID
828: -- AND AID.Line_Type_Lookup_Code IN ('FREIGHT', 'MISCELLANEOUS', 'TAX')

Line 826: AP_Chrg_Allocations_All ACA2

822: AP_Chrg_Allocations_All ACA,
823: AP_Dist_Line_GT AID,
824: AP_Chrg_Allocations_All ACA1,
825: AP_Dist_Line_GT AID1,
826: AP_Chrg_Allocations_All ACA2
827: WHERE AI.Invoice_ID = AID.Invoice_ID
828: -- AND AID.Line_Type_Lookup_Code IN ('FREIGHT', 'MISCELLANEOUS', 'TAX')
829: AND AID.Invoice_Distribution_ID = ACA.Charge_Dist_ID (+)
830: AND ACA.Item_Dist_ID = ACA1.Charge_Dist_ID (+)

Line 2237: AP_Chrg_Allocations_All ACA,

2233: AID.Tax_Recovery_Rate Rec_NRec_Rate,
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