APPS.GME_MOVE_ORDERS_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 530: FROM mtl_txn_request_lines l, mtl_txn_request_headers h

526:
527: CURSOR cur_move_order_lines
528: IS
529: SELECT l.*
530: FROM mtl_txn_request_lines l, mtl_txn_request_headers h
531: WHERE l.organization_id = p_organization_id
532: AND transaction_source_type_id =
533: gme_common_pvt.g_txn_source_type
534: AND l.txn_source_id = p_batch_id

Line 605: FROM mtl_txn_request_lines

601:
602: CURSOR cur_move_order_lines (v_header_id NUMBER)
603: IS
604: SELECT COUNT (1)
605: FROM mtl_txn_request_lines
606: WHERE header_id = v_header_id;
607: BEGIN
608: IF g_debug <= gme_debug.g_log_procedure THEN
609: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 770: FROM mtl_txn_request_lines l, mtl_txn_request_headers h

766:
767: CURSOR cur_move_order_lines
768: IS
769: SELECT l.*
770: FROM mtl_txn_request_lines l, mtl_txn_request_headers h
771: WHERE transaction_source_type_id =
772: gme_common_pvt.g_txn_source_type
773: AND l.txn_source_id = p_batch_id
774: AND l.txn_source_line_id = p_material_detail_id

Line 782: TYPE line_tab IS TABLE OF mtl_txn_request_lines%ROWTYPE

778: (gme_common_pvt.g_invis_move_order_type
779: ,inv_globals.g_move_order_put_away)
780: ORDER BY l.creation_date DESC;
781:
782: TYPE line_tab IS TABLE OF mtl_txn_request_lines%ROWTYPE
783: INDEX BY BINARY_INTEGER;
784:
785: l_line_tbl line_tab;
786: process_mo_line_err EXCEPTION;

Line 962: FROM mtl_txn_request_lines l, mtl_txn_request_headers h

958:
959: CURSOR cur_move_order_lines
960: IS
961: SELECT 1
962: FROM mtl_txn_request_lines l, mtl_txn_request_headers h
963: WHERE l.txn_source_id = p_batch_id
964: AND l.txn_source_line_id = p_material_detail_id
965: AND l.organization_id = p_organization_id
966: AND l.line_status NOT IN (5, 6)