APPS.GME_MOVE_ORDERS_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 593: FROM mtl_txn_request_lines l, mtl_txn_request_headers h

589:
590: CURSOR cur_move_order_lines
591: IS
592: SELECT l.*
593: FROM mtl_txn_request_lines l, mtl_txn_request_headers h
594: WHERE l.organization_id = p_organization_id
595: AND transaction_source_type_id =
596: gme_common_pvt.g_txn_source_type
597: AND l.txn_source_id = p_batch_id

Line 668: FROM mtl_txn_request_lines

664:
665: CURSOR cur_move_order_lines (v_header_id NUMBER)
666: IS
667: SELECT COUNT (1)
668: FROM mtl_txn_request_lines
669: WHERE header_id = v_header_id;
670: BEGIN
671: IF g_debug <= gme_debug.g_log_procedure THEN
672: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 834: FROM mtl_txn_request_lines l, mtl_txn_request_headers h

830:
831: CURSOR cur_move_order_lines
832: IS
833: SELECT l.*
834: FROM mtl_txn_request_lines l, mtl_txn_request_headers h
835: WHERE transaction_source_type_id =
836: gme_common_pvt.g_txn_source_type
837: AND l.txn_source_id = p_batch_id
838: AND l.txn_source_line_id = p_material_detail_id

Line 846: TYPE line_tab IS TABLE OF mtl_txn_request_lines%ROWTYPE

842: (gme_common_pvt.g_invis_move_order_type
843: ,inv_globals.g_move_order_put_away)
844: ORDER BY l.creation_date DESC;
845:
846: TYPE line_tab IS TABLE OF mtl_txn_request_lines%ROWTYPE
847: INDEX BY BINARY_INTEGER;
848:
849: -- Bug 9028327 - Add cursor and local vars.
850: CURSOR cur_item_mst (v_org_id NUMBER, v_inventory_item_id NUMBER)

Line 1159: FROM mtl_txn_request_lines l, mtl_txn_request_headers h

1155:
1156: CURSOR cur_move_order_lines
1157: IS
1158: SELECT 1
1159: FROM mtl_txn_request_lines l, mtl_txn_request_headers h
1160: WHERE l.txn_source_id = p_batch_id
1161: AND l.txn_source_line_id = p_material_detail_id
1162: AND l.organization_id = p_organization_id
1163: AND l.line_status NOT IN (5, 6)