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 745: FROM ap_invoice_distributions_all aida

741: FROM ap_holds_all aha
742: WHERE aha.invoice_id = aia.invoice_id
743: AND aha.release_lookup_code is null)
744: AND EXISTS (SELECT 'Invoice is approved'
745: FROM ap_invoice_distributions_all aida
746: WHERE aida.invoice_id = aia.invoice_id
747: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
748:
749: BEGIN

Line 1127: -- AP_INVOICE_DISTRIBUTIONS_ALL apid

1123: -- SUM(apid.amount)
1124: --, SUM(apid.quantity_invoiced)
1125: --FROM
1126: -- AP_INVOICES_ALL api,
1127: -- AP_INVOICE_DISTRIBUTIONS_ALL apid
1128: --WHERE api.invoice_id = apid.invoice_id
1129: --AND api.invoice_type_lookup_code in ('CREDIT','DEBIT')
1130: --AND apid.rcv_transaction_id = l_parent_transaction_id
1131: --AND apid.line_type_lookup_code = 'ITEM' --yawang, limit for good cost only

Line 1157: FROM ap_invoice_distributions_all aida

1153: FROM ap_holds_all aha
1154: WHERE aha.invoice_id = aia.invoice_id
1155: AND aha.release_lookup_code is null)
1156: AND EXISTS (SELECT 'Invoice is approved'
1157: FROM ap_invoice_distributions_all aida
1158: WHERE aida.invoice_id = aia.invoice_id
1159: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
1160:
1161: -- Cursor for RTV's where credit memo is to be associated with

Line 1172: --, AP_INVOICE_DISTRIBUTIONS_ALL a

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
1175: --AND c.po_distribution_id = a.po_distribution_id
1176: --AND (NVL(a.match_status_flag,'N') = 'A'

Line 1210: FROM ap_invoice_distributions_all aida

1206: FROM ap_holds_all aha
1207: WHERE aha.invoice_id = aia.invoice_id
1208: AND aha.release_lookup_code is null)
1209: AND EXISTS (SELECT 'Invoice is approved'
1210: FROM ap_invoice_distributions_all aida
1211: WHERE aida.invoice_id = aia.invoice_id
1212: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
1213:
1214: BEGIN

Line 1474: AP_INVOICE_DISTRIBUTIONS_ALL AID,MTL_UNITS_OF_MEASURE UOM

1470: CURSOR poinv_uom IS
1471: SELECT
1472: UOM.UOM_CODE
1473: FROM
1474: AP_INVOICE_DISTRIBUTIONS_ALL AID,MTL_UNITS_OF_MEASURE UOM
1475: WHERE AID.invoice_id = l_movement_transaction.invoice_id
1476: AND AID.distribution_line_number = l_movement_transaction.distribution_line_number
1477: AND AID.MATCHED_UOM_LOOKUP_CODE=UOM.UNIT_OF_MEASURE;
1478:

Line 2387: --, AP_INVOICE_DISTRIBUTIONS_ALL aida

2383: --, SUM(NVL(aida.amount,rctla.extended_amount))
2384: --, SUM(NVL(aida.quantity_invoiced,rctla.quantity_invoiced))
2385: --FROM
2386: -- AP_INVOICES_ALL aia
2387: --, AP_INVOICE_DISTRIBUTIONS_ALL aida
2388: --, RA_CUSTOMER_TRX_LINES_ALL rctla
2389: --, ra_customer_trx_all rcta
2390: --WHERE aia.invoice_id = aida.invoice_id
2391: -- AND (NVL(aida.match_status_flag,'N') = 'A'

Line 2433: FROM ap_invoice_distributions_all aida

2429: FROM ap_holds_all aha
2430: WHERE aha.invoice_id = aia.invoice_id
2431: AND aha.release_lookup_code is null)
2432: AND EXISTS (SELECT 'Invoice is approved'
2433: FROM ap_invoice_distributions_all aida
2434: WHERE aida.invoice_id = aia.invoice_id
2435: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
2436: */
2437:

Line 2470: FROM ap_invoice_distributions_all aida

2466: FROM ap_holds_all aha
2467: WHERE aha.invoice_id = aia.invoice_id
2468: AND aha.release_lookup_code is null)
2469: AND EXISTS (SELECT 'Invoice is approved'
2470: FROM ap_invoice_distributions_all aida
2471: WHERE aida.invoice_id = aia.invoice_id
2472: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'))
2473: AND aila.reference_2 = mmt.transaction_id
2474: AND mmt.transaction_id = rsl.mmt_transaction_id

Line 2510: FROM ap_invoice_distributions_all aida

2506: FROM ap_holds_all aha
2507: WHERE aha.invoice_id = aia.invoice_id
2508: AND aha.release_lookup_code is null)
2509: AND EXISTS (SELECT 'Invoice is approved'
2510: FROM ap_invoice_distributions_all aida
2511: WHERE aida.invoice_id = aia.invoice_id
2512: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'))
2513: AND aila.reference_2 = mmt.transaction_id
2514: AND mmt.picking_line_id = l_movement_transaction.picking_line_detail_id

Line 2545: FROM ap_invoice_distributions_all aida

2541: FROM ap_holds_all aha
2542: WHERE aha.invoice_id = aia.invoice_id
2543: AND aha.release_lookup_code is null)
2544: AND EXISTS (SELECT 'Invoice is approved'
2545: FROM ap_invoice_distributions_all aida
2546: WHERE aida.invoice_id = aia.invoice_id
2547: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'))
2548: AND aila.reference_2 in
2549: (SELECT mmt_logical.transaction_id

Line 2591: FROM ap_invoice_distributions_all aida

2587: FROM ap_holds_all aha
2588: WHERE aha.invoice_id = aia.invoice_id
2589: AND aha.release_lookup_code is null)
2590: AND EXISTS (SELECT 'Invoice is approved'
2591: FROM ap_invoice_distributions_all aida
2592: WHERE aida.invoice_id = aia.invoice_id
2593: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'))
2594: AND aila.reference_2 = mmt.transaction_id
2595: AND mmt.rcv_transaction_id = l_movement_transaction.rcv_transaction_id;

Line 2783: -- FROM ap_invoice_distributions_all aida

2779: AND aila.po_line_location_id = l_movement_transaction.po_line_location_id
2780: -- Bug 5655040. Commented as condition is modified and few more conditioned
2781: -- added to whereclause to check hold and disregard status.
2782: --AND NOT EXISTS (SELECT 1
2783: -- FROM ap_invoice_distributions_all aida
2784: -- WHERE aida.invoice_id = aia.invoice_id
2785: -- AND aida.invoice_line_number = aila.line_number
2786: -- AND NVL(aida.match_status_flag,'N') <> 'A');
2787: AND nvl(aila.discarded_flag, 'N') <> 'Y'

Line 2793: FROM ap_invoice_distributions_all aida

2789: FROM ap_holds_all aha
2790: WHERE aha.invoice_id = aia.invoice_id
2791: AND aha.release_lookup_code is null)
2792: AND EXISTS (SELECT 'Invoice is approved'
2793: FROM ap_invoice_distributions_all aida
2794: WHERE aida.invoice_id = aia.invoice_id
2795: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
2796:
2797: /*bug 8435322 Added new cursor to fetch max distribution_line_number for max Invoice Id*/

Line 2807: , AP_INVOICE_DISTRIBUTIONS_ALL a

2803: SELECT
2804: MAX(distribution_line_number)
2805: FROM
2806: AP_INVOICES_ALL b
2807: , AP_INVOICE_DISTRIBUTIONS_ALL a
2808: WHERE b.invoice_id = x_movement_transaction.invoice_id
2809: AND b.invoice_id = a.invoice_id
2810: AND (NVL(a.match_status_flag,'N') = 'A'
2811: OR (NVL(a.match_status_flag,'N') = 'T'

Line 2821: , AP_INVOICE_DISTRIBUTIONS_ALL a

2817: SELECT
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

Line 2854: -- FROM ap_invoice_distributions_all aida

2850: AND aila.po_line_location_id = l_movement_transaction.po_line_location_id
2851: -- Bug 5655040. Commented as condition is modified and few more conditioned
2852: -- added to whereclause to check hold and disregard status.
2853: --AND NOT EXISTS (SELECT 1
2854: -- FROM ap_invoice_distributions_all aida
2855: -- WHERE aida.invoice_id = aia.invoice_id
2856: -- AND aida.invoice_line_number = aila.line_number
2857: -- AND NVL(aida.match_status_flag,'N') <> 'A');
2858: AND nvl(aila.discarded_flag, 'N') <> 'Y'

Line 2864: FROM ap_invoice_distributions_all aida

2860: FROM ap_holds_all aha
2861: WHERE aha.invoice_id = aia.invoice_id
2862: AND aha.release_lookup_code is null)
2863: AND EXISTS (SELECT 'Invoice is approved'
2864: FROM ap_invoice_distributions_all aida
2865: WHERE aida.invoice_id = aia.invoice_id
2866: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
2867: -- Cursor for quantity correction in case of PO based matching.
2868: -- Modified for AP invoice lines uptake in R12

Line 2884: -- FROM ap_invoice_distributions_all aida

2880: AND aila.po_line_location_id = l_movement_transaction.po_line_location_id
2881: -- Bug 5655040. Commented as condition is modified and few more conditioned
2882: -- added to whereclause to check hold and disregard status.
2883: --AND NOT EXISTS (SELECT 1
2884: -- FROM ap_invoice_distributions_all aida
2885: -- WHERE aida.invoice_id = aia.invoice_id
2886: -- AND aida.invoice_line_number = aila.line_number
2887: -- AND NVL(aida.match_status_flag,'N') <> 'A');
2888: AND nvl(aila.discarded_flag, 'N') <> 'Y'

Line 2894: FROM ap_invoice_distributions_all aida

2890: FROM ap_holds_all aha
2891: WHERE aha.invoice_id = aia.invoice_id
2892: AND aha.release_lookup_code is null)
2893: AND EXISTS (SELECT 'Invoice is approved'
2894: FROM ap_invoice_distributions_all aida
2895: WHERE aida.invoice_id = aia.invoice_id
2896: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
2897:
2898: -- Cursor for RTV's where credit memo is to be associated with

Line 2920: -- FROM ap_invoice_distributions_all aida

2916: AND aila.po_line_location_id = l_movement_transaction.po_line_location_id
2917: -- Bug 5655040. Commented as condition is modified and few more conditioned
2918: -- added to whereclause to check hold and disregard status.
2919: --AND NOT EXISTS (SELECT 1
2920: -- FROM ap_invoice_distributions_all aida
2921: -- WHERE aida.invoice_id = aia.invoice_id
2922: -- AND aida.invoice_line_number = aila.line_number
2923: -- AND NVL(aida.match_status_flag,'N') <> 'A');
2924: AND nvl(aila.discarded_flag, 'N') <> 'Y'

Line 2930: FROM ap_invoice_distributions_all aida

2926: FROM ap_holds_all aha
2927: WHERE aha.invoice_id = aia.invoice_id
2928: AND aha.release_lookup_code is null)
2929: AND EXISTS (SELECT 'Invoice is approved'
2930: FROM ap_invoice_distributions_all aida
2931: WHERE aida.invoice_id = aia.invoice_id
2932: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
2933:
2934: -- Cursor for Receipt based matching regular invoice

Line 2954: -- FROM ap_invoice_distributions_all aida

2950: AND aila.rcv_transaction_id = l_movement_transaction.rcv_transaction_id
2951: -- Bug 5655040. Commented as condition is modified and few more conditioned
2952: -- added to whereclause to check hold and disregard status.
2953: --AND NOT EXISTS (SELECT 1
2954: -- FROM ap_invoice_distributions_all aida
2955: -- WHERE aida.invoice_id = aia.invoice_id
2956: -- AND aida.invoice_line_number = aila.line_number
2957: -- AND NVL(aida.match_status_flag,'N') <> 'A');
2958: AND nvl(aila.discarded_flag, 'N') <> 'Y'

Line 2964: FROM ap_invoice_distributions_all aida

2960: FROM ap_holds_all aha
2961: WHERE aha.invoice_id = aia.invoice_id
2962: AND aha.release_lookup_code is null)
2963: AND EXISTS (SELECT 'Invoice is approved'
2964: FROM ap_invoice_distributions_all aida
2965: WHERE aida.invoice_id = aia.invoice_id
2966: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
2967:
2968: -- Cursor for price correction in case of Receipt based matching.

Line 2989: -- FROM ap_invoice_distributions_all aida

2985: AND aila.rcv_transaction_id = l_movement_transaction.rcv_transaction_id
2986: -- Bug 5655040. Commented as condition is modified and few more conditioned
2987: -- added to whereclause to check hold and disregard status.
2988: --AND NOT EXISTS (SELECT 1
2989: -- FROM ap_invoice_distributions_all aida
2990: -- WHERE aida.invoice_id = aia.invoice_id
2991: -- AND aida.invoice_line_number = aila.line_number
2992: -- AND NVL(aida.match_status_flag,'N') <> 'A');
2993: AND nvl(aila.discarded_flag, 'N') <> 'Y'

Line 2999: FROM ap_invoice_distributions_all aida

2995: FROM ap_holds_all aha
2996: WHERE aha.invoice_id = aia.invoice_id
2997: AND aha.release_lookup_code is null)
2998: AND EXISTS (SELECT 'Invoice is approved'
2999: FROM ap_invoice_distributions_all aida
3000: WHERE aida.invoice_id = aia.invoice_id
3001: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
3002:
3003: -- Cursor for quantity correction in case of Receipt based matching.

Line 3020: -- FROM ap_invoice_distributions_all aida

3016: AND aila.rcv_transaction_id = l_movement_transaction.rcv_transaction_id
3017: -- Bug 5655040. Commented as condition is modified and few more conditioned
3018: -- added to whereclause to check hold and disregard status.
3019: --AND NOT EXISTS (SELECT 1
3020: -- FROM ap_invoice_distributions_all aida
3021: -- WHERE aida.invoice_id = aia.invoice_id
3022: -- AND aida.invoice_line_number = aila.line_number
3023: -- AND NVL(aida.match_status_flag,'N') <> 'A');
3024: AND nvl(aila.discarded_flag, 'N') <> 'Y'

Line 3030: FROM ap_invoice_distributions_all aida

3026: FROM ap_holds_all aha
3027: WHERE aha.invoice_id = aia.invoice_id
3028: AND aha.release_lookup_code is null)
3029: AND EXISTS (SELECT 'Invoice is approved'
3030: FROM ap_invoice_distributions_all aida
3031: WHERE aida.invoice_id = aia.invoice_id
3032: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
3033:
3034: -- Cursor for Credit memos that is associated with RTV transaction

Line 3056: -- FROM ap_invoice_distributions_all aida

3052: AND aila.rcv_transaction_id = l_parent_transaction_id
3053: -- Bug 5655040. Commented as condition is modified and few more conditioned
3054: -- added to whereclause to check hold and disregard status.
3055: --AND NOT EXISTS (SELECT 1
3056: -- FROM ap_invoice_distributions_all aida
3057: -- WHERE aida.invoice_id = aia.invoice_id
3058: -- AND aida.invoice_line_number = aila.line_number
3059: -- AND NVL(aida.match_status_flag,'N') <> 'A');
3060: AND nvl(aila.discarded_flag, 'N') <> 'Y'

Line 3066: FROM ap_invoice_distributions_all aida

3062: FROM ap_holds_all aha
3063: WHERE aha.invoice_id = aia.invoice_id
3064: AND aha.release_lookup_code is null)
3065: AND EXISTS (SELECT 'Invoice is approved'
3066: FROM ap_invoice_distributions_all aida
3067: WHERE aida.invoice_id = aia.invoice_id
3068: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'));
3069:
3070: --Cursor to check if this SO is for CTO items