DBA Data[Home] [Help]

APPS.INV_PICK_RELEASE_PUB dependencies on MTL_TXN_REQUEST_HEADERS

Line 412: FROM mtl_txn_request_headers

408: IF l_get_header_rule = 1 THEN
409: BEGIN
410: SELECT grouping_rule_id,organization_id
411: INTO l_grouping_rule_id,l_organization_id
412: FROM mtl_txn_request_headers
413: WHERE header_id = p_move_order_header_id;
414: EXCEPTION
415: WHEN no_data_found THEN
416: ROLLBACK TO Assign_Pick_slip;

Line 480: FROM mtl_txn_request_headers

476:
477: /*Added for Bug # 6144354 */
478: SELECT request_number
479: INTO l_request_number
480: FROM mtl_txn_request_headers
481: WHERE header_id = p_move_order_header_id;
482: --AND organization_id = mmtt_line.organization_id; --bug 8829363
483:
484: IF (l_debug = 1) THEN

Line 599: FROM mtl_txn_request_headers

595:
596: BEGIN
597: SELECT request_number
598: INTO l_request_number
599: FROM mtl_txn_request_headers
600: WHERE header_id = p_move_order_header_id;
601: --AND organization_id = l_organization_id; Bug 8829363
602:
603: SELECT document_set_id