DBA Data[Home] [Help]

APPS.AP_LINES_UPGRADE_SYNC_PKG dependencies on AP_CHRG_ALLOCATIONS_ALL

Line 801: AP_Chrg_Allocations_All ACA,

797: END) As ERV_Amount,
798: AI.Invoice_Currency_Code Invoice_Currency_Code,
799: AI.Set_Of_Books_ID Set_Of_Books_ID
800: FROM AP_Invoices_All AI,
801: AP_Chrg_Allocations_All ACA,
802: AP_Dist_Line_GT AID,
803: AP_Chrg_Allocations_All ACA1,
804: AP_Dist_Line_GT AID1,
805: AP_Chrg_Allocations_All ACA2

Line 803: AP_Chrg_Allocations_All ACA1,

799: AI.Set_Of_Books_ID Set_Of_Books_ID
800: FROM AP_Invoices_All AI,
801: AP_Chrg_Allocations_All ACA,
802: AP_Dist_Line_GT AID,
803: AP_Chrg_Allocations_All ACA1,
804: AP_Dist_Line_GT AID1,
805: AP_Chrg_Allocations_All ACA2
806: WHERE AI.Invoice_ID = AID.Invoice_ID
807: -- AND AID.Line_Type_Lookup_Code IN ('FREIGHT', 'MISCELLANEOUS', 'TAX')

Line 805: AP_Chrg_Allocations_All ACA2

801: AP_Chrg_Allocations_All ACA,
802: AP_Dist_Line_GT AID,
803: AP_Chrg_Allocations_All ACA1,
804: AP_Dist_Line_GT AID1,
805: AP_Chrg_Allocations_All ACA2
806: WHERE AI.Invoice_ID = AID.Invoice_ID
807: -- AND AID.Line_Type_Lookup_Code IN ('FREIGHT', 'MISCELLANEOUS', 'TAX')
808: AND AID.Invoice_Distribution_ID = ACA.Charge_Dist_ID (+)
809: AND ACA.Item_Dist_ID = ACA1.Charge_Dist_ID (+)

Line 2239: AP_Chrg_Allocations_All ACA,

2235: AID.Tax_Recovery_Rate Rec_NRec_Rate,
2236: AID.Set_Of_Books_ID
2237: FROM AP_Invoices_All AI,
2238: AP_Dist_Line_GT AID,
2239: AP_Chrg_Allocations_All ACA,
2240: AP_Inv_Dists_Source AID1
2241: WHERE AI.Invoice_ID = AID.Invoice_ID
2242: AND AID.Invoice_Distribution_ID = ACA.Item_Dist_ID
2243: AND AID1.Invoice_Distribution_ID = ACA.Charge_Dist_ID