APPS.GME_MOVE_ORDERS_PVT dependencies on MTL_TXN_REQUEST_HEADERS

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 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 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)