eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_DELIVERY_DETAILS_INV dependencies on MTL_SYSTEM_ITEMS

Line 20: RESTRICT_LOCATORS_CODE MTL_SYSTEM_ITEMS.RESTRICT_LOCATORS_CODE%TYPE,

16: LOC_CONTROL_FLAG VARCHAR2(3),
17: LOT_CONTROL_FLAG VARCHAR2(3),
18: REV_CONTROL_FLAG VARCHAR2(3),
19: SERIAL_CONTROL_FLAG VARCHAR2(3),
20: RESTRICT_LOCATORS_CODE MTL_SYSTEM_ITEMS.RESTRICT_LOCATORS_CODE%TYPE,
21: RESTRICT_SUBINVENTORIES_CODE MTL_SYSTEM_ITEMS.RESTRICT_SUBINVENTORIES_CODE%TYPE,
22: SERIAL_NUMBER_CONTROL_CODE MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE%TYPE,
23: LOCATION_CONTROL_CODE MTL_SYSTEM_ITEMS.LOCATION_CONTROL_CODE%TYPE,
24: RESERVABLE_TYPE MTL_SYSTEM_ITEMS.RESERVABLE_TYPE%TYPE,

Line 21: RESTRICT_SUBINVENTORIES_CODE MTL_SYSTEM_ITEMS.RESTRICT_SUBINVENTORIES_CODE%TYPE,

17: LOT_CONTROL_FLAG VARCHAR2(3),
18: REV_CONTROL_FLAG VARCHAR2(3),
19: SERIAL_CONTROL_FLAG VARCHAR2(3),
20: RESTRICT_LOCATORS_CODE MTL_SYSTEM_ITEMS.RESTRICT_LOCATORS_CODE%TYPE,
21: RESTRICT_SUBINVENTORIES_CODE MTL_SYSTEM_ITEMS.RESTRICT_SUBINVENTORIES_CODE%TYPE,
22: SERIAL_NUMBER_CONTROL_CODE MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE%TYPE,
23: LOCATION_CONTROL_CODE MTL_SYSTEM_ITEMS.LOCATION_CONTROL_CODE%TYPE,
24: RESERVABLE_TYPE MTL_SYSTEM_ITEMS.RESERVABLE_TYPE%TYPE,
25: MTL_TRANSACTIONS_ENABLED_FLAG MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG%TYPE);

Line 22: SERIAL_NUMBER_CONTROL_CODE MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE%TYPE,

18: REV_CONTROL_FLAG VARCHAR2(3),
19: SERIAL_CONTROL_FLAG VARCHAR2(3),
20: RESTRICT_LOCATORS_CODE MTL_SYSTEM_ITEMS.RESTRICT_LOCATORS_CODE%TYPE,
21: RESTRICT_SUBINVENTORIES_CODE MTL_SYSTEM_ITEMS.RESTRICT_SUBINVENTORIES_CODE%TYPE,
22: SERIAL_NUMBER_CONTROL_CODE MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE%TYPE,
23: LOCATION_CONTROL_CODE MTL_SYSTEM_ITEMS.LOCATION_CONTROL_CODE%TYPE,
24: RESERVABLE_TYPE MTL_SYSTEM_ITEMS.RESERVABLE_TYPE%TYPE,
25: MTL_TRANSACTIONS_ENABLED_FLAG MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG%TYPE);
26:

Line 23: LOCATION_CONTROL_CODE MTL_SYSTEM_ITEMS.LOCATION_CONTROL_CODE%TYPE,

