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 199: FROM MTL_SYSTEM_ITEMS

195: END IF;
196: --
197: SELECT *
198: INTO p_item
199: FROM MTL_SYSTEM_ITEMS
200: WHERE ORGANIZATION_ID = p_org.organization_id
201: AND INVENTORY_ITEM_ID = p_item.inventory_item_id;
202:
203: --

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

471: x_return_status - return status of the API.
472: DESCRIPTION : This procedure takes a delivery detail id and optionally
473: inventory item id and organization id and determines whether
474: the item is under any of the inventory controls. The API
475: fetches the control codes/flags from mtl_system_items for the
476: given inventory item and organization and decodes them and
477: returns a record of inv controls with a 'Y' or a 'N' for each
478: of the inv controls.
479:

Line 525: FROM MTL_SYSTEM_ITEMS msi

521: -- msi.segment1 ,
522: -- msi.container_item_flag,
523: msi.reservable_type,
524: msi.MTL_TRANSACTIONS_ENABLED_FLAG -- Bug 3599363
525: FROM MTL_SYSTEM_ITEMS msi
526: WHERE msi.inventory_item_id = v_inventory_item_id
527: AND msi.organization_id = v_organization_id;
528:
529: CURSOR Get_Detail_Item IS

Line 3766: l_type MTL_SYSTEM_ITEMS.RESERVABLE_TYPE%TYPE;

3762: VARCHAR2 IS
3763: -- bug 1583800: pickable_flag <> 'Y' overrides the reservable_flag
3764: -- also, check if the item is transactable.
3765:
3766: l_type MTL_SYSTEM_ITEMS.RESERVABLE_TYPE%TYPE;
3767: l_trx_flag MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG%TYPE;
3768: l_flag VARCHAR2(1) := 'Y';
3769: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
3770: --

Line 3767: l_trx_flag MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG%TYPE;

3763: -- bug 1583800: pickable_flag <> 'Y' overrides the reservable_flag
3764: -- also, check if the item is transactable.
3765:
3766: l_type MTL_SYSTEM_ITEMS.RESERVABLE_TYPE%TYPE;
3767: l_trx_flag MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG%TYPE;
3768: l_flag VARCHAR2(1) := 'Y';
3769: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
3770: --
3771: l_debug_on BOOLEAN;

Line 3769: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

3765:
3766: l_type MTL_SYSTEM_ITEMS.RESERVABLE_TYPE%TYPE;
3767: l_trx_flag MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG%TYPE;
3768: l_flag VARCHAR2(1) := 'Y';
3769: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
3770: --
3771: l_debug_on BOOLEAN;
3772: l_return_status VARCHAR2(1);
3773: --

Line 3818: , x_mtl_system_items_rec => l_item_info

3814: l_flag := 'N';
3815: ELSE
3816: Get_item_information( p_organization_id => x_organization_id
3817: , p_inventory_item_id => x_item_id
3818: , x_mtl_system_items_rec => l_item_info
3819: , x_return_status => l_return_status);
3820:
3821: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3822: RAISE FND_API.G_EXC_ERROR;

Line 3906: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

3902:
3903: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3904: l_reservable_type NUMBER;
3905: l_mtl_txns_enabled_flag VARCHAR2(1);
3906: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
3907: l_debug_on BOOLEAN;
3908: --
3909: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'LINE_RESERVED';
3910: --

Line 3965: , x_mtl_system_items_rec => l_item_info

3961: END IF;
3962:
3963: Get_item_information( p_organization_id => p_organization_id
3964: , p_inventory_item_id => p_inventory_item_id
3965: , x_mtl_system_items_rec => l_item_info
3966: , x_return_status => l_return_status);
3967:
3968: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3969: RAISE FND_API.G_EXC_ERROR;

Line 4846: x_mtl_system_items_rec - Record to hold item informatiom

4842: -----------------------------------------------------------------------------
4843: PROCEDURE : Get_item_information
4844: PARAMETERS : p_organization_id - organization id
4845: p_inventory_item_id - source system code
4846: x_mtl_system_items_rec - Record to hold item informatiom
4847: x_return_status - success if able to look up item information
4848: error if cannot find item information
4849:
4850: DESCRIPTION : This API takes the organization and inventory item

Line 4860: , x_mtl_system_items_rec OUT NOCOPY WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec

4856:
4857: PROCEDURE Get_item_information (
4858: p_organization_id IN NUMBER
4859: , p_inventory_item_id IN NUMBER
4860: , x_mtl_system_items_rec OUT NOCOPY WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec
4861: , x_return_status OUT NOCOPY VARCHAR2
4862: )IS
4863:
4864:

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

