DBA Data[Home] [Help]

APPS.WIP_RESERVATIONS_GRP dependencies on INV_GLOBALS

Line 95: AND mtrl.line_status <> inv_globals.g_to_status_closed;

91: AND NVL(mtrl.quantity_delivered, 0) = 0
92: AND mtrl.txn_source_id = p_supply_demand_header_id
93: AND mtrl.lpn_id = wlpn.lpn_id
94: AND wlpn.lpn_context = 2 -- WIP
95: AND mtrl.line_status <> inv_globals.g_to_status_closed;
96:
97: x_available_quantity := x_available_quantity + l_crossDock_qty ;
98: ELSE -- If it is return Transaction
99: SELECT

Line 222: AND mtrl.line_status <> inv_globals.g_to_status_closed;

218: AND NVL(mtrl.quantity_delivered, 0) = 0
219: AND mtrl.txn_source_id = p_supply_demand_header_id
220: AND mtrl.lpn_id = wlpn.lpn_id
221: AND wlpn.lpn_context = 2 -- WIP
222: AND mtrl.line_status <> inv_globals.g_to_status_closed;
223: /*
224: l_available_qty := l_available_qty + l_crossDock_qty ;
225:
226: IF l_available_qty <=0 then