19: SERIAL_CONTROL_FLAG VARCHAR2(3),
20: RESTRICT_LOCATORS_CODE MTL_SYSTEM_ITEMS.RESTRICT_LOCATORS_CODE%TYPE,
21: RESTRICT_SUBINVENTORIES_CODE MTL_SYSTEM_ITEMS.RESTRICT_SUBINVENTORIES_CODE%TYPE,
22: SERIAL_NUMBER_CONTROL_CODE MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE%TYPE,
23: LOCATION_CONTROL_CODE MTL_SYSTEM_ITEMS.LOCATION_CONTROL_CODE%TYPE,
24: RESERVABLE_TYPE MTL_SYSTEM_ITEMS.RESERVABLE_TYPE%TYPE,
25: MTL_TRANSACTIONS_ENABLED_FLAG MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG%TYPE);
26:
27:

Line 24: RESERVABLE_TYPE MTL_SYSTEM_ITEMS.RESERVABLE_TYPE%TYPE,

20: RESTRICT_LOCATORS_CODE MTL_SYSTEM_ITEMS.RESTRICT_LOCATORS_CODE%TYPE,
21: RESTRICT_SUBINVENTORIES_CODE MTL_SYSTEM_ITEMS.RESTRICT_SUBINVENTORIES_CODE%TYPE,
22: SERIAL_NUMBER_CONTROL_CODE MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE%TYPE,
23: LOCATION_CONTROL_CODE MTL_SYSTEM_ITEMS.LOCATION_CONTROL_CODE%TYPE,
24: RESERVABLE_TYPE MTL_SYSTEM_ITEMS.RESERVABLE_TYPE%TYPE,
25: MTL_TRANSACTIONS_ENABLED_FLAG MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG%TYPE);
26:
27:
28: TYPE inventory_control_tab IS TABLE OF inventory_control_rec INDEX BY VARCHAR2(90);

Line 25: MTL_TRANSACTIONS_ENABLED_FLAG MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG%TYPE);

21: RESTRICT_SUBINVENTORIES_CODE MTL_SYSTEM_ITEMS.RESTRICT_SUBINVENTORIES_CODE%TYPE,
22: SERIAL_NUMBER_CONTROL_CODE MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE%TYPE,
23: LOCATION_CONTROL_CODE MTL_SYSTEM_ITEMS.LOCATION_CONTROL_CODE%TYPE,
24: RESERVABLE_TYPE MTL_SYSTEM_ITEMS.RESERVABLE_TYPE%TYPE,
25: MTL_TRANSACTIONS_ENABLED_FLAG MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG%TYPE);
26:
27:
28: TYPE inventory_control_tab IS TABLE OF inventory_control_rec INDEX BY VARCHAR2(90);
29: g_inventory_control_tab inventory_control_tab;

Line 39: FROM MTL_SYSTEM_ITEMS

35: lot_control_code, tracking_quantity_ind, dual_uom_deviation_low,
36: dual_uom_deviation_high, enabled_flag, shippable_item_flag,
37: inventory_item_flag, lot_divisible_flag, container_item_flag,
38: reservable_type, mtl_transactions_enabled_flag, 'Y' valid_flag
39: FROM MTL_SYSTEM_ITEMS
40: WHERE organization_id = v_organization_id
41: AND inventory_item_id = v_inventory_item_id;
42:
43: CURSOR c_org_param_info (v_organization_id NUMBER) IS

Line 288: FROM MTL_SYSTEM_ITEMS

284: END IF ;
285:
286: SELECT *
287: INTO p_item
288: FROM MTL_SYSTEM_ITEMS
289: WHERE ORGANIZATION_ID = p_org.organization_id
290: AND INVENTORY_ITEM_ID = p_item.inventory_item_id;
291: -- add record to cache
292: g_inv_item_tab(l_index) := p_item;

Line 574: fetches the control codes/flags from mtl_system_items for the

570: x_return_status - return status of the API.
571: DESCRIPTION : This procedure takes a delivery detail id and optionally
572: inventory item id and organization id and determines whether
573: the item is under any of the inventory controls. The API
574: fetches the control codes/flags from mtl_system_items for the
575: given inventory item and organization and decodes them and
576: returns a record of inv controls with a 'Y' or a 'N' for each
577: of the inv controls.
578:

Line 624: FROM MTL_SYSTEM_ITEMS msi

620: -- msi.segment1 ,
621: -- msi.container_item_flag,
622: msi.reservable_type,
623: msi.MTL_TRANSACTIONS_ENABLED_FLAG -- Bug 3599363
624: FROM MTL_SYSTEM_ITEMS msi
625: WHERE msi.inventory_item_id = v_inventory_item_id
626: AND msi.organization_id = v_organization_id;
627:
628: --RTV changes

Line 4096: l_type MTL_SYSTEM_ITEMS.RESERVABLE_TYPE%TYPE;

4092: VARCHAR2 IS
4093: -- bug 1583800: pickable_flag <> 'Y' overrides the reservable_flag
4094: -- also, check if the item is transactable.
4095:
4096: l_type MTL_SYSTEM_ITEMS.RESERVABLE_TYPE%TYPE;
4097: l_trx_flag MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG%TYPE;
4098: l_flag VARCHAR2(1) := 'Y';
4099: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
4100: --

Line 4097: l_trx_flag MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG%TYPE;

4093: -- bug 1583800: pickable_flag <> 'Y' overrides the reservable_flag
4094: -- also, check if the item is transactable.
4095:
4096: l_type MTL_SYSTEM_ITEMS.RESERVABLE_TYPE%TYPE;
4097: l_trx_flag MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG%TYPE;
4098: l_flag VARCHAR2(1) := 'Y';
4099: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
4100: --
4101: l_debug_on BOOLEAN;

Line 4099: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

4095:
4096: l_type MTL_SYSTEM_ITEMS.RESERVABLE_TYPE%TYPE;
4097: l_trx_flag MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG%TYPE;
4098: l_flag VARCHAR2(1) := 'Y';
4099: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
4100: --
4101: l_debug_on BOOLEAN;
4102: l_return_status VARCHAR2(1);
4103: --

Line 4148: , x_mtl_system_items_rec => l_item_info

4144: l_flag := 'N';
4145: ELSE
4146: Get_item_information( p_organization_id => x_organization_id
4147: , p_inventory_item_id => x_item_id
4148: , x_mtl_system_items_rec => l_item_info
4149: , x_return_status => l_return_status);
4150:
4151: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4152: RAISE FND_API.G_EXC_ERROR;

Line 4236: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

4232:
4233: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4234: l_reservable_type NUMBER;
4235: l_mtl_txns_enabled_flag VARCHAR2(1);
4236: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
4237: l_debug_on BOOLEAN;
4238: --
4239: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'LINE_RESERVED';
4240: --

Line 4294: , x_mtl_system_items_rec => l_item_info

4290: END IF;
4291:
4292: Get_item_information( p_organization_id => p_organization_id
4293: , p_inventory_item_id => p_inventory_item_id
4294: , x_mtl_system_items_rec => l_item_info
4295: , x_return_status => l_return_status);
4296:
4297: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4298: RAISE FND_API.G_EXC_ERROR;

Line 5222: x_mtl_system_items_rec - Record to hold item informatiom

5218: -----------------------------------------------------------------------------
5219: PROCEDURE : Get_item_information
5220: PARAMETERS : p_organization_id - organization id
5221: p_inventory_item_id - source system code
5222: x_mtl_system_items_rec - Record to hold item informatiom
5223: x_return_status - success if able to look up item information
5224: error if cannot find item information
5225:
5226: DESCRIPTION : This API takes the organization and inventory item

Line 5236: , x_mtl_system_items_rec OUT NOCOPY WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec

5232:
5233: PROCEDURE Get_item_information (
5234: p_organization_id IN NUMBER
5235: , p_inventory_item_id IN NUMBER
5236: , x_mtl_system_items_rec OUT NOCOPY WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec
5237: , x_return_status OUT NOCOPY VARCHAR2
5238: )IS
5239:
5240:

