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 287: from MTL_SECONDARY_INVENTORIES

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

Line 422: FROM mtl_secondary_inventories

418: END IF;
419:
420: SELECT Decode(lpn_controlled_flag, 1, 'Y', 'N')
421: INTO x_is_lpn_controlled
422: FROM mtl_secondary_inventories
423: WHERE organization_id = p_organization_id
424: AND secondary_inventory_name = x_subinventory_code;
425: END IF;
426: