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.

APPS.INV_MGD_MVT_FIN_MDTR dependencies on PO_DISTRIBUTIONS_ALL

Line 1170: --, PO_DISTRIBUTIONS_ALL c

1166: -- SUM(a.amount) --yawang
1167: --, SUM(quantity_invoiced)
1168: --FROM
1169: -- PO_HEADERS_ALL b
1170: --, PO_DISTRIBUTIONS_ALL c
1171: --, AP_INVOICES_ALL d
1172: --, AP_INVOICE_DISTRIBUTIONS_ALL a
1173: --WHERE b.po_header_id = c.po_header_id
1174: --AND d.invoice_id = a.invoice_id

Line 1191: , PO_DISTRIBUTIONS_ALL pda

1187: SUM(aila.amount) --yawang
1188: , SUM(aila.quantity_invoiced)
1189: FROM
1190: PO_HEADERS_ALL pha
1191: , PO_DISTRIBUTIONS_ALL pda
1192: , AP_INVOICES_ALL aia
1193: , AP_INVOICE_LINES_ALL aila
1194: WHERE pha.po_header_id = pda.po_header_id
1195: AND aia.invoice_id = aila.invoice_id

Line 2822: , PO_DISTRIBUTIONS_ALL c

2818: MAX(distribution_line_number)
2819: FROM
2820: AP_INVOICES_ALL b
2821: , AP_INVOICE_DISTRIBUTIONS_ALL a
2822: , PO_DISTRIBUTIONS_ALL c
2823: WHERE b.invoice_id = x_movement_transaction.invoice_id
2824: AND b.invoice_id = a.invoice_id
2825: AND c.po_distribution_id = a.po_distribution_id
2826: AND c.line_location_id = x_movement_transaction.po_line_location_id