Line 5325: x_mtl_system_items_rec.primary_uom_code:= l_cache_rec.primary_uom_code;

5321: RETURN;
5322: END IF;
5323: -- Always populate the values
5324:
5325: x_mtl_system_items_rec.primary_uom_code:= l_cache_rec.primary_uom_code;
5326: /* Lgao, bug 5137114, the secondary_default_ind only has meanings when the
5327: * tracking_quantity_ind is for both primary and secondary in inventory.
5328: */
5329: if l_cache_rec.tracking_quantity_ind = 'PS' then

Line 5330: x_mtl_system_items_rec.secondary_default_ind:=l_cache_rec.secondary_default_ind;

5326: /* Lgao, bug 5137114, the secondary_default_ind only has meanings when the
5327: * tracking_quantity_ind is for both primary and secondary in inventory.
5328: */
5329: if l_cache_rec.tracking_quantity_ind = 'PS' then
5330: x_mtl_system_items_rec.secondary_default_ind:=l_cache_rec.secondary_default_ind;
5331: x_mtl_system_items_rec.secondary_uom_code:=l_cache_rec.secondary_uom_code;
5332: else
5333: x_mtl_system_items_rec.secondary_default_ind:='';
5334: x_mtl_system_items_rec.secondary_uom_code:= '';

Line 5331: x_mtl_system_items_rec.secondary_uom_code:=l_cache_rec.secondary_uom_code;

5327: * tracking_quantity_ind is for both primary and secondary in inventory.
5328: */
5329: if l_cache_rec.tracking_quantity_ind = 'PS' then
5330: x_mtl_system_items_rec.secondary_default_ind:=l_cache_rec.secondary_default_ind;
5331: x_mtl_system_items_rec.secondary_uom_code:=l_cache_rec.secondary_uom_code;
5332: else
5333: x_mtl_system_items_rec.secondary_default_ind:='';
5334: x_mtl_system_items_rec.secondary_uom_code:= '';
5335: end if;

Line 5333: x_mtl_system_items_rec.secondary_default_ind:='';

5329: if l_cache_rec.tracking_quantity_ind = 'PS' then
5330: x_mtl_system_items_rec.secondary_default_ind:=l_cache_rec.secondary_default_ind;
5331: x_mtl_system_items_rec.secondary_uom_code:=l_cache_rec.secondary_uom_code;
5332: else
5333: x_mtl_system_items_rec.secondary_default_ind:='';
5334: x_mtl_system_items_rec.secondary_uom_code:= '';
5335: end if;
5336: x_mtl_system_items_rec.lot_control_code:=l_cache_rec.lot_control_code;
5337:

Line 5334: x_mtl_system_items_rec.secondary_uom_code:= '';

5330: x_mtl_system_items_rec.secondary_default_ind:=l_cache_rec.secondary_default_ind;
5331: x_mtl_system_items_rec.secondary_uom_code:=l_cache_rec.secondary_uom_code;
5332: else
5333: x_mtl_system_items_rec.secondary_default_ind:='';
5334: x_mtl_system_items_rec.secondary_uom_code:= '';
5335: end if;
5336: x_mtl_system_items_rec.lot_control_code:=l_cache_rec.lot_control_code;
5337:
5338: x_mtl_system_items_rec.tracking_quantity_ind:=l_cache_rec.tracking_quantity_ind;

Line 5336: x_mtl_system_items_rec.lot_control_code:=l_cache_rec.lot_control_code;

5332: else
5333: x_mtl_system_items_rec.secondary_default_ind:='';
5334: x_mtl_system_items_rec.secondary_uom_code:= '';
5335: end if;
5336: x_mtl_system_items_rec.lot_control_code:=l_cache_rec.lot_control_code;
5337:
5338: x_mtl_system_items_rec.tracking_quantity_ind:=l_cache_rec.tracking_quantity_ind;
5339: x_mtl_system_items_rec.dual_uom_deviation_low:=l_cache_rec.dual_uom_deviation_low;
5340: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;