4945: RETURN;
4946: END IF;
4947: -- Always populate the values
4948:
4949: x_mtl_system_items_rec.primary_uom_code:= l_cache_rec.primary_uom_code;
4950: /* Lgao, bug 5137114, the secondary_default_ind only has meanings when the
4951: * tracking_quantity_ind is for both primary and secondary in inventory.
4952: */
4953: if l_cache_rec.tracking_quantity_ind = 'PS' then

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

4950: /* Lgao, bug 5137114, the secondary_default_ind only has meanings when the
4951: * tracking_quantity_ind is for both primary and secondary in inventory.
4952: */
4953: if l_cache_rec.tracking_quantity_ind = 'PS' then
4954: x_mtl_system_items_rec.secondary_default_ind:=l_cache_rec.secondary_default_ind;
4955: x_mtl_system_items_rec.secondary_uom_code:=l_cache_rec.secondary_uom_code;
4956: else
4957: x_mtl_system_items_rec.secondary_default_ind:='';
4958: x_mtl_system_items_rec.secondary_uom_code:= '';

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

4951: * tracking_quantity_ind is for both primary and secondary in inventory.
4952: */
4953: if l_cache_rec.tracking_quantity_ind = 'PS' then
4954: x_mtl_system_items_rec.secondary_default_ind:=l_cache_rec.secondary_default_ind;
4955: x_mtl_system_items_rec.secondary_uom_code:=l_cache_rec.secondary_uom_code;
4956: else
4957: x_mtl_system_items_rec.secondary_default_ind:='';
4958: x_mtl_system_items_rec.secondary_uom_code:= '';
4959: end if;

Line 4957: x_mtl_system_items_rec.secondary_default_ind:='';

4953: if l_cache_rec.tracking_quantity_ind = 'PS' then
4954: x_mtl_system_items_rec.secondary_default_ind:=l_cache_rec.secondary_default_ind;
4955: x_mtl_system_items_rec.secondary_uom_code:=l_cache_rec.secondary_uom_code;
4956: else
4957: x_mtl_system_items_rec.secondary_default_ind:='';
4958: x_mtl_system_items_rec.secondary_uom_code:= '';
4959: end if;
4960: x_mtl_system_items_rec.lot_control_code:=l_cache_rec.lot_control_code;
4961:

Line 4958: x_mtl_system_items_rec.secondary_uom_code:= '';

4954: x_mtl_system_items_rec.secondary_default_ind:=l_cache_rec.secondary_default_ind;
4955: x_mtl_system_items_rec.secondary_uom_code:=l_cache_rec.secondary_uom_code;
4956: else
4957: x_mtl_system_items_rec.secondary_default_ind:='';
4958: x_mtl_system_items_rec.secondary_uom_code:= '';
4959: end if;
4960: x_mtl_system_items_rec.lot_control_code:=l_cache_rec.lot_control_code;
4961:
4962: x_mtl_system_items_rec.tracking_quantity_ind:=l_cache_rec.tracking_quantity_ind;

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

4956: else
4957: x_mtl_system_items_rec.secondary_default_ind:='';
4958: x_mtl_system_items_rec.secondary_uom_code:= '';
4959: end if;
4960: x_mtl_system_items_rec.lot_control_code:=l_cache_rec.lot_control_code;
4961:
4962: x_mtl_system_items_rec.tracking_quantity_ind:=l_cache_rec.tracking_quantity_ind;
4963: x_mtl_system_items_rec.dual_uom_deviation_low:=l_cache_rec.dual_uom_deviation_low;
4964: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;

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

4958: x_mtl_system_items_rec.secondary_uom_code:= '';
4959: end if;
4960: x_mtl_system_items_rec.lot_control_code:=l_cache_rec.lot_control_code;
4961:
4962: x_mtl_system_items_rec.tracking_quantity_ind:=l_cache_rec.tracking_quantity_ind;
4963: x_mtl_system_items_rec.dual_uom_deviation_low:=l_cache_rec.dual_uom_deviation_low;
4964: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;
4965: x_mtl_system_items_rec.enabled_flag:=l_cache_rec.enabled_flag;
4966: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;

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

