DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PUB dependencies on INV_GLOBALS

Line 2392: AND NOT (NVL(p_trx_action_id, -9999) = inv_globals.g_action_inv_lot_split)

2388: /* Validate Lot */
2389: /* Sub and locator might not be given in the case of pre-packing */
2390: IF (p_content_item_id IS NOT NULL) THEN
2391: IF (l_content_item.lot_control_code = 2
2392: AND NOT (NVL(p_trx_action_id, -9999) = inv_globals.g_action_inv_lot_split)
2393: AND NOT (NVL(p_trx_action_id, -9999) = inv_globals.g_action_inv_lot_merge)
2394: ) THEN
2395: IF (p_lot_number IS NOT NULL) THEN
2396: -- Do lot validation only if the container/item is in INV,

Line 2393: AND NOT (NVL(p_trx_action_id, -9999) = inv_globals.g_action_inv_lot_merge)

2389: /* Sub and locator might not be given in the case of pre-packing */
2390: IF (p_content_item_id IS NOT NULL) THEN
2391: IF (l_content_item.lot_control_code = 2
2392: AND NOT (NVL(p_trx_action_id, -9999) = inv_globals.g_action_inv_lot_split)
2393: AND NOT (NVL(p_trx_action_id, -9999) = inv_globals.g_action_inv_lot_merge)
2394: ) THEN
2395: IF (p_lot_number IS NOT NULL) THEN
2396: -- Do lot validation only if the container/item is in INV,
2397: -- not WIP or REC since dynamic lots are possible in WIP and REC.