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 AP_HOLDS_ALL

Line 708: FROM ap_holds_all aha

704: AND rctla.interface_line_attribute6 = to_char(oola.line_id)
705: AND oola.top_model_line_id = p_order_line_id
706: AND nvl(aila.discarded_flag, 'N') <> 'Y'
707: AND NOT EXISTS (SELECT 'Unreleased holds exist'
708: FROM ap_holds_all aha
709: WHERE aha.invoice_id = aia.invoice_id
710: AND aha.release_lookup_code is null)
711: AND EXISTS (SELECT 'Invoice is approved'
712: FROM ap_invoice_distributions_all aida

Line 1120: FROM ap_holds_all aha

1116: AND NVL(aila.quantity_invoiced,0) < 0
1117: AND aia.cancelled_date IS NULL
1118: AND nvl(aila.discarded_flag, 'N') <> 'Y'
1119: AND NOT EXISTS (SELECT 'Unreleased holds exist'
1120: FROM ap_holds_all aha
1121: WHERE aha.invoice_id = aia.invoice_id
1122: AND aha.release_lookup_code is null)
1123: AND EXISTS (SELECT 'Invoice is approved'
1124: FROM ap_invoice_distributions_all aida

Line 1173: FROM ap_holds_all aha

1169: AND pha.po_header_id = p_movement_transaction.po_header_id
1170: AND pda.line_location_id = p_movement_transaction.po_line_location_id
1171: AND nvl(aila.discarded_flag, 'N') <> 'Y'
1172: AND NOT EXISTS (SELECT 'Unreleased holds exist'
1173: FROM ap_holds_all aha
1174: WHERE aha.invoice_id = aia.invoice_id
1175: AND aha.release_lookup_code is null)
1176: AND EXISTS (SELECT 'Invoice is approved'
1177: FROM ap_invoice_distributions_all aida

Line 2236: FROM ap_holds_all aha

2232: AND rctla.interface_line_attribute6 =
2233: to_char(l_movement_transaction.order_line_id)
2234: AND nvl(aila.discarded_flag, 'N') <> 'Y'
2235: AND NOT EXISTS (SELECT 'Unreleased holds exist'
2236: FROM ap_holds_all aha
2237: WHERE aha.invoice_id = aia.invoice_id
2238: AND aha.release_lookup_code is null)
2239: AND EXISTS (SELECT 'Invoice is approved'
2240: FROM ap_invoice_distributions_all aida

Line 2347: FROM ap_holds_all aha

2343: -- AND aida.invoice_line_number = aila.line_number
2344: -- AND NVL(aida.match_status_flag,'N') <> 'A');
2345: AND nvl(aila.discarded_flag, 'N') <> 'Y'
2346: AND NOT EXISTS (SELECT 'Unreleased holds exist'
2347: FROM ap_holds_all aha
2348: WHERE aha.invoice_id = aia.invoice_id
2349: AND aha.release_lookup_code is null)
2350: AND EXISTS (SELECT 'Invoice is approved'
2351: FROM ap_invoice_distributions_all aida

Line 2382: FROM ap_holds_all aha

2378: -- AND aida.invoice_line_number = aila.line_number
2379: -- AND NVL(aida.match_status_flag,'N') <> 'A');
2380: AND nvl(aila.discarded_flag, 'N') <> 'Y'
2381: AND NOT EXISTS (SELECT 'Unreleased holds exist'
2382: FROM ap_holds_all aha
2383: WHERE aha.invoice_id = aia.invoice_id
2384: AND aha.release_lookup_code is null)
2385: AND EXISTS (SELECT 'Invoice is approved'
2386: FROM ap_invoice_distributions_all aida

Line 2412: FROM ap_holds_all aha

2408: -- AND aida.invoice_line_number = aila.line_number
2409: -- AND NVL(aida.match_status_flag,'N') <> 'A');
2410: AND nvl(aila.discarded_flag, 'N') <> 'Y'
2411: AND NOT EXISTS (SELECT 'Unreleased holds exist'
2412: FROM ap_holds_all aha
2413: WHERE aha.invoice_id = aia.invoice_id
2414: AND aha.release_lookup_code is null)
2415: AND EXISTS (SELECT 'Invoice is approved'
2416: FROM ap_invoice_distributions_all aida

Line 2448: FROM ap_holds_all aha

2444: -- AND aida.invoice_line_number = aila.line_number
2445: -- AND NVL(aida.match_status_flag,'N') <> 'A');
2446: AND nvl(aila.discarded_flag, 'N') <> 'Y'
2447: AND NOT EXISTS (SELECT 'Unreleased holds exist'
2448: FROM ap_holds_all aha
2449: WHERE aha.invoice_id = aia.invoice_id
2450: AND aha.release_lookup_code is null)
2451: AND EXISTS (SELECT 'Invoice is approved'
2452: FROM ap_invoice_distributions_all aida

Line 2482: FROM ap_holds_all aha

2478: -- AND aida.invoice_line_number = aila.line_number
2479: -- AND NVL(aida.match_status_flag,'N') <> 'A');
2480: AND nvl(aila.discarded_flag, 'N') <> 'Y'
2481: AND NOT EXISTS (SELECT 'Unreleased holds exist'
2482: FROM ap_holds_all aha
2483: WHERE aha.invoice_id = aia.invoice_id
2484: AND aha.release_lookup_code is null)
2485: AND EXISTS (SELECT 'Invoice is approved'
2486: FROM ap_invoice_distributions_all aida

Line 2517: FROM ap_holds_all aha

2513: -- AND aida.invoice_line_number = aila.line_number
2514: -- AND NVL(aida.match_status_flag,'N') <> 'A');
2515: AND nvl(aila.discarded_flag, 'N') <> 'Y'
2516: AND NOT EXISTS (SELECT 'Unreleased holds exist'
2517: FROM ap_holds_all aha
2518: WHERE aha.invoice_id = aia.invoice_id
2519: AND aha.release_lookup_code is null)
2520: AND EXISTS (SELECT 'Invoice is approved'
2521: FROM ap_invoice_distributions_all aida

Line 2548: FROM ap_holds_all aha

2544: -- AND aida.invoice_line_number = aila.line_number
2545: -- AND NVL(aida.match_status_flag,'N') <> 'A');
2546: AND nvl(aila.discarded_flag, 'N') <> 'Y'
2547: AND NOT EXISTS (SELECT 'Unreleased holds exist'
2548: FROM ap_holds_all aha
2549: WHERE aha.invoice_id = aia.invoice_id
2550: AND aha.release_lookup_code is null)
2551: AND EXISTS (SELECT 'Invoice is approved'
2552: FROM ap_invoice_distributions_all aida

Line 2584: FROM ap_holds_all aha

2580: -- AND aida.invoice_line_number = aila.line_number
2581: -- AND NVL(aida.match_status_flag,'N') <> 'A');
2582: AND nvl(aila.discarded_flag, 'N') <> 'Y'
2583: AND NOT EXISTS (SELECT 'Unreleased holds exist'
2584: FROM ap_holds_all aha
2585: WHERE aha.invoice_id = aia.invoice_id
2586: AND aha.release_lookup_code is null)
2587: AND EXISTS (SELECT 'Invoice is approved'
2588: FROM ap_invoice_distributions_all aida