eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AP_LINES_UPGRADE_PKG dependencies on AP_INV_DISTS_SOURCE

Line 158: UPDATE AP_Inv_Dists_Source AID

154: /* BUG 9080712 - In 11i for the reversed payment time AWT distirbutions,
155: the reversal flag populated as N. we need to correct the
156: value to Y. */
157:
158: UPDATE AP_Inv_Dists_Source AID
159: SET aid.reversal_flag = 'Y'
160: WHERE AID.line_type_lookup_code = 'AWT'
161: AND AID.parent_reversal_id IS NOT NULL
162: AND AID.awt_invoice_payment_id IS NOT NULL

Line 668: AP_Inv_Dists_Source AID,

664: ZX_Lines_Summary_S.Nextval)),
665: ZX_Lines_Summary_S.Nextval),
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

Line 669: AP_Inv_Dists_Source AID1,

665: ZX_Lines_Summary_S.Nextval),
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 (+)

Line 1518: AP_Inv_Dists_Source AID1,

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
1521: WHERE AI.Invoice_ID = AID.Invoice_ID
1522: AND NVL(AI.Org_ID,-99) = NVL(ASP.Org_ID,-99)

Line 2409: AP_Inv_Dists_Source AID,

2405: SUM(NVL(ACA.Allocated_Base_Amount,AID.Base_Amount)) Sum_Alloc_Base_Amount,
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

Line 2411: AP_Inv_Dists_Source AID1

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
2415: AND AID1.Line_Type_Lookup_Code = 'TAX'