Line 5338: x_mtl_system_items_rec.tracking_quantity_ind:=l_cache_rec.tracking_quantity_ind;

5334: x_mtl_system_items_rec.secondary_uom_code:= '';
5335: end if;
5336: x_mtl_system_items_rec.lot_control_code:=l_cache_rec.lot_control_code;
5337:
5338: x_mtl_system_items_rec.tracking_quantity_ind:=l_cache_rec.tracking_quantity_ind;
5339: x_mtl_system_items_rec.dual_uom_deviation_low:=l_cache_rec.dual_uom_deviation_low;
5340: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;
5341: x_mtl_system_items_rec.enabled_flag:=l_cache_rec.enabled_flag;
5342: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;

Line 5339: x_mtl_system_items_rec.dual_uom_deviation_low:=l_cache_rec.dual_uom_deviation_low;

5335: end if;
5336: x_mtl_system_items_rec.lot_control_code:=l_cache_rec.lot_control_code;
5337:
5338: x_mtl_system_items_rec.tracking_quantity_ind:=l_cache_rec.tracking_quantity_ind;
5339: x_mtl_system_items_rec.dual_uom_deviation_low:=l_cache_rec.dual_uom_deviation_low;
5340: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;
5341: x_mtl_system_items_rec.enabled_flag:=l_cache_rec.enabled_flag;
5342: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;
5343: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;

Line 5340: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;

5336: x_mtl_system_items_rec.lot_control_code:=l_cache_rec.lot_control_code;
5337:
5338: x_mtl_system_items_rec.tracking_quantity_ind:=l_cache_rec.tracking_quantity_ind;
5339: x_mtl_system_items_rec.dual_uom_deviation_low:=l_cache_rec.dual_uom_deviation_low;
5340: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;
5341: x_mtl_system_items_rec.enabled_flag:=l_cache_rec.enabled_flag;
5342: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;
5343: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;
5344: x_mtl_system_items_rec.lot_divisible_flag:=l_cache_rec.lot_divisible_flag;

Line 5341: x_mtl_system_items_rec.enabled_flag:=l_cache_rec.enabled_flag;

5337:
5338: x_mtl_system_items_rec.tracking_quantity_ind:=l_cache_rec.tracking_quantity_ind;
5339: x_mtl_system_items_rec.dual_uom_deviation_low:=l_cache_rec.dual_uom_deviation_low;
5340: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;
5341: x_mtl_system_items_rec.enabled_flag:=l_cache_rec.enabled_flag;
5342: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;
5343: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;
5344: x_mtl_system_items_rec.lot_divisible_flag:=l_cache_rec.lot_divisible_flag;
5345: x_mtl_system_items_rec.container_item_flag:=l_cache_rec.container_item_flag;

Line 5342: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;

5338: x_mtl_system_items_rec.tracking_quantity_ind:=l_cache_rec.tracking_quantity_ind;
5339: x_mtl_system_items_rec.dual_uom_deviation_low:=l_cache_rec.dual_uom_deviation_low;
5340: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;
5341: x_mtl_system_items_rec.enabled_flag:=l_cache_rec.enabled_flag;
5342: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;
5343: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;
5344: x_mtl_system_items_rec.lot_divisible_flag:=l_cache_rec.lot_divisible_flag;
5345: x_mtl_system_items_rec.container_item_flag:=l_cache_rec.container_item_flag;
5346: x_mtl_system_items_rec.reservable_type:=l_cache_rec.reservable_type;

Line 5343: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;

