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.WMS_PICK_LOAD_UI dependencies on MTL_SECONDARY_INVENTORIES

Line 24: (subinventory_code mtl_secondary_inventories.secondary_inventory_name%TYPE,

20:
21: IS
22:
23: TYPE sub_record_type IS RECORD
24: (subinventory_code mtl_secondary_inventories.secondary_inventory_name%TYPE,
25: locator_type mtl_secondary_inventories.locator_type%TYPE,
26: description mtl_secondary_inventories.description%TYPE,
27: asset_inventory mtl_secondary_inventories.asset_inventory%TYPE,
28: lpn_controlled_flag mtl_secondary_inventories.lpn_controlled_flag%TYPE,

Line 25: locator_type mtl_secondary_inventories.locator_type%TYPE,

21: IS
22:
23: TYPE sub_record_type IS RECORD
24: (subinventory_code mtl_secondary_inventories.secondary_inventory_name%TYPE,
25: locator_type mtl_secondary_inventories.locator_type%TYPE,
26: description mtl_secondary_inventories.description%TYPE,
27: asset_inventory mtl_secondary_inventories.asset_inventory%TYPE,
28: lpn_controlled_flag mtl_secondary_inventories.lpn_controlled_flag%TYPE,
29: subinventory_type mtl_secondary_inventories.subinventory_type%TYPE,

Line 26: description mtl_secondary_inventories.description%TYPE,

22:
23: TYPE sub_record_type IS RECORD
24: (subinventory_code mtl_secondary_inventories.secondary_inventory_name%TYPE,
25: locator_type mtl_secondary_inventories.locator_type%TYPE,
26: description mtl_secondary_inventories.description%TYPE,
27: asset_inventory mtl_secondary_inventories.asset_inventory%TYPE,
28: lpn_controlled_flag mtl_secondary_inventories.lpn_controlled_flag%TYPE,
29: subinventory_type mtl_secondary_inventories.subinventory_type%TYPE,
30: reservable_type mtl_secondary_inventories.reservable_type%TYPE,

Line 27: asset_inventory mtl_secondary_inventories.asset_inventory%TYPE,

23: TYPE sub_record_type IS RECORD
24: (subinventory_code mtl_secondary_inventories.secondary_inventory_name%TYPE,
25: locator_type mtl_secondary_inventories.locator_type%TYPE,
26: description mtl_secondary_inventories.description%TYPE,
27: asset_inventory mtl_secondary_inventories.asset_inventory%TYPE,
28: lpn_controlled_flag mtl_secondary_inventories.lpn_controlled_flag%TYPE,
29: subinventory_type mtl_secondary_inventories.subinventory_type%TYPE,
30: reservable_type mtl_secondary_inventories.reservable_type%TYPE,
31: enable_alias mtl_secondary_inventories.enable_locator_alias%TYPE);

Line 28: lpn_controlled_flag mtl_secondary_inventories.lpn_controlled_flag%TYPE,

24: (subinventory_code mtl_secondary_inventories.secondary_inventory_name%TYPE,
25: locator_type mtl_secondary_inventories.locator_type%TYPE,
26: description mtl_secondary_inventories.description%TYPE,
27: asset_inventory mtl_secondary_inventories.asset_inventory%TYPE,
28: lpn_controlled_flag mtl_secondary_inventories.lpn_controlled_flag%TYPE,
29: subinventory_type mtl_secondary_inventories.subinventory_type%TYPE,
30: reservable_type mtl_secondary_inventories.reservable_type%TYPE,
31: enable_alias mtl_secondary_inventories.enable_locator_alias%TYPE);
32:

Line 29: subinventory_type mtl_secondary_inventories.subinventory_type%TYPE,

25: locator_type mtl_secondary_inventories.locator_type%TYPE,
26: description mtl_secondary_inventories.description%TYPE,
27: asset_inventory mtl_secondary_inventories.asset_inventory%TYPE,
28: lpn_controlled_flag mtl_secondary_inventories.lpn_controlled_flag%TYPE,
29: subinventory_type mtl_secondary_inventories.subinventory_type%TYPE,
30: reservable_type mtl_secondary_inventories.reservable_type%TYPE,
31: enable_alias mtl_secondary_inventories.enable_locator_alias%TYPE);
32:
33: l_sub_rec sub_record_type;

Line 30: reservable_type mtl_secondary_inventories.reservable_type%TYPE,

26: description mtl_secondary_inventories.description%TYPE,
27: asset_inventory mtl_secondary_inventories.asset_inventory%TYPE,
28: lpn_controlled_flag mtl_secondary_inventories.lpn_controlled_flag%TYPE,
29: subinventory_type mtl_secondary_inventories.subinventory_type%TYPE,
30: reservable_type mtl_secondary_inventories.reservable_type%TYPE,
31: enable_alias mtl_secondary_inventories.enable_locator_alias%TYPE);
32:
33: l_sub_rec sub_record_type;
34: l_subinventories t_genref;

Line 31: enable_alias mtl_secondary_inventories.enable_locator_alias%TYPE);

27: asset_inventory mtl_secondary_inventories.asset_inventory%TYPE,
28: lpn_controlled_flag mtl_secondary_inventories.lpn_controlled_flag%TYPE,
29: subinventory_type mtl_secondary_inventories.subinventory_type%TYPE,
30: reservable_type mtl_secondary_inventories.reservable_type%TYPE,
31: enable_alias mtl_secondary_inventories.enable_locator_alias%TYPE);
32:
33: l_sub_rec sub_record_type;
34: l_subinventories t_genref;
35:

Line 288: from MTL_SECONDARY_INVENTORIES

284:
285: BEGIN
286:
287: select ENABLE_LOCATOR_ALIAS INTO l_alias_enabled
288: from MTL_SECONDARY_INVENTORIES
289: where SECONDARY_INVENTORY_NAME = p_subinventory_code
290: and ORGANIZATION_ID = p_organization_id;
291:
292: IF (Nvl(l_alias_enabled, 'N') = 'Y') THEN

Line 434: FROM mtl_secondary_inventories

430: END IF;
431:
432: SELECT Decode(lpn_controlled_flag, 1, 'Y', 'N')
433: INTO x_is_lpn_controlled
434: FROM mtl_secondary_inventories
435: WHERE organization_id = p_organization_id
436: AND secondary_inventory_name = x_subinventory_code;
437: END IF;
438: