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_INVOICE_DISTRIBUTIONS_ALL

Line 712: FROM ap_invoice_distributions_all aida

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
713: WHERE aida.invoice_id = aia.invoice_id
714: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
715:
716: BEGIN

Line 1094: -- AP_INVOICE_DISTRIBUTIONS_ALL apid

1090: -- SUM(apid.amount)
1091: --, SUM(apid.quantity_invoiced)
1092: --FROM
1093: -- AP_INVOICES_ALL api,
1094: -- AP_INVOICE_DISTRIBUTIONS_ALL apid
1095: --WHERE api.invoice_id = apid.invoice_id
1096: --AND api.invoice_type_lookup_code in ('CREDIT','DEBIT')
1097: --AND apid.rcv_transaction_id = l_parent_transaction_id
1098: --AND apid.line_type_lookup_code = 'ITEM' --yawang, limit for good cost only

Line 1124: FROM ap_invoice_distributions_all aida

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
1125: WHERE aida.invoice_id = aia.invoice_id
1126: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
1127:
1128: -- Cursor for RTV's where credit memo is to be associated with

Line 1139: --, AP_INVOICE_DISTRIBUTIONS_ALL a

1135: --FROM
1136: -- PO_HEADERS_ALL b
1137: --, PO_DISTRIBUTIONS_ALL c
1138: --, AP_INVOICES_ALL d
1139: --, AP_INVOICE_DISTRIBUTIONS_ALL a
1140: --WHERE b.po_header_id = c.po_header_id
1141: --AND d.invoice_id = a.invoice_id
1142: --AND c.po_distribution_id = a.po_distribution_id
1143: --AND (NVL(a.match_status_flag,'N') = 'A'

Line 1177: FROM ap_invoice_distributions_all aida

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
1178: WHERE aida.invoice_id = aia.invoice_id
1179: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
1180:
1181: BEGIN

Line 1441: AP_INVOICE_DISTRIBUTIONS_ALL AID,MTL_UNITS_OF_MEASURE UOM

1437: CURSOR poinv_uom IS
1438: SELECT
1439: UOM.UOM_CODE
1440: FROM
1441: AP_INVOICE_DISTRIBUTIONS_ALL AID,MTL_UNITS_OF_MEASURE UOM
1442: WHERE AID.invoice_id = l_movement_transaction.invoice_id
1443: AND AID.distribution_line_number = l_movement_transaction.distribution_line_number
1444: AND AID.MATCHED_UOM_LOOKUP_CODE=UOM.UNIT_OF_MEASURE;
1445:

Line 2196: --, AP_INVOICE_DISTRIBUTIONS_ALL aida

2192: --, SUM(NVL(aida.amount,rctla.extended_amount))
2193: --, SUM(NVL(aida.quantity_invoiced,rctla.quantity_invoiced))
2194: --FROM
2195: -- AP_INVOICES_ALL aia
2196: --, AP_INVOICE_DISTRIBUTIONS_ALL aida
2197: --, RA_CUSTOMER_TRX_LINES_ALL rctla
2198: --, ra_customer_trx_all rcta
2199: --WHERE aia.invoice_id = aida.invoice_id
2200: -- AND (NVL(aida.match_status_flag,'N') = 'A'

Line 2240: FROM ap_invoice_distributions_all aida

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
2241: WHERE aida.invoice_id = aia.invoice_id
2242: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
2243:
2244: CURSOR l_ap_intercompany_invoiced_qty IS

Line 2341: -- FROM ap_invoice_distributions_all aida

2337: AND aila.po_line_location_id = l_movement_transaction.po_line_location_id
2338: -- Bug 5655040. Commented as condition is modified and few more conditioned
2339: -- added to whereclause to check hold and disregard status.
2340: --AND NOT EXISTS (SELECT 1
2341: -- FROM ap_invoice_distributions_all aida
2342: -- WHERE aida.invoice_id = aia.invoice_id
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'

Line 2351: FROM ap_invoice_distributions_all aida

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
2352: WHERE aida.invoice_id = aia.invoice_id
2353: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
2354:
2355: -- Cursor for price correction in case of PO based matching.

Line 2376: -- FROM ap_invoice_distributions_all aida

2372: AND aila.po_line_location_id = l_movement_transaction.po_line_location_id
2373: -- Bug 5655040. Commented as condition is modified and few more conditioned
2374: -- added to whereclause to check hold and disregard status.
2375: --AND NOT EXISTS (SELECT 1
2376: -- FROM ap_invoice_distributions_all aida
2377: -- WHERE aida.invoice_id = aia.invoice_id
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'

Line 2386: FROM ap_invoice_distributions_all aida

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
2387: WHERE aida.invoice_id = aia.invoice_id
2388: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
2389: -- Cursor for quantity correction in case of PO based matching.
2390: -- Modified for AP invoice lines uptake in R12

Line 2406: -- FROM ap_invoice_distributions_all aida

2402: AND aila.po_line_location_id = l_movement_transaction.po_line_location_id
2403: -- Bug 5655040. Commented as condition is modified and few more conditioned
2404: -- added to whereclause to check hold and disregard status.
2405: --AND NOT EXISTS (SELECT 1
2406: -- FROM ap_invoice_distributions_all aida
2407: -- WHERE aida.invoice_id = aia.invoice_id
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'

Line 2416: FROM ap_invoice_distributions_all aida

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
2417: WHERE aida.invoice_id = aia.invoice_id
2418: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
2419:
2420: -- Cursor for RTV's where credit memo is to be associated with

Line 2442: -- FROM ap_invoice_distributions_all aida

2438: AND aila.po_line_location_id = l_movement_transaction.po_line_location_id
2439: -- Bug 5655040. Commented as condition is modified and few more conditioned
2440: -- added to whereclause to check hold and disregard status.
2441: --AND NOT EXISTS (SELECT 1
2442: -- FROM ap_invoice_distributions_all aida
2443: -- WHERE aida.invoice_id = aia.invoice_id
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'

Line 2452: FROM ap_invoice_distributions_all aida

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
2453: WHERE aida.invoice_id = aia.invoice_id
2454: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
2455:
2456: -- Cursor for Receipt based matching regular invoice

Line 2476: -- FROM ap_invoice_distributions_all aida

2472: AND aila.rcv_transaction_id = l_movement_transaction.rcv_transaction_id
2473: -- Bug 5655040. Commented as condition is modified and few more conditioned
2474: -- added to whereclause to check hold and disregard status.
2475: --AND NOT EXISTS (SELECT 1
2476: -- FROM ap_invoice_distributions_all aida
2477: -- WHERE aida.invoice_id = aia.invoice_id
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'

Line 2486: FROM ap_invoice_distributions_all aida

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
2487: WHERE aida.invoice_id = aia.invoice_id
2488: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
2489:
2490: -- Cursor for price correction in case of Receipt based matching.

Line 2511: -- FROM ap_invoice_distributions_all aida

2507: AND aila.rcv_transaction_id = l_movement_transaction.rcv_transaction_id
2508: -- Bug 5655040. Commented as condition is modified and few more conditioned
2509: -- added to whereclause to check hold and disregard status.
2510: --AND NOT EXISTS (SELECT 1
2511: -- FROM ap_invoice_distributions_all aida
2512: -- WHERE aida.invoice_id = aia.invoice_id
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'

Line 2521: FROM ap_invoice_distributions_all aida

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
2522: WHERE aida.invoice_id = aia.invoice_id
2523: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
2524:
2525: -- Cursor for quantity correction in case of Receipt based matching.

Line 2542: -- FROM ap_invoice_distributions_all aida

2538: AND aila.rcv_transaction_id = l_movement_transaction.rcv_transaction_id
2539: -- Bug 5655040. Commented as condition is modified and few more conditioned
2540: -- added to whereclause to check hold and disregard status.
2541: --AND NOT EXISTS (SELECT 1
2542: -- FROM ap_invoice_distributions_all aida
2543: -- WHERE aida.invoice_id = aia.invoice_id
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'

Line 2552: FROM ap_invoice_distributions_all aida

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
2553: WHERE aida.invoice_id = aia.invoice_id
2554: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
2555:
2556: -- Cursor for Credit memos that is associated with RTV transaction

Line 2578: -- FROM ap_invoice_distributions_all aida

2574: AND aila.rcv_transaction_id = l_parent_transaction_id
2575: -- Bug 5655040. Commented as condition is modified and few more conditioned
2576: -- added to whereclause to check hold and disregard status.
2577: --AND NOT EXISTS (SELECT 1
2578: -- FROM ap_invoice_distributions_all aida
2579: -- WHERE aida.invoice_id = aia.invoice_id
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'

Line 2588: FROM ap_invoice_distributions_all aida

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
2589: WHERE aida.invoice_id = aia.invoice_id
2590: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
2591:
2592: --Cursor to check if this SO is for CTO items