5339: x_mtl_system_items_rec.dual_uom_deviation_low:=l_cache_rec.dual_uom_deviation_low;
5340: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;
5341: x_mtl_system_items_rec.enabled_flag:=l_cache_rec.enabled_flag;
5342: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;
5343: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;
5344: x_mtl_system_items_rec.lot_divisible_flag:=l_cache_rec.lot_divisible_flag;
5345: x_mtl_system_items_rec.container_item_flag:=l_cache_rec.container_item_flag;
5346: x_mtl_system_items_rec.reservable_type:=l_cache_rec.reservable_type;
5347: x_mtl_system_items_rec.mtl_transactions_enabled_flag:=l_cache_rec.mtl_transactions_enabled_flag;

Line 5344: x_mtl_system_items_rec.lot_divisible_flag:=l_cache_rec.lot_divisible_flag;

5340: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;
5341: x_mtl_system_items_rec.enabled_flag:=l_cache_rec.enabled_flag;
5342: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;
5343: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;
5344: x_mtl_system_items_rec.lot_divisible_flag:=l_cache_rec.lot_divisible_flag;
5345: x_mtl_system_items_rec.container_item_flag:=l_cache_rec.container_item_flag;
5346: x_mtl_system_items_rec.reservable_type:=l_cache_rec.reservable_type;
5347: x_mtl_system_items_rec.mtl_transactions_enabled_flag:=l_cache_rec.mtl_transactions_enabled_flag;
5348:

Line 5345: x_mtl_system_items_rec.container_item_flag:=l_cache_rec.container_item_flag;

5341: x_mtl_system_items_rec.enabled_flag:=l_cache_rec.enabled_flag;
5342: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;
5343: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;
5344: x_mtl_system_items_rec.lot_divisible_flag:=l_cache_rec.lot_divisible_flag;
5345: x_mtl_system_items_rec.container_item_flag:=l_cache_rec.container_item_flag;
5346: x_mtl_system_items_rec.reservable_type:=l_cache_rec.reservable_type;
5347: x_mtl_system_items_rec.mtl_transactions_enabled_flag:=l_cache_rec.mtl_transactions_enabled_flag;
5348:
5349: ELSE -- Both or one is NULL (Org and Inv_item)

Line 5346: x_mtl_system_items_rec.reservable_type:=l_cache_rec.reservable_type;

5342: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;
5343: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;
5344: x_mtl_system_items_rec.lot_divisible_flag:=l_cache_rec.lot_divisible_flag;
5345: x_mtl_system_items_rec.container_item_flag:=l_cache_rec.container_item_flag;
5346: x_mtl_system_items_rec.reservable_type:=l_cache_rec.reservable_type;
5347: x_mtl_system_items_rec.mtl_transactions_enabled_flag:=l_cache_rec.mtl_transactions_enabled_flag;
5348:
5349: ELSE -- Both or one is NULL (Org and Inv_item)
5350: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 5347: x_mtl_system_items_rec.mtl_transactions_enabled_flag:=l_cache_rec.mtl_transactions_enabled_flag;

5343: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;
5344: x_mtl_system_items_rec.lot_divisible_flag:=l_cache_rec.lot_divisible_flag;
5345: x_mtl_system_items_rec.container_item_flag:=l_cache_rec.container_item_flag;
5346: x_mtl_system_items_rec.reservable_type:=l_cache_rec.reservable_type;
5347: x_mtl_system_items_rec.mtl_transactions_enabled_flag:=l_cache_rec.mtl_transactions_enabled_flag;
5348:
5349: ELSE -- Both or one is NULL (Org and Inv_item)
5350: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5351: IF l_debug_on THEN

Line 5359: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.primary_uom_code',x_mtl_system_items_rec.primary_uom_code);

5355: RETURN;
5356: END IF;
5357:
5358: IF l_debug_on THEN
5359: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.primary_uom_code',x_mtl_system_items_rec.primary_uom_code);
5360: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_uom_code',x_mtl_system_items_rec.secondary_uom_code);
5361: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
5362: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
5363: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);

Line 5360: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_uom_code',x_mtl_system_items_rec.secondary_uom_code);

