DBA Data[Home] [Help]

APPS.INV_LABEL dependencies on INV_CACHE

Line 4052: IF inv_cache.set_item_rec(l_organization_id, l_wlc_cur.inventory_item_id) THEN

4048: l_serial_controlled := 0;
4049: l_serial_status_enabled := 0;
4050: l_src_status := NULL;
4051: l_transaction_action_id := NULL;
4052: IF inv_cache.set_item_rec(l_organization_id, l_wlc_cur.inventory_item_id) THEN
4053: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
4054: l_serial_controlled := 1; -- Item is serial controlled
4055: END IF;
4056: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

Line 4053: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN

4049: l_serial_status_enabled := 0;
4050: l_src_status := NULL;
4051: l_transaction_action_id := NULL;
4052: IF inv_cache.set_item_rec(l_organization_id, l_wlc_cur.inventory_item_id) THEN
4053: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
4054: l_serial_controlled := 1; -- Item is serial controlled
4055: END IF;
4056: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
4057: l_serial_status_enabled := 1;

Line 4056: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

4052: IF inv_cache.set_item_rec(l_organization_id, l_wlc_cur.inventory_item_id) THEN
4053: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
4054: l_serial_controlled := 1; -- Item is serial controlled
4055: END IF;
4056: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
4057: l_serial_status_enabled := 1;
4058: END IF;
4059: END IF;
4060: FOR l_mmtt_cur in mmtt_cur(l_wlc_cur.inventory_item_id , l_wlc_cur.lot_number) loop