DBA Data[Home] [Help]

APPS.WMS_PARAMETER_PVT dependencies on INV_GLOBALS

Line 6123: IF (l_hdr_type = inv_globals.g_move_order_mfg_pick) THEN

6119: AND mtrl.line_id = mmtt.move_order_line_id
6120: AND mtrh.header_id = mtrl.header_id;
6121:
6122: -- Bug 2666620: BackFlush MO Type Removed
6123: IF (l_hdr_type = inv_globals.g_move_order_mfg_pick) THEN
6124: RETURN 'Y';
6125: ELSE
6126: RETURN 'N';
6127: END IF;

Line 6139: AND transaction_type_id IN (inv_globals.g_type_xfer_order_wip_issue, inv_globals.g_type_xfer_order_repl_subxfr));

6135: FROM DUAL
6136: WHERE EXISTS( SELECT transaction_temp_id
6137: FROM mtl_material_transactions_temp
6138: WHERE transaction_temp_id = p_transaction_temp_id
6139: AND transaction_type_id IN (inv_globals.g_type_xfer_order_wip_issue, inv_globals.g_type_xfer_order_repl_subxfr));
6140:
6141: RETURN l_ret;
6142: EXCEPTION
6143: WHEN OTHERS THEN

Line 6157: IF (l_hdr_type = inv_globals.g_move_order_mfg_pick) THEN

6153: FROM mtl_txn_request_headers mtrh
6154: WHERE mtrh.header_id = p_header_id;
6155:
6156: -- Bug 2666620: BackFlush MO Type Removed
6157: IF (l_hdr_type = inv_globals.g_move_order_mfg_pick) THEN
6158: RETURN 'Y';
6159: ELSE
6160: RETURN 'N';
6161: END IF;