DBA Data[Home] [Help]

APPS.INV_LABEL dependencies on INV_CACHE

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

3949: l_serial_controlled := 0;
3950: l_serial_status_enabled := 0;
3951: l_src_status := NULL;
3952: l_transaction_action_id := NULL;
3953: IF inv_cache.set_item_rec(l_organization_id, l_wlc_cur.inventory_item_id) THEN
3954: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
3955: l_serial_controlled := 1; -- Item is serial controlled
3956: END IF;
3957: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

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

3950: l_serial_status_enabled := 0;
3951: l_src_status := NULL;
3952: l_transaction_action_id := NULL;
3953: IF inv_cache.set_item_rec(l_organization_id, l_wlc_cur.inventory_item_id) THEN
3954: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
3955: l_serial_controlled := 1; -- Item is serial controlled
3956: END IF;
3957: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
3958: l_serial_status_enabled := 1;

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

3953: IF inv_cache.set_item_rec(l_organization_id, l_wlc_cur.inventory_item_id) THEN
3954: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
3955: l_serial_controlled := 1; -- Item is serial controlled
3956: END IF;
3957: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
3958: l_serial_status_enabled := 1;
3959: END IF;
3960: END IF;
3961: FOR l_mmtt_cur in mmtt_cur(l_wlc_cur.inventory_item_id , l_wlc_cur.lot_number) loop