DBA Data[Home] [Help]

APPS.INV_PICK_RELEASE_PUB dependencies on MTL_TXN_REQUEST_HEADERS

Line 407: FROM mtl_txn_request_headers

403: IF l_get_header_rule = 1 THEN
404: BEGIN
405: SELECT grouping_rule_id,organization_id
406: INTO l_grouping_rule_id,l_organization_id
407: FROM mtl_txn_request_headers
408: WHERE header_id = p_move_order_header_id;
409: EXCEPTION
410: WHEN no_data_found THEN
411: ROLLBACK TO Assign_Pick_slip;

Line 470: FROM mtl_txn_request_headers

466:
467: /*Added for Bug # 6144354 */
468: SELECT request_number
469: INTO l_request_number
470: FROM mtl_txn_request_headers
471: WHERE header_id = p_move_order_header_id
472: AND organization_id = mmtt_line.organization_id;
473:
474: IF (l_debug = 1) THEN

Line 589: FROM mtl_txn_request_headers

585:
586: BEGIN
587: SELECT request_number
588: INTO l_request_number
589: FROM mtl_txn_request_headers
590: WHERE header_id = p_move_order_header_id
591: AND organization_id = l_organization_id;
592:
593: SELECT document_set_id