DBA Data[Home] [Help]

APPS.GME_MOVE_ORDERS_PVT dependencies on MTL_TXN_REQUEST_HEADERS

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