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 741: FROM ap_holds_all aha

737: AND rctla.interface_line_attribute6 = to_char(oola.line_id)
738: AND oola.top_model_line_id = p_order_line_id
739: AND nvl(aila.discarded_flag, 'N') <> 'Y'
740: AND NOT EXISTS (SELECT 'Unreleased holds exist'
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

Line 1153: FROM ap_holds_all aha

1149: AND NVL(aila.quantity_invoiced,0) < 0
1150: AND aia.cancelled_date IS NULL
1151: AND nvl(aila.discarded_flag, 'N') <> 'Y'
1152: AND NOT EXISTS (SELECT 'Unreleased holds exist'
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

Line 1206: FROM ap_holds_all aha

1202: AND pha.po_header_id = p_movement_transaction.po_header_id
1203: AND pda.line_location_id = p_movement_transaction.po_line_location_id
1204: AND nvl(aila.discarded_flag, 'N') <> 'Y'
1205: AND NOT EXISTS (SELECT 'Unreleased holds exist'
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

Line 2429: FROM ap_holds_all aha

2425: AND rctla.interface_line_attribute6 =
2426: to_char(l_movement_transaction.order_line_id)
2427: AND nvl(aila.discarded_flag, 'N') <> 'Y'
2428: AND NOT EXISTS (SELECT 'Unreleased holds exist'
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

Line 2466: FROM ap_holds_all aha

2462: AND rctla.interface_line_attribute6 =
2463: to_char(l_movement_transaction.order_line_id)
2464: AND nvl(aila.discarded_flag, 'N') <> 'Y'
2465: AND NOT EXISTS (SELECT 'Unreleased holds exist'
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

Line 2506: FROM ap_holds_all aha

2502: AND rctla.interface_line_attribute6 =
2503: to_char(l_movement_transaction.order_line_id)
2504: AND nvl(aila.discarded_flag, 'N') <> 'Y'
2505: AND NOT EXISTS (SELECT 'Unreleased holds exist'
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

Line 2541: FROM ap_holds_all aha

2537: AND rctla.interface_line_attribute6 =
2538: to_char(l_movement_transaction.order_line_id)
2539: AND nvl(aila.discarded_flag, 'N') <> 'Y'
2540: AND NOT EXISTS (SELECT 'Unreleased holds exist'
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

Line 2587: FROM ap_holds_all aha

2583: AND rctla.interface_line_attribute6 =
2584: to_char(l_movement_transaction.order_line_id)
2585: AND nvl(aila.discarded_flag, 'N') <> 'Y'
2586: AND NOT EXISTS (SELECT 'Unreleased holds exist'
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

Line 2789: FROM ap_holds_all aha

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'
2788: AND NOT EXISTS (SELECT 'Unreleased holds exist'
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

Line 2860: FROM ap_holds_all aha

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'
2859: AND NOT EXISTS (SELECT 'Unreleased holds exist'
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

Line 2890: FROM ap_holds_all aha

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'
2889: AND NOT EXISTS (SELECT 'Unreleased holds exist'
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

Line 2926: FROM ap_holds_all aha

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'
2925: AND NOT EXISTS (SELECT 'Unreleased holds exist'
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

Line 2960: FROM ap_holds_all aha

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'
2959: AND NOT EXISTS (SELECT 'Unreleased holds exist'
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

Line 2995: FROM ap_holds_all aha

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'
2994: AND NOT EXISTS (SELECT 'Unreleased holds exist'
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

Line 3026: FROM ap_holds_all aha

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'
3025: AND NOT EXISTS (SELECT 'Unreleased holds exist'
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

Line 3062: FROM ap_holds_all aha

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'
3061: AND NOT EXISTS (SELECT 'Unreleased holds exist'
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