5356: END IF;
5357:
5358: IF l_debug_on THEN
5359: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.primary_uom_code',x_mtl_system_items_rec.primary_uom_code);
5360: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_uom_code',x_mtl_system_items_rec.secondary_uom_code);
5361: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
5362: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
5363: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
5364: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);

Line 5361: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);

5357:
5358: IF l_debug_on THEN
5359: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.primary_uom_code',x_mtl_system_items_rec.primary_uom_code);
5360: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_uom_code',x_mtl_system_items_rec.secondary_uom_code);
5361: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
5362: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
5363: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
5364: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);
5365: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);

Line 5362: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);

5358: IF l_debug_on THEN
5359: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.primary_uom_code',x_mtl_system_items_rec.primary_uom_code);
5360: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_uom_code',x_mtl_system_items_rec.secondary_uom_code);
5361: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
5362: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
5363: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
5364: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);
5365: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);
5366: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);

Line 5363: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);

5359: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.primary_uom_code',x_mtl_system_items_rec.primary_uom_code);
5360: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_uom_code',x_mtl_system_items_rec.secondary_uom_code);
5361: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
5362: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
5363: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
5364: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);
5365: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);
5366: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
5367: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);

Line 5364: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);

5360: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_uom_code',x_mtl_system_items_rec.secondary_uom_code);
5361: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
5362: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
5363: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
5364: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);
5365: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);
5366: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
5367: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
5368: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);

Line 5365: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);

5361: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
5362: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
5363: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
5364: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);
5365: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);
5366: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
5367: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
5368: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
5369: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);

Line 5366: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);

5362: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
5363: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
5364: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);
5365: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);
5366: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
5367: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
5368: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
5369: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
5370: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);

Line 5367: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);

5363: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
5364: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);
5365: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);
5366: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
5367: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
5368: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
5369: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
5370: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);
5371: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.reservable_type',x_mtl_system_items_rec.reservable_type);

Line 5368: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);

5364: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);
5365: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);
5366: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
5367: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
5368: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
5369: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
5370: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);
5371: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.reservable_type',x_mtl_system_items_rec.reservable_type);
5372: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.mtl_transactions_enabled_flag',x_mtl_system_items_rec.mtl_transactions_enabled_flag);

Line 5369: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);

5365: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);
5366: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
5367: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
5368: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
5369: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
5370: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);
5371: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.reservable_type',x_mtl_system_items_rec.reservable_type);
5372: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.mtl_transactions_enabled_flag',x_mtl_system_items_rec.mtl_transactions_enabled_flag);
5373: WSH_DEBUG_SV.pop(l_module_name,x_return_status);

Line 5370: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);

5366: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
5367: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
5368: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
5369: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
5370: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);
5371: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.reservable_type',x_mtl_system_items_rec.reservable_type);
5372: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.mtl_transactions_enabled_flag',x_mtl_system_items_rec.mtl_transactions_enabled_flag);
5373: WSH_DEBUG_SV.pop(l_module_name,x_return_status);
5374: END IF;

Line 5371: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.reservable_type',x_mtl_system_items_rec.reservable_type);

5367: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
5368: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
5369: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
5370: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);
5371: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.reservable_type',x_mtl_system_items_rec.reservable_type);
5372: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.mtl_transactions_enabled_flag',x_mtl_system_items_rec.mtl_transactions_enabled_flag);
5373: WSH_DEBUG_SV.pop(l_module_name,x_return_status);
5374: END IF;
5375:

Line 5372: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.mtl_transactions_enabled_flag',x_mtl_system_items_rec.mtl_transactions_enabled_flag);

5368: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
5369: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
5370: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);
5371: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.reservable_type',x_mtl_system_items_rec.reservable_type);
5372: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.mtl_transactions_enabled_flag',x_mtl_system_items_rec.mtl_transactions_enabled_flag);
5373: WSH_DEBUG_SV.pop(l_module_name,x_return_status);
5374: END IF;
5375:
5376: EXCEPTION