4959: end if;
4960: x_mtl_system_items_rec.lot_control_code:=l_cache_rec.lot_control_code;
4961:
4962: x_mtl_system_items_rec.tracking_quantity_ind:=l_cache_rec.tracking_quantity_ind;
4963: x_mtl_system_items_rec.dual_uom_deviation_low:=l_cache_rec.dual_uom_deviation_low;
4964: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;
4965: x_mtl_system_items_rec.enabled_flag:=l_cache_rec.enabled_flag;
4966: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;
4967: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;

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

4960: x_mtl_system_items_rec.lot_control_code:=l_cache_rec.lot_control_code;
4961:
4962: x_mtl_system_items_rec.tracking_quantity_ind:=l_cache_rec.tracking_quantity_ind;
4963: x_mtl_system_items_rec.dual_uom_deviation_low:=l_cache_rec.dual_uom_deviation_low;
4964: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;
4965: x_mtl_system_items_rec.enabled_flag:=l_cache_rec.enabled_flag;
4966: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;
4967: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;
4968: x_mtl_system_items_rec.lot_divisible_flag:=l_cache_rec.lot_divisible_flag;

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

4961:
4962: x_mtl_system_items_rec.tracking_quantity_ind:=l_cache_rec.tracking_quantity_ind;
4963: x_mtl_system_items_rec.dual_uom_deviation_low:=l_cache_rec.dual_uom_deviation_low;
4964: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;
4965: x_mtl_system_items_rec.enabled_flag:=l_cache_rec.enabled_flag;
4966: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;
4967: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;
4968: x_mtl_system_items_rec.lot_divisible_flag:=l_cache_rec.lot_divisible_flag;
4969: x_mtl_system_items_rec.container_item_flag:=l_cache_rec.container_item_flag;

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

4962: x_mtl_system_items_rec.tracking_quantity_ind:=l_cache_rec.tracking_quantity_ind;
4963: x_mtl_system_items_rec.dual_uom_deviation_low:=l_cache_rec.dual_uom_deviation_low;
4964: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;
4965: x_mtl_system_items_rec.enabled_flag:=l_cache_rec.enabled_flag;
4966: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;
4967: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;
4968: x_mtl_system_items_rec.lot_divisible_flag:=l_cache_rec.lot_divisible_flag;
4969: x_mtl_system_items_rec.container_item_flag:=l_cache_rec.container_item_flag;
4970: x_mtl_system_items_rec.reservable_type:=l_cache_rec.reservable_type;

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

4963: x_mtl_system_items_rec.dual_uom_deviation_low:=l_cache_rec.dual_uom_deviation_low;
4964: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;
4965: x_mtl_system_items_rec.enabled_flag:=l_cache_rec.enabled_flag;
4966: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;
4967: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;
4968: x_mtl_system_items_rec.lot_divisible_flag:=l_cache_rec.lot_divisible_flag;
4969: x_mtl_system_items_rec.container_item_flag:=l_cache_rec.container_item_flag;
4970: x_mtl_system_items_rec.reservable_type:=l_cache_rec.reservable_type;
4971: x_mtl_system_items_rec.mtl_transactions_enabled_flag:=l_cache_rec.mtl_transactions_enabled_flag;

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

4964: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;
4965: x_mtl_system_items_rec.enabled_flag:=l_cache_rec.enabled_flag;
4966: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;
4967: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;
4968: x_mtl_system_items_rec.lot_divisible_flag:=l_cache_rec.lot_divisible_flag;
4969: x_mtl_system_items_rec.container_item_flag:=l_cache_rec.container_item_flag;
4970: x_mtl_system_items_rec.reservable_type:=l_cache_rec.reservable_type;
4971: x_mtl_system_items_rec.mtl_transactions_enabled_flag:=l_cache_rec.mtl_transactions_enabled_flag;
4972:

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

4965: x_mtl_system_items_rec.enabled_flag:=l_cache_rec.enabled_flag;
4966: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;
4967: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;
4968: x_mtl_system_items_rec.lot_divisible_flag:=l_cache_rec.lot_divisible_flag;
4969: x_mtl_system_items_rec.container_item_flag:=l_cache_rec.container_item_flag;
4970: x_mtl_system_items_rec.reservable_type:=l_cache_rec.reservable_type;
4971: x_mtl_system_items_rec.mtl_transactions_enabled_flag:=l_cache_rec.mtl_transactions_enabled_flag;
4972:
4973: ELSE -- Both or one is NULL (Org and Inv_item)

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

4966: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;
4967: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;
4968: x_mtl_system_items_rec.lot_divisible_flag:=l_cache_rec.lot_divisible_flag;
4969: x_mtl_system_items_rec.container_item_flag:=l_cache_rec.container_item_flag;
4970: x_mtl_system_items_rec.reservable_type:=l_cache_rec.reservable_type;
4971: x_mtl_system_items_rec.mtl_transactions_enabled_flag:=l_cache_rec.mtl_transactions_enabled_flag;
4972:
4973: ELSE -- Both or one is NULL (Org and Inv_item)
4974: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

4967: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;
4968: x_mtl_system_items_rec.lot_divisible_flag:=l_cache_rec.lot_divisible_flag;
4969: x_mtl_system_items_rec.container_item_flag:=l_cache_rec.container_item_flag;
4970: x_mtl_system_items_rec.reservable_type:=l_cache_rec.reservable_type;
4971: x_mtl_system_items_rec.mtl_transactions_enabled_flag:=l_cache_rec.mtl_transactions_enabled_flag;
4972:
4973: ELSE -- Both or one is NULL (Org and Inv_item)
4974: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4975: IF l_debug_on THEN

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

4979: RETURN;
4980: END IF;
4981:
4982: IF l_debug_on THEN
4983: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.primary_uom_code',x_mtl_system_items_rec.primary_uom_code);
4984: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_uom_code',x_mtl_system_items_rec.secondary_uom_code);
4985: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
4986: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
4987: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);

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

4980: END IF;
4981:
4982: IF l_debug_on THEN
4983: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.primary_uom_code',x_mtl_system_items_rec.primary_uom_code);
4984: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_uom_code',x_mtl_system_items_rec.secondary_uom_code);
4985: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
4986: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
4987: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
4988: 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 4985: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);

4981:
4982: IF l_debug_on THEN
4983: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.primary_uom_code',x_mtl_system_items_rec.primary_uom_code);
4984: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_uom_code',x_mtl_system_items_rec.secondary_uom_code);
4985: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
4986: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
4987: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
4988: 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);
4989: 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 4986: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);

4982: IF l_debug_on THEN
4983: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.primary_uom_code',x_mtl_system_items_rec.primary_uom_code);
4984: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_uom_code',x_mtl_system_items_rec.secondary_uom_code);
4985: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
4986: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
4987: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
4988: 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);
4989: 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);
4990: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);

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

4983: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.primary_uom_code',x_mtl_system_items_rec.primary_uom_code);
4984: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_uom_code',x_mtl_system_items_rec.secondary_uom_code);
4985: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
4986: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
4987: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
4988: 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);
4989: 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);
4990: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
4991: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);

Line 4988: 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);

4984: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_uom_code',x_mtl_system_items_rec.secondary_uom_code);
4985: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
4986: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
4987: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
4988: 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);
4989: 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);
4990: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
4991: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
4992: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);

Line 4989: 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);

4985: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
4986: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
4987: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
4988: 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);
4989: 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);
4990: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
4991: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
4992: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
4993: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);

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

4986: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
4987: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
4988: 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);
4989: 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);
4990: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
4991: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
4992: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
4993: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
4994: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);

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

4987: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
4988: 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);
4989: 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);
4990: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
4991: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
4992: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
4993: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
4994: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);
4995: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.reservable_type',x_mtl_system_items_rec.reservable_type);

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

4988: 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);
4989: 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);
4990: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
4991: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
4992: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
4993: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
4994: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);
4995: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.reservable_type',x_mtl_system_items_rec.reservable_type);
4996: 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 4993: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);

4989: 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);
4990: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
4991: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
4992: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
4993: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
4994: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);
4995: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.reservable_type',x_mtl_system_items_rec.reservable_type);
4996: 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);
4997: WSH_DEBUG_SV.pop(l_module_name,x_return_status);

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

4990: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
4991: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
4992: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
4993: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
4994: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);
4995: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.reservable_type',x_mtl_system_items_rec.reservable_type);
4996: 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);
4997: WSH_DEBUG_SV.pop(l_module_name,x_return_status);
4998: END IF;

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

4991: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
4992: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
4993: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
4994: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);
4995: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.reservable_type',x_mtl_system_items_rec.reservable_type);
4996: 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);
4997: WSH_DEBUG_SV.pop(l_module_name,x_return_status);
4998: END IF;
4999:

Line 4996: 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);

4992: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
4993: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
4994: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);
4995: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.reservable_type',x_mtl_system_items_rec.reservable_type);
4996: 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);
4997: WSH_DEBUG_SV.pop(l_module_name,x_return_status);
4998: END IF;
4999:
5000: EXCEPTION