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

Line 55: FROM mtl_secondary_inventories

51:
52: -- get the sub type and based on it set the loc_type
53: SELECT nvl(subinventory_type,1)
54: INTO l_sub_type
55: FROM mtl_secondary_inventories
56: WHERE organization_id = p_org_id
57: AND secondary_inventory_name = p_sub_code;
58:
59: IF l_sub_type = 2 THEN

Line 170: FROM mtl_secondary_inventories msub

166: , msub.lpn_controlled_flag
167: , nvl(msub.subinventory_type, 1)
168: , msub.reservable_type
169: , msub.enable_locator_alias
170: FROM mtl_secondary_inventories msub
171: WHERE msub.organization_id = p_organization_id
172: AND Nvl(subinventory_type,1) = Decode(p_putaway_code,
173: 2, --Don't show any storage sub
174: -1,--if system suggested a RCV sub

Line 202: FROM mtl_secondary_inventories msub

198: , lpn_controlled_flag
199: , Nvl(subinventory_type, 1)
200: , reservable_type
201: , enable_locator_alias
202: FROM mtl_secondary_inventories msub
203: WHERE organization_id = p_organization_id
204: AND Nvl(subinventory_type,1) = Decode(p_putaway_code,
205: 2,--Only show rcv sub if the
206: 2,--system has suggested a rcv sub

Line 226: FROM mtl_secondary_inventories msub

222: , lpn_controlled_flag
223: , Nvl(subinventory_type, 1)
224: , reservable_type
225: , enable_locator_alias
226: FROM mtl_secondary_inventories msub
227: WHERE msub.organization_id = p_organization_id
228: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
229: AND msub.secondary_inventory_name LIKE (p_sub)
230: AND Nvl(msub.subinventory_type,1) = Decode(p_putaway_code,

Line 264: FROM mtl_secondary_inventories msub

260: , lpn_controlled_flag
261: , Nvl(subinventory_type, 1)
262: , reservable_type
263: , enable_locator_alias
264: FROM mtl_secondary_inventories msub
265: WHERE msub.organization_id = p_organization_id
266: AND Nvl(msub.subinventory_type,1) = Decode(p_putaway_code,
267: 2,--Only show rcv sub if the
268: 2,--system has suggested a rcv sub

Line 292: FROM mtl_secondary_inventories msub

288: , lpn_controlled_flag
289: , Nvl(subinventory_type, 1)
290: , reservable_type
291: , enable_locator_alias
292: FROM mtl_secondary_inventories msub
293: WHERE msub.organization_id = p_organization_id
294: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
295: AND msub.secondary_inventory_name LIKE (p_sub)
296: AND Nvl(msub.lpn_controlled_flag,-1) = Decode(p_lpn_context,

Line 333: FROM mtl_secondary_inventories msub

329: , lpn_controlled_flag
330: , Nvl(subinventory_type, 1)
331: , reservable_type
332: , enable_locator_alias
333: FROM mtl_secondary_inventories msub
334: WHERE msub.organization_id = p_organization_id
335: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
336: AND msub.secondary_inventory_name LIKE (p_sub)
337: AND Nvl(msub.lpn_controlled_flag,-1) = Decode(p_lpn_context,

Line 381: FROM mtl_secondary_inventories msub

377: , lpn_controlled_flag
378: , Nvl(subinventory_type, 1)
379: , reservable_type
380: , enable_locator_alias
381: FROM mtl_secondary_inventories msub
382: WHERE organization_id = p_organization_id
383: AND subinventory_type = 2
384: AND msub.secondary_inventory_name LIKE (p_sub)
385: AND location_id = p_location_id

Line 416: FROM mtl_secondary_inventories

412: , description
413: , asset_inventory
414: , lpn_controlled_flag
415: , enable_locator_alias
416: FROM mtl_secondary_inventories
417: WHERE organization_id = p_organization_id
418: AND secondary_inventory_name IN (
419: SELECT from_subinventory_code
420: FROM mtl_txn_request_lines

Line 451: FROM mtl_secondary_inventories

447: , description
448: , asset_inventory
449: , lpn_controlled_flag
450: , enable_locator_alias
451: FROM mtl_secondary_inventories
452: WHERE organization_id = p_organization_id
453: AND secondary_inventory_name IN (SELECT to_subinventory_code
454: FROM mtl_txn_request_lines
455: WHERE header_id = p_moheader_id)

Line 919: FROM mtl_secondary_inventories

915: END IF;
916:
917: SELECT NVL(default_loc_status_id, 1)
918: INTO l_sub_default_status
919: FROM mtl_secondary_inventories
920: WHERE organization_id = p_org_id
921: AND secondary_inventory_name = p_sub_code;
922:
923: l_wms_org := wms_install.check_install(x_return_status => l_return_status, x_msg_count => l_msg_count, x_msg_data => l_msg_data, p_organization_id => p_org_id);

Line 1256: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1252: , a.description
1253: , a.asset_inventory
1254: , a.lpn_controlled_flag
1255: , a.enable_locator_alias
1256: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1257: WHERE a.organization_id = p_organization_id
1258: AND a.organization_id = b.organization_id
1259: AND b.inventory_item_id = p_inventory_item_id
1260: AND a.secondary_inventory_name = b.secondary_inventory

Line 1272: FROM mtl_secondary_inventories

1268: , description
1269: , asset_inventory
1270: , lpn_controlled_flag
1271: , enable_locator_alias
1272: FROM mtl_secondary_inventories
1273: WHERE organization_id = p_organization_id
1274: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1275: AND secondary_inventory_name LIKE (p_secondary_inventory_name)
1276: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, secondary_inventory_name, NULL, NULL, NULL, 'Z') = 'Y';

Line 1287: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1283: , a.description
1284: , a.asset_inventory
1285: , a.lpn_controlled_flag
1286: , a.enable_locator_alias
1287: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1288: WHERE a.organization_id = p_organization_id
1289: AND a.organization_id = b.organization_id
1290: AND a.secondary_inventory_name = b.secondary_inventory
1291: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)

Line 1303: FROM mtl_secondary_inventories

1299: , description
1300: , asset_inventory
1301: , lpn_controlled_flag
1302: , enable_locator_alias
1303: FROM mtl_secondary_inventories
1304: WHERE organization_id = p_organization_id
1305: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1306: AND secondary_inventory_name LIKE (p_secondary_inventory_name)
1307: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, secondary_inventory_name, NULL, NULL, NULL, 'Z') = 'Y';

Line 1322: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1318: , a.description
1319: , a.asset_inventory
1320: , a.lpn_controlled_flag
1321: , a.enable_locator_alias
1322: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1323: WHERE a.organization_id = p_organization_id
1324: AND a.organization_id = b.organization_id
1325: AND a.secondary_inventory_name = b.secondary_inventory
1326: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)

Line 1338: FROM mtl_secondary_inventories

1334: , description
1335: , asset_inventory
1336: , lpn_controlled_flag
1337: , enable_locator_alias
1338: FROM mtl_secondary_inventories
1339: WHERE organization_id = p_organization_id
1340: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1341: AND secondary_inventory_name LIKE (p_secondary_inventory_name)
1342: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, secondary_inventory_name, NULL, NULL, NULL, 'Z') = 'Y';

Line 1353: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1349: , a.description
1350: , a.asset_inventory
1351: , a.lpn_controlled_flag
1352: , a.enable_locator_alias
1353: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1354: WHERE a.organization_id = p_organization_id
1355: AND a.organization_id = b.organization_id
1356: AND a.secondary_inventory_name = b.secondary_inventory
1357: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)

Line 1369: FROM mtl_secondary_inventories

1365: , description
1366: , asset_inventory
1367: , lpn_controlled_flag
1368: , enable_locator_alias
1369: FROM mtl_secondary_inventories
1370: WHERE organization_id = p_organization_id
1371: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1372: AND secondary_inventory_name LIKE (p_secondary_inventory_name)
1373: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, secondary_inventory_name, NULL, NULL, NULL, 'Z') = 'Y';

