DBA Data[Home] [Help]

APPS.WMS_PARAMETER_PVT dependencies on INV_GLOBALS

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

6105: AND mtrl.line_id = mmtt.move_order_line_id
6106: AND mtrh.header_id = mtrl.header_id;
6107:
6108: -- Bug 2666620: BackFlush MO Type Removed
6109: IF (l_hdr_type = inv_globals.g_move_order_mfg_pick) THEN
6110: RETURN 'Y';
6111: ELSE
6112: RETURN 'N';
6113: END IF;

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

6121: FROM DUAL
6122: WHERE EXISTS( SELECT transaction_temp_id
6123: FROM mtl_material_transactions_temp
6124: WHERE transaction_temp_id = p_transaction_temp_id
6125: AND transaction_type_id IN (inv_globals.g_type_xfer_order_wip_issue, inv_globals.g_type_xfer_order_repl_subxfr));
6126:
6127: RETURN l_ret;
6128: EXCEPTION
6129: WHEN OTHERS THEN

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

6139: FROM mtl_txn_request_headers mtrh
6140: WHERE mtrh.header_id = p_header_id;
6141:
6142: -- Bug 2666620: BackFlush MO Type Removed
6143: IF (l_hdr_type = inv_globals.g_move_order_mfg_pick) THEN
6144: RETURN 'Y';
6145: ELSE
6146: RETURN 'N';
6147: END IF;