Line 1438: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1434: , a.description
1435: , a.asset_inventory
1436: , a.lpn_controlled_flag
1437: , a.enable_locator_alias
1438: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1439: WHERE a.organization_id = l_org
1440: AND a.organization_id = b.organization_id
1441: AND a.secondary_inventory_name = b.secondary_inventory
1442: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)

Line 1454: FROM mtl_secondary_inventories

1450: , description
1451: , asset_inventory
1452: , lpn_controlled_flag
1453: , enable_locator_alias
1454: FROM mtl_secondary_inventories
1455: WHERE organization_id = l_org
1456: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1457: AND secondary_inventory_name LIKE (p_secondary_inventory_name)
1458: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_to_organization_id, p_inventory_item_id, secondary_inventory_name, NULL, NULL, NULL, 'Z') = 'Y';

Line 1471: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1467: , a.description
1468: , a.asset_inventory
1469: , a.lpn_controlled_flag
1470: , a.enable_locator_alias
1471: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1472: WHERE a.organization_id = l_org
1473: AND a.organization_id = b.organization_id
1474: -- and a.asset_inventory = 1
1475: AND b.inventory_item_id = p_inventory_item_id

Line 1488: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1484: , a.description
1485: , a.asset_inventory
1486: , a.lpn_controlled_flag
1487: , a.enable_locator_alias
1488: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1489: WHERE a.organization_id = l_org
1490: AND a.organization_id = b.organization_id
1491: AND a.asset_inventory = 2
1492: AND b.inventory_item_id = p_inventory_item_id

Line 1506: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1502: , a.description
1503: , a.asset_inventory
1504: , a.lpn_controlled_flag
1505: , a.enable_locator_alias
1506: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1507: WHERE a.organization_id = l_org
1508: AND a.organization_id = b.organization_id
1509: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1510: AND a.secondary_inventory_name = b.secondary_inventory

Line 1525: FROM mtl_secondary_inventories

1521: , description
1522: , asset_inventory
1523: , lpn_controlled_flag
1524: , enable_locator_alias
1525: FROM mtl_secondary_inventories
1526: WHERE organization_id = l_org
1527: --and asset_inventory = 1
1528: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1529: AND secondary_inventory_name LIKE (p_secondary_inventory_name)

Line 1539: FROM mtl_secondary_inventories

1535: , description
1536: , asset_inventory
1537: , lpn_controlled_flag
1538: , enable_locator_alias
1539: FROM mtl_secondary_inventories
1540: WHERE organization_id = l_org
1541: AND asset_inventory = 2
1542: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1543: AND secondary_inventory_name LIKE (p_secondary_inventory_name)

Line 1554: FROM mtl_secondary_inventories

1550: , description
1551: , asset_inventory
1552: , lpn_controlled_flag
1553: , enable_locator_alias
1554: FROM mtl_secondary_inventories
1555: WHERE organization_id = l_org
1556: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1557: AND secondary_inventory_name LIKE (p_secondary_inventory_name)
1558: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_to_organization_id, p_inventory_item_id, secondary_inventory_name, NULL, NULL, NULL, 'Z') = 'Y';

Line 1582: FROM mtl_secondary_inventories

1578: , description
1579: , asset_inventory
1580: , lpn_controlled_flag
1581: , enable_locator_alias
1582: FROM mtl_secondary_inventories
1583: WHERE organization_id = NVL(p_organization_id, organization_id)
1584: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1585: AND secondary_inventory_name LIKE (p_subinventory_code)
1586: ORDER BY secondary_inventory_name;

Line 1595: FROM mtl_secondary_inventories

1591: , description
1592: , asset_inventory
1593: , lpn_controlled_flag
1594: , enable_locator_alias
1595: FROM mtl_secondary_inventories
1596: WHERE organization_id = p_organization_id
1597: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1598: AND secondary_inventory_name LIKE (p_subinventory_code)
1599: ORDER BY secondary_inventory_name;

Line 1623: FROM mtl_secondary_inventories

1619: , description
1620: , asset_inventory
1621: , lpn_controlled_flag
1622: , enable_locator_alias
1623: FROM mtl_secondary_inventories
1624: WHERE organization_id = NVL(p_organization_id, organization_id)
1625: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1626: AND secondary_inventory_name LIKE (p_subinventory_code)
1627: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, NULL, NULL, p_organization_id, NULL, secondary_inventory_name, NULL, NULL, NULL, 'Z') = 'Y'

Line 1637: FROM mtl_secondary_inventories

1633: , description
1634: , asset_inventory
1635: , lpn_controlled_flag
1636: , enable_locator_alias
1637: FROM mtl_secondary_inventories
1638: WHERE organization_id = p_organization_id
1639: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1640: AND secondary_inventory_name LIKE (p_subinventory_code)
1641: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, NULL, NULL, p_organization_id, NULL, secondary_inventory_name, NULL, NULL, NULL, 'Z') = 'Y'

Line 1664: FROM mtl_secondary_inventories

1660: */
1661:
1662: SELECT locator_type
1663: INTO loc_control
1664: FROM mtl_secondary_inventories
1665: WHERE organization_id = p_organization_id
1666: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1667: AND secondary_inventory_name = p_subinventory_code;
1668:

Line 1700: FROM mtl_secondary_inventories msi, mtl_material_statuses_vl mmsv

1696: , asset_inventory
1697: , mmsv.status_id
1698: , status_code
1699: , enable_locator_alias
1700: FROM mtl_secondary_inventories msi, mtl_material_statuses_vl mmsv
1701: WHERE organization_id = p_organization_id
1702: AND mmsv.status_id = msi.status_id
1703: AND NVL(msi.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1704: AND secondary_inventory_name LIKE (p_subinventory_code);

Line 1726: FROM mtl_secondary_inventories msub

1722: , msub.description
1723: , msub.asset_inventory
1724: , msub.lpn_controlled_flag
1725: , msub.enable_locator_alias
1726: FROM mtl_secondary_inventories msub
1727: WHERE msub.organization_id = p_organization_id
1728: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1729: AND EXISTS( SELECT wda.staging_lane_id
1730: FROM wms_dock_appointments_b wda, mtl_item_locations milk, wsh_trip_stops pickup_stop

Line 1746: FROM mtl_secondary_inventories msub

1742: , msub.description
1743: , msub.asset_inventory
1744: , lpn_controlled_flag
1745: , enable_locator_alias
1746: FROM mtl_secondary_inventories msub
1747: WHERE msub.organization_id = p_organization_id
1748: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1749: AND EXISTS( SELECT milk.inventory_location_id
1750: FROM mtl_item_locations milk, wms_license_plate_numbers lpn

Line 1771: FROM mtl_secondary_inventories

1767: , locator_type
1768: , description
1769: , asset_inventory
1770: , lpn_controlled_flag
1771: FROM mtl_secondary_inventories
1772: WHERE organization_id = p_organization_id
1773: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1774: AND secondary_inventory_name LIKE (p_subinventory_code)
1775: ORDER BY secondary_inventory_name;

Line 1827: -- FROM mtl_secondary_inventories msub

1823: -- , Nvl(msub.locator_type, 1)
1824: -- , msub.description
1825: -- , msub.asset_inventory
1826: -- , msub.lpn_controlled_flag
1827: -- FROM mtl_secondary_inventories msub
1828: -- WHERE msub.organization_id = p_organization_id
1829: -- AND nvl(msub.disable_date, trunc(sysdate+1)) > trunc(sysdate)
1830: -- AND msub.secondary_inventory_name LIKE (p_subinventory_code || '%')
1831: -- ORDER BY UPPER(msub.secondary_inventory_name);

Line 1845: FROM mtl_secondary_inventories msub

1841: , msub.description
1842: , msub.asset_inventory
1843: , msub.lpn_controlled_flag
1844: , msub.enable_locator_alias
1845: FROM mtl_secondary_inventories msub
1846: WHERE msub.organization_id = p_organization_id
1847: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1848: AND msub.secondary_inventory_name LIKE (p_subinventory_code)
1849: ORDER BY UPPER(msub.secondary_inventory_name);

Line 1860: FROM mtl_secondary_inventories msub, mtl_physical_subinventories mpsub

1856: , msub.description
1857: , msub.asset_inventory
1858: , msub.lpn_controlled_flag
1859: , msub.enable_locator_alias
1860: FROM mtl_secondary_inventories msub, mtl_physical_subinventories mpsub
1861: WHERE msub.organization_id = p_organization_id
1862: AND mpsub.organization_id = p_organization_id
1863: AND mpsub.subinventory = msub.secondary_inventory_name
1864: AND mpsub.physical_inventory_id = p_physical_inventory_id

Line 2066: FROM mtl_secondary_inventories msub

2062: , msub.description
2063: , msub.asset_inventory
2064: , msub.lpn_controlled_flag
2065: , msub.enable_locator_alias
2066: FROM mtl_secondary_inventories msub
2067: WHERE msub.organization_id = p_organization_id
2068: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2069: AND msub.secondary_inventory_name LIKE (p_subinventory_code)
2070: -- Bug# 2770853

Line 2095: FROM mtl_secondary_inventories msub, mtl_cc_subinventories mccs

2091: , msub.description
2092: , msub.asset_inventory
2093: , msub.lpn_controlled_flag
2094: , msub.enable_locator_alias
2095: FROM mtl_secondary_inventories msub, mtl_cc_subinventories mccs
2096: WHERE msub.organization_id = p_organization_id
2097: AND mccs.cycle_count_header_id = p_cycle_count_header_id
2098: AND mccs.subinventory = msub.secondary_inventory_name
2099: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)

Line 2534: FROM wms_license_plate_numbers a, mtl_secondary_inventories b

2530: , inv_project.get_project_id
2531: , inv_project.get_project_number
2532: , inv_project.get_task_id
2533: , inv_project.get_task_number
2534: FROM wms_license_plate_numbers a, mtl_secondary_inventories b
2535: WHERE a.organization_id = p_organization_id
2536: AND (a.lpn_context = 1 OR a.lpn_context = 11)
2537: AND b.organization_id(+) = a.organization_id
2538: AND b.secondary_inventory_name(+) = a.subinventory_code

Line 2587: FROM wms_license_plate_numbers a, mtl_secondary_inventories b

2583: , inv_project.get_project_id
2584: , inv_project.get_project_number
2585: , inv_project.get_task_id
2586: , inv_project.get_task_number
2587: FROM wms_license_plate_numbers a, mtl_secondary_inventories b
2588: WHERE a.organization_id = p_organization_id
2589: AND (a.lpn_context = 1 OR a.lpn_context = 11)
2590: AND b.organization_id(+) = a.organization_id
2591: AND b.secondary_inventory_name(+) = a.subinventory_code

Line 2802: FROM mtl_secondary_inventories

2798: , description
2799: , asset_inventory
2800: , lpn_controlled_flag
2801: , enable_locator_alias
2802: FROM mtl_secondary_inventories
2803: WHERE organization_id = l_org
2804: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2805: AND inv_ui_item_sub_loc_lovs.vaildate_to_lpn_sub(p_lpn_id, secondary_inventory_name, l_org, p_from_sub_asset_inventory, p_wms_installed, p_transaction_type_id) = 'Y'
2806: AND secondary_inventory_name LIKE (p_secondary_inventory_name);

Line 2815: FROM mtl_secondary_inventories

2811: , description
2812: , asset_inventory
2813: , lpn_controlled_flag
2814: , enable_locator_alias
2815: FROM mtl_secondary_inventories
2816: WHERE organization_id = l_org
2817: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2818: AND inv_ui_item_sub_loc_lovs.vaildate_to_lpn_sub(p_lpn_id, secondary_inventory_name, l_org, p_from_sub_asset_inventory, p_wms_installed, p_transaction_type_id) = 'Y'
2819: AND secondary_inventory_name LIKE (p_secondary_inventory_name)

Line 3207: FROM mtl_secondary_inventories msi, MTL_ONHAND_QUANTITIES_DETAIL moq

3203: , msi.description
3204: , '0'
3205: , msi.lpn_controlled_flag
3206: , msi.enable_locator_alias
3207: FROM mtl_secondary_inventories msi, MTL_ONHAND_QUANTITIES_DETAIL moq
3208: WHERE msi.secondary_inventory_name = moq.subinventory_code
3209: AND msi.organization_id = moq.organization_id
3210: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, 86, NULL, NULL, p_organization_id, p_inventory_item_id, moq.subinventory_code, NULL, NULL, NULL, 'Z') = 'Y'
3211: AND moq.containerized_flag = 2

Line 3344: FROM mtl_secondary_inventories

3340: , description
3341: , asset_inventory
3342: , 0 dummy
3343: , enable_locator_alias
3344: FROM mtl_secondary_inventories
3345: WHERE organization_id = NVL(p_organization_id, organization_id)
3346: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3347: AND secondary_inventory_name LIKE (p_subinventory_code)
3348: UNION ALL

Line 3366: FROM mtl_secondary_inventories

3362: , description
3363: , asset_inventory
3364: , 0 dummy
3365: , enable_locator_alias
3366: FROM mtl_secondary_inventories
3367: WHERE organization_id = p_organization_id
3368: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3369: AND secondary_inventory_name LIKE (p_subinventory_code)
3370: UNION ALL

Line 3596: FROM mtl_secondary_inventories

3592: , description
3593: , asset_inventory
3594: , lpn_controlled_flag
3595: , enable_locator_alias
3596: FROM mtl_secondary_inventories
3597: WHERE organization_id = NVL(p_organization_id, organization_id)
3598: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3599: AND secondary_inventory_name LIKE (p_subinventory_code)
3600: AND lpn_controlled_flag = 1

Line 3611: FROM mtl_secondary_inventories

3607: , description
3608: , asset_inventory
3609: , lpn_controlled_flag
3610: , enable_locator_alias
3611: FROM mtl_secondary_inventories
3612: WHERE organization_id = p_organization_id
3613: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3614: AND secondary_inventory_name LIKE (p_subinventory_code)
3615: AND lpn_controlled_flag = 1

Line 3660: FROM mtl_secondary_inventories

3656:
3657: BEGIN
3658: SELECT Nvl(subinventory_type,1)
3659: INTO l_sub_type
3660: FROM mtl_secondary_inventories
3661: WHERE secondary_inventory_name = p_subinventory_code
3662: AND organization_id = p_organization_id;
3663: EXCEPTION
3664: WHEN OTHERS THEN

Line 3843: FROM mtl_secondary_inventories

3839:
3840: BEGIN
3841: SELECT Nvl(subinventory_type,1)
3842: INTO l_sub_type
3843: FROM mtl_secondary_inventories
3844: WHERE secondary_inventory_name = p_subinventory_code
3845: AND organization_id = p_organization_id;
3846: EXCEPTION
3847: WHEN OTHERS THEN

Line 4189: FROM mtl_secondary_inventories

4185: , lpn_controlled_flag
4186: , Nvl(subinventory_type,1)
4187: , reservable_type
4188: , enable_locator_alias
4189: FROM mtl_secondary_inventories
4190: WHERE organization_id = p_organization_id
4191: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4192: AND secondary_inventory_name LIKE (p_subinventory_code)
4193: AND inv_ui_item_sub_loc_lovs.validate_lpn_sub(p_organization_id,

Line 4205: FROM mtl_secondary_inventories msub

4201: , lpn_controlled_flag
4202: , Nvl(subinventory_type,1)
4203: , reservable_type
4204: , enable_locator_alias
4205: FROM mtl_secondary_inventories msub
4206: WHERE organization_id = p_organization_id
4207: AND Nvl(subinventory_type,1) = 2
4208: AND msub.secondary_inventory_name LIKE (p_subinventory_code)
4209: AND (trunc(disable_date + (300*365)) >= trunc(SYSDATE) OR

Line 4223: FROM mtl_secondary_inventories msub

4219: , lpn_controlled_flag
4220: , Nvl(subinventory_type,1)
4221: , reservable_type
4222: , enable_locator_alias
4223: FROM mtl_secondary_inventories msub
4224: WHERE organization_id = p_organization_id
4225: AND Nvl(subinventory_type,1) = 2
4226: AND msub.secondary_inventory_name LIKE (p_subinventory_code)
4227: AND (trunc(disable_date + (300*365)) >= trunc(SYSDATE) OR

Line 4241: FROM mtl_secondary_inventories

4237: , lpn_controlled_flag
4238: , Nvl(subinventory_type,1)
4239: , reservable_type
4240: , enable_locator_alias
4241: FROM mtl_secondary_inventories
4242: WHERE organization_id = p_organization_id
4243: AND Nvl(subinventory_type,1) = 1
4244: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4245: AND secondary_inventory_name LIKE (p_subinventory_code)

Line 4261: FROM mtl_secondary_inventories

4257: , lpn_controlled_flag
4258: , Nvl(subinventory_type,1)
4259: , reservable_type
4260: , enable_locator_alias
4261: FROM mtl_secondary_inventories
4262: WHERE organization_id = p_organization_id
4263: AND Nvl(subinventory_type,1) = 1
4264: AND lpn_controlled_flag = 1
4265: AND reservable_type = 1

Line 4282: FROM mtl_secondary_inventories

4278: , lpn_controlled_flag
4279: , Nvl(subinventory_type,1)
4280: , reservable_type
4281: , enable_locator_alias
4282: FROM mtl_secondary_inventories
4283: WHERE organization_id = p_organization_id
4284: AND Nvl(subinventory_type,1) = 1
4285: AND lpn_controlled_flag = 2
4286: AND reservable_type = 2

Line 4304: FROM mtl_secondary_inventories

4300: , lpn_controlled_flag
4301: , Nvl(subinventory_type,1)
4302: , reservable_type
4303: , enable_locator_alias
4304: FROM mtl_secondary_inventories
4305: WHERE organization_id = p_organization_id
4306: AND Nvl(subinventory_type,1) = 1
4307: AND lpn_controlled_flag = 1
4308: AND reservable_type = 1

Line 4323: FROM mtl_secondary_inventories msub

4319: , lpn_controlled_flag
4320: , Nvl(subinventory_type,1)
4321: , reservable_type
4322: , enable_locator_alias
4323: FROM mtl_secondary_inventories msub
4324: WHERE organization_id = p_organization_id
4325: AND Nvl(subinventory_type,1) = 2
4326: AND msub.secondary_inventory_name LIKE (p_subinventory_code)
4327: AND (trunc(disable_date + (300*365)) >= trunc(SYSDATE) OR

Line 4341: FROM mtl_secondary_inventories

4337: , lpn_controlled_flag
4338: , Nvl(subinventory_type,1)
4339: , reservable_type
4340: , enable_locator_alias
4341: FROM mtl_secondary_inventories
4342: WHERE organization_id = p_organization_id
4343: AND Nvl(subinventory_type,1) = 1
4344: AND lpn_controlled_flag = 2
4345: AND reservable_type = 2

Line 4360: FROM mtl_secondary_inventories msub

4356: , lpn_controlled_flag
4357: , Nvl(subinventory_type,1)
4358: , reservable_type
4359: , enable_locator_alias
4360: FROM mtl_secondary_inventories msub
4361: WHERE organization_id = p_organization_id
4362: AND Nvl(subinventory_type,1) = 2
4363: AND msub.secondary_inventory_name LIKE (p_subinventory_code)
4364: AND (trunc(disable_date + (300*365)) >= trunc(SYSDATE) OR

Line 4379: FROM mtl_secondary_inventories

4375: , lpn_controlled_flag
4376: , Nvl(subinventory_type,1)
4377: , reservable_type
4378: , enable_locator_alias
4379: FROM mtl_secondary_inventories
4380: WHERE organization_id = p_organization_id
4381: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4382: AND secondary_inventory_name LIKE (p_subinventory_code)
4383: AND inv_ui_item_sub_loc_lovs.validate_lpn_sub(p_organization_id,

Line 4609: FROM mtl_secondary_inventories

4605: -- get the sub type and based on it set the loc_type
4606: BEGIN
4607: SELECT nvl(subinventory_type,1)
4608: INTO l_sub_type
4609: FROM mtl_secondary_inventories
4610: WHERE organization_id = p_organization_id
4611: AND secondary_inventory_name = p_subinventory_code;
4612: EXCEPTION
4613: WHEN OTHERS THEN