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 94: FROM mtl_secondary_inventories

90: IF NVL(l_loc_type,0) = 0 THEN
91: -- get the sub type and based on it set the loc_type
92: SELECT NVL(subinventory_type,1)
93: INTO l_sub_type
94: FROM mtl_secondary_inventories
95: WHERE organization_id = p_org_id
96: AND secondary_inventory_name = p_sub_code;
97:
98: IF l_sub_type = 2 THEN

Line 224: FROM mtl_secondary_inventories msub

220: , msub.lpn_controlled_flag
221: , nvl(msub.subinventory_type, 1)
222: , msub.reservable_type
223: , msub.enable_locator_alias
224: FROM mtl_secondary_inventories msub
225: WHERE msub.organization_id = p_organization_id
226: AND Nvl(subinventory_type,1) = Decode(p_putaway_code,
227: 2, --Don't show any storage sub
228: -1,--if system suggested a RCV sub

Line 256: FROM mtl_secondary_inventories msub

252: , lpn_controlled_flag
253: , Nvl(subinventory_type, 1)
254: , reservable_type
255: , enable_locator_alias
256: FROM mtl_secondary_inventories msub
257: WHERE organization_id = p_organization_id
258: AND Nvl(subinventory_type,1) = Decode(p_putaway_code,
259: 2,--Only show rcv sub if the
260: 2,--system has suggested a rcv sub

Line 280: FROM mtl_secondary_inventories msub

276: , lpn_controlled_flag
277: , Nvl(subinventory_type, 1)
278: , reservable_type
279: , enable_locator_alias
280: FROM mtl_secondary_inventories msub
281: WHERE msub.organization_id = p_organization_id
282: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
283: AND msub.secondary_inventory_name LIKE (p_sub)
284: AND Nvl(msub.subinventory_type,1) = Decode(p_putaway_code,

Line 318: FROM mtl_secondary_inventories msub

314: , lpn_controlled_flag
315: , Nvl(subinventory_type, 1)
316: , reservable_type
317: , enable_locator_alias
318: FROM mtl_secondary_inventories msub
319: WHERE msub.organization_id = p_organization_id
320: AND Nvl(msub.subinventory_type,1) = Decode(p_putaway_code,
321: 2,--Only show rcv sub if the
322: 2,--system has suggested a rcv sub

Line 346: FROM mtl_secondary_inventories msub

342: , lpn_controlled_flag
343: , Nvl(subinventory_type, 1)
344: , reservable_type
345: , enable_locator_alias
346: FROM mtl_secondary_inventories msub
347: WHERE msub.organization_id = p_organization_id
348: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
349: AND msub.secondary_inventory_name LIKE (p_sub)
350: AND Nvl(msub.lpn_controlled_flag,-1) = Decode(p_lpn_context,

Line 387: FROM mtl_secondary_inventories msub

383: , lpn_controlled_flag
384: , Nvl(subinventory_type, 1)
385: , reservable_type
386: , enable_locator_alias
387: FROM mtl_secondary_inventories msub
388: WHERE msub.organization_id = p_organization_id
389: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
390: AND msub.secondary_inventory_name LIKE (p_sub)
391: AND Nvl(msub.lpn_controlled_flag,-1) = Decode(p_lpn_context,

Line 435: FROM mtl_secondary_inventories msub

431: , lpn_controlled_flag
432: , Nvl(subinventory_type, 1)
433: , reservable_type
434: , enable_locator_alias
435: FROM mtl_secondary_inventories msub
436: WHERE organization_id = p_organization_id
437: AND subinventory_type = 2
438: AND msub.secondary_inventory_name LIKE (p_sub)
439: AND location_id = p_location_id

Line 493: FROM mtl_secondary_inventories msub

489: , msub.lpn_controlled_flag
490: , nvl(msub.subinventory_type, 1)
491: , msub.reservable_type
492: , msub.enable_locator_alias
493: FROM mtl_secondary_inventories msub
494: WHERE msub.organization_id = p_organization_id
495: AND Nvl(subinventory_type,1) = Decode(p_putaway_code,
496: 2, --Don't show any storage sub
497: -1,--if system suggested a RCV sub

Line 525: FROM mtl_secondary_inventories msub

521: , lpn_controlled_flag
522: , Nvl(subinventory_type, 1)
523: , reservable_type
524: , enable_locator_alias
525: FROM mtl_secondary_inventories msub
526: WHERE organization_id = p_organization_id
527: AND Nvl(subinventory_type,1) = Decode(p_putaway_code,
528: 2,--Only show rcv sub if the
529: 2,--system has suggested a rcv sub

Line 549: FROM mtl_secondary_inventories msub

545: , lpn_controlled_flag
546: , Nvl(subinventory_type, 1)
547: , reservable_type
548: , enable_locator_alias
549: FROM mtl_secondary_inventories msub
550: WHERE msub.organization_id = p_organization_id
551: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
552: AND msub.secondary_inventory_name LIKE (p_sub)
553: AND Nvl(msub.subinventory_type,1) = Decode(p_putaway_code,

Line 587: FROM mtl_secondary_inventories msub

583: , lpn_controlled_flag
584: , Nvl(subinventory_type, 1)
585: , reservable_type
586: , enable_locator_alias
587: FROM mtl_secondary_inventories msub
588: WHERE msub.organization_id = p_organization_id
589: AND Nvl(msub.subinventory_type,1) = Decode(p_putaway_code,
590: 2,--Only show rcv sub if the
591: 2,--system has suggested a rcv sub

Line 615: FROM mtl_secondary_inventories msub

611: , lpn_controlled_flag
612: , Nvl(subinventory_type, 1)
613: , reservable_type
614: , enable_locator_alias
615: FROM mtl_secondary_inventories msub
616: WHERE msub.organization_id = p_organization_id
617: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
618: AND msub.secondary_inventory_name LIKE (p_sub)
619: AND Nvl(msub.lpn_controlled_flag,-1) = Decode(p_lpn_context,

Line 656: FROM mtl_secondary_inventories msub

652: , lpn_controlled_flag
653: , Nvl(subinventory_type, 1)
654: , reservable_type
655: , enable_locator_alias
656: FROM mtl_secondary_inventories msub
657: WHERE msub.organization_id = p_organization_id
658: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
659: AND msub.secondary_inventory_name LIKE (p_sub)
660: AND Nvl(msub.lpn_controlled_flag,-1) = Decode(p_lpn_context,

Line 704: FROM mtl_secondary_inventories msub

700: , lpn_controlled_flag
701: , Nvl(subinventory_type, 1)
702: , reservable_type
703: , enable_locator_alias
704: FROM mtl_secondary_inventories msub
705: WHERE organization_id = p_organization_id
706: AND subinventory_type = 2
707: AND msub.secondary_inventory_name LIKE (p_sub)
708: AND ((location_id = p_location_id) OR (location_id IN (SELECT distinct(hl.location_id)

Line 747: FROM mtl_secondary_inventories

743: , description
744: , asset_inventory
745: , lpn_controlled_flag
746: , enable_locator_alias
747: FROM mtl_secondary_inventories
748: WHERE organization_id = p_organization_id
749: AND secondary_inventory_name IN (
750: SELECT from_subinventory_code
751: FROM mtl_txn_request_lines

Line 782: FROM mtl_secondary_inventories

778: , description
779: , asset_inventory
780: , lpn_controlled_flag
781: , enable_locator_alias
782: FROM mtl_secondary_inventories
783: WHERE organization_id = p_organization_id
784: AND secondary_inventory_name IN (SELECT to_subinventory_code
785: FROM mtl_txn_request_lines
786: WHERE header_id = p_moheader_id)

Line 1256: FROM mtl_secondary_inventories

1252: END IF;
1253:
1254: SELECT NVL(default_loc_status_id, 1)
1255: INTO l_sub_default_status
1256: FROM mtl_secondary_inventories
1257: WHERE organization_id = p_org_id
1258: AND secondary_inventory_name = p_sub_code;
1259:
1260: 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 1631: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1627: , a.description
1628: , a.asset_inventory
1629: , a.lpn_controlled_flag
1630: , a.enable_locator_alias
1631: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1632: WHERE a.organization_id = p_organization_id
1633: AND a.organization_id = b.organization_id
1634: AND b.inventory_item_id = p_inventory_item_id
1635: AND a.secondary_inventory_name = b.secondary_inventory

Line 1647: FROM mtl_secondary_inventories

1643: , description
1644: , asset_inventory
1645: , lpn_controlled_flag
1646: , enable_locator_alias
1647: FROM mtl_secondary_inventories
1648: WHERE organization_id = p_organization_id
1649: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1650: AND secondary_inventory_name LIKE (p_secondary_inventory_name)
1651: 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 1662: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1658: , a.description
1659: , a.asset_inventory
1660: , a.lpn_controlled_flag
1661: , a.enable_locator_alias
1662: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1663: WHERE a.organization_id = p_organization_id
1664: AND a.organization_id = b.organization_id
1665: AND a.secondary_inventory_name = b.secondary_inventory
1666: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)

Line 1678: FROM mtl_secondary_inventories

1674: , description
1675: , asset_inventory
1676: , lpn_controlled_flag
1677: , enable_locator_alias
1678: FROM mtl_secondary_inventories
1679: WHERE organization_id = p_organization_id
1680: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1681: AND secondary_inventory_name LIKE (p_secondary_inventory_name)
1682: 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 1697: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1693: , a.description
1694: , a.asset_inventory
1695: , a.lpn_controlled_flag
1696: , a.enable_locator_alias
1697: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1698: WHERE a.organization_id = p_organization_id
1699: AND a.organization_id = b.organization_id
1700: AND a.secondary_inventory_name = b.secondary_inventory
1701: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)

Line 1713: FROM mtl_secondary_inventories

1709: , description
1710: , asset_inventory
1711: , lpn_controlled_flag
1712: , enable_locator_alias
1713: FROM mtl_secondary_inventories
1714: WHERE organization_id = p_organization_id
1715: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1716: AND secondary_inventory_name LIKE (p_secondary_inventory_name)
1717: 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 1728: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1724: , a.description
1725: , a.asset_inventory
1726: , a.lpn_controlled_flag
1727: , a.enable_locator_alias
1728: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1729: WHERE a.organization_id = p_organization_id
1730: AND a.organization_id = b.organization_id
1731: AND a.secondary_inventory_name = b.secondary_inventory
1732: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)

Line 1744: FROM mtl_secondary_inventories

1740: , description
1741: , asset_inventory
1742: , lpn_controlled_flag
1743: , enable_locator_alias
1744: FROM mtl_secondary_inventories
1745: WHERE organization_id = p_organization_id
1746: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1747: AND secondary_inventory_name LIKE (p_secondary_inventory_name)
1748: 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 1813: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1809: , a.description
1810: , a.asset_inventory
1811: , a.lpn_controlled_flag
1812: , a.enable_locator_alias
1813: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1814: WHERE a.organization_id = l_org
1815: AND a.organization_id = b.organization_id
1816: AND a.secondary_inventory_name = b.secondary_inventory
1817: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)

Line 1829: FROM mtl_secondary_inventories

1825: , description
1826: , asset_inventory
1827: , lpn_controlled_flag
1828: , enable_locator_alias
1829: FROM mtl_secondary_inventories
1830: WHERE organization_id = l_org
1831: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1832: AND secondary_inventory_name LIKE (p_secondary_inventory_name)
1833: 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 1846: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1842: , a.description
1843: , a.asset_inventory
1844: , a.lpn_controlled_flag
1845: , a.enable_locator_alias
1846: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1847: WHERE a.organization_id = l_org
1848: AND a.organization_id = b.organization_id
1849: -- and a.asset_inventory = 1
1850: AND b.inventory_item_id = p_inventory_item_id

Line 1863: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1859: , a.description
1860: , a.asset_inventory
1861: , a.lpn_controlled_flag
1862: , a.enable_locator_alias
1863: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1864: WHERE a.organization_id = l_org
1865: AND a.organization_id = b.organization_id
1866: AND a.asset_inventory = 2
1867: AND b.inventory_item_id = p_inventory_item_id

Line 1881: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1877: , a.description
1878: , a.asset_inventory
1879: , a.lpn_controlled_flag
1880: , a.enable_locator_alias
1881: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1882: WHERE a.organization_id = l_org
1883: AND a.organization_id = b.organization_id
1884: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1885: AND a.secondary_inventory_name = b.secondary_inventory

Line 1900: FROM mtl_secondary_inventories

1896: , description
1897: , asset_inventory
1898: , lpn_controlled_flag
1899: , enable_locator_alias
1900: FROM mtl_secondary_inventories
1901: WHERE organization_id = l_org
1902: --and asset_inventory = 1
1903: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1904: AND secondary_inventory_name LIKE (p_secondary_inventory_name)

Line 1914: FROM mtl_secondary_inventories

1910: , description
1911: , asset_inventory
1912: , lpn_controlled_flag
1913: , enable_locator_alias
1914: FROM mtl_secondary_inventories
1915: WHERE organization_id = l_org
1916: AND asset_inventory = 2
1917: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1918: AND secondary_inventory_name LIKE (p_secondary_inventory_name)

Line 1929: FROM mtl_secondary_inventories

1925: , description
1926: , asset_inventory
1927: , lpn_controlled_flag
1928: , enable_locator_alias
1929: FROM mtl_secondary_inventories
1930: WHERE organization_id = l_org
1931: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1932: AND secondary_inventory_name LIKE (p_secondary_inventory_name)
1933: 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 1957: FROM mtl_secondary_inventories

1953: , description
1954: , asset_inventory
1955: , lpn_controlled_flag
1956: , enable_locator_alias
1957: FROM mtl_secondary_inventories
1958: WHERE organization_id = NVL(p_organization_id, organization_id)
1959: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1960: AND secondary_inventory_name LIKE (p_subinventory_code)
1961: ORDER BY secondary_inventory_name;

Line 1970: FROM mtl_secondary_inventories

1966: , description
1967: , asset_inventory
1968: , lpn_controlled_flag
1969: , enable_locator_alias
1970: FROM mtl_secondary_inventories
1971: WHERE organization_id = p_organization_id
1972: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1973: AND secondary_inventory_name LIKE (p_subinventory_code)
1974: ORDER BY secondary_inventory_name;

Line 1998: FROM mtl_secondary_inventories

1994: , description
1995: , asset_inventory
1996: , lpn_controlled_flag
1997: , enable_locator_alias
1998: FROM mtl_secondary_inventories
1999: WHERE organization_id = NVL(p_organization_id, organization_id)
2000: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2001: AND secondary_inventory_name LIKE (p_subinventory_code)
2002: 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 2012: FROM mtl_secondary_inventories

2008: , description
2009: , asset_inventory
2010: , lpn_controlled_flag
2011: , enable_locator_alias
2012: FROM mtl_secondary_inventories
2013: WHERE organization_id = p_organization_id
2014: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2015: AND secondary_inventory_name LIKE (p_subinventory_code)
2016: 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 2039: FROM mtl_secondary_inventories

2035: */
2036:
2037: SELECT locator_type
2038: INTO loc_control
2039: FROM mtl_secondary_inventories
2040: WHERE organization_id = p_organization_id
2041: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2042: AND secondary_inventory_name = p_subinventory_code;
2043:

Line 2075: FROM mtl_secondary_inventories msi, mtl_material_statuses_vl mmsv

2071: , asset_inventory
2072: , mmsv.status_id
2073: , status_code
2074: , enable_locator_alias
2075: FROM mtl_secondary_inventories msi, mtl_material_statuses_vl mmsv
2076: WHERE organization_id = p_organization_id
2077: AND mmsv.status_id = msi.status_id
2078: AND NVL(msi.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2079: AND secondary_inventory_name LIKE (p_subinventory_code);

Line 2101: FROM mtl_secondary_inventories msub

2097: , msub.description
2098: , msub.asset_inventory
2099: , msub.lpn_controlled_flag
2100: , msub.enable_locator_alias
2101: FROM mtl_secondary_inventories msub
2102: WHERE msub.organization_id = p_organization_id
2103: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2104: AND EXISTS( SELECT wda.staging_lane_id
2105: FROM wms_dock_appointments_b wda, mtl_item_locations milk, wsh_trip_stops pickup_stop

Line 2121: FROM mtl_secondary_inventories msub

2117: , msub.description
2118: , msub.asset_inventory
2119: , lpn_controlled_flag
2120: , enable_locator_alias
2121: FROM mtl_secondary_inventories msub
2122: WHERE msub.organization_id = p_organization_id
2123: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2124: AND EXISTS( SELECT milk.inventory_location_id
2125: FROM mtl_item_locations milk, wms_license_plate_numbers lpn

Line 2146: FROM mtl_secondary_inventories

2142: , locator_type
2143: , description
2144: , asset_inventory
2145: , lpn_controlled_flag
2146: FROM mtl_secondary_inventories
2147: WHERE organization_id = p_organization_id
2148: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2149: AND secondary_inventory_name LIKE (p_subinventory_code)
2150: ORDER BY secondary_inventory_name;

Line 2202: -- FROM mtl_secondary_inventories msub

2198: -- , Nvl(msub.locator_type, 1)
2199: -- , msub.description
2200: -- , msub.asset_inventory
2201: -- , msub.lpn_controlled_flag
2202: -- FROM mtl_secondary_inventories msub
2203: -- WHERE msub.organization_id = p_organization_id
2204: -- AND nvl(msub.disable_date, trunc(sysdate+1)) > trunc(sysdate)
2205: -- AND msub.secondary_inventory_name LIKE (p_subinventory_code || '%')
2206: -- ORDER BY UPPER(msub.secondary_inventory_name);

Line 2220: FROM mtl_secondary_inventories msub

2216: , msub.description
2217: , msub.asset_inventory
2218: , msub.lpn_controlled_flag
2219: , msub.enable_locator_alias
2220: FROM mtl_secondary_inventories msub
2221: WHERE msub.organization_id = p_organization_id
2222: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2223: AND msub.secondary_inventory_name LIKE (p_subinventory_code)
2224: ORDER BY UPPER(msub.secondary_inventory_name);

Line 2235: FROM mtl_secondary_inventories msub, mtl_physical_subinventories mpsub

2231: , msub.description
2232: , msub.asset_inventory
2233: , msub.lpn_controlled_flag
2234: , msub.enable_locator_alias
2235: FROM mtl_secondary_inventories msub, mtl_physical_subinventories mpsub
2236: WHERE msub.organization_id = p_organization_id
2237: AND mpsub.organization_id = p_organization_id
2238: AND mpsub.subinventory = msub.secondary_inventory_name
2239: AND mpsub.physical_inventory_id = p_physical_inventory_id

Line 2443: FROM mtl_secondary_inventories msub

2439: , msub.description
2440: , msub.asset_inventory
2441: , msub.lpn_controlled_flag
2442: , msub.enable_locator_alias
2443: FROM mtl_secondary_inventories msub
2444: WHERE msub.organization_id = p_organization_id
2445: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2446: AND msub.secondary_inventory_name LIKE (p_subinventory_code)
2447: -- Bug# 2770853

Line 2472: FROM mtl_secondary_inventories msub, mtl_cc_subinventories mccs

2468: , msub.description
2469: , msub.asset_inventory
2470: , msub.lpn_controlled_flag
2471: , msub.enable_locator_alias
2472: FROM mtl_secondary_inventories msub, mtl_cc_subinventories mccs
2473: WHERE msub.organization_id = p_organization_id
2474: AND mccs.cycle_count_header_id = p_cycle_count_header_id
2475: AND mccs.subinventory = msub.secondary_inventory_name
2476: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)

Line 2911: FROM wms_license_plate_numbers a, mtl_secondary_inventories b

2907: , inv_project.get_project_id
2908: , inv_project.get_project_number
2909: , inv_project.get_task_id
2910: , inv_project.get_task_number
2911: FROM wms_license_plate_numbers a, mtl_secondary_inventories b
2912: WHERE a.organization_id = p_organization_id
2913: AND (a.lpn_context = 1 OR a.lpn_context = 11)
2914: AND b.organization_id(+) = a.organization_id
2915: AND b.secondary_inventory_name(+) = a.subinventory_code

Line 2964: FROM wms_license_plate_numbers a, mtl_secondary_inventories b

2960: , inv_project.get_project_id
2961: , inv_project.get_project_number
2962: , inv_project.get_task_id
2963: , inv_project.get_task_number
2964: FROM wms_license_plate_numbers a, mtl_secondary_inventories b
2965: WHERE a.organization_id = p_organization_id
2966: AND (a.lpn_context = 1 OR a.lpn_context = 11)
2967: AND b.organization_id(+) = a.organization_id
2968: AND b.secondary_inventory_name(+) = a.subinventory_code

Line 3179: FROM mtl_secondary_inventories

3175: , description
3176: , asset_inventory
3177: , lpn_controlled_flag
3178: , enable_locator_alias
3179: FROM mtl_secondary_inventories
3180: WHERE organization_id = l_org
3181: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3182: 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'
3183: AND secondary_inventory_name LIKE (p_secondary_inventory_name);

Line 3192: FROM mtl_secondary_inventories

3188: , description
3189: , asset_inventory
3190: , lpn_controlled_flag
3191: , enable_locator_alias
3192: FROM mtl_secondary_inventories
3193: WHERE organization_id = l_org
3194: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3195: 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'
3196: AND secondary_inventory_name LIKE (p_secondary_inventory_name)

Line 3322: FROM mtl_secondary_inventories msi

3318: --Bug#7417734.added the IF block below
3319: IF l_inventory_asset_flag = 'Y' AND p_from_sub_asset_inventory = 2 THEN
3320: SELECT COUNT(*)
3321: INTO l_count
3322: FROM mtl_secondary_inventories msi
3323: WHERE msi.organization_id = p_orgid
3324: AND msi.asset_inventory = 2
3325: AND NVL(msi.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3326: AND msi.secondary_inventory_name = p_to_subinventory ;

Line 3604: FROM mtl_secondary_inventories msi, MTL_ONHAND_QUANTITIES_DETAIL moq

3600: , msi.description
3601: , '0'
3602: , msi.lpn_controlled_flag
3603: , msi.enable_locator_alias
3604: FROM mtl_secondary_inventories msi, MTL_ONHAND_QUANTITIES_DETAIL moq
3605: WHERE msi.secondary_inventory_name = moq.subinventory_code
3606: AND msi.organization_id = moq.organization_id
3607: 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'
3608: AND moq.containerized_flag = 2

Line 3743: FROM mtl_secondary_inventories

3739: , description
3740: , asset_inventory
3741: , 0 dummy
3742: , enable_locator_alias
3743: FROM mtl_secondary_inventories
3744: WHERE organization_id = NVL(p_organization_id, organization_id)
3745: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3746: AND secondary_inventory_name LIKE (p_subinventory_code)
3747: UNION ALL

Line 3765: FROM mtl_secondary_inventories

3761: , description
3762: , asset_inventory
3763: , 0 dummy
3764: , enable_locator_alias
3765: FROM mtl_secondary_inventories
3766: WHERE organization_id = p_organization_id
3767: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3768: AND secondary_inventory_name LIKE (p_subinventory_code)
3769: UNION ALL

Line 4014: FROM mtl_secondary_inventories

4010: , description
4011: , asset_inventory
4012: , lpn_controlled_flag
4013: , enable_locator_alias
4014: FROM mtl_secondary_inventories
4015: WHERE organization_id = NVL(p_organization_id, organization_id)
4016: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4017: AND secondary_inventory_name LIKE (p_subinventory_code)
4018: AND lpn_controlled_flag = 1

Line 4029: FROM mtl_secondary_inventories

4025: , description
4026: , asset_inventory
4027: , lpn_controlled_flag
4028: , enable_locator_alias
4029: FROM mtl_secondary_inventories
4030: WHERE organization_id = p_organization_id
4031: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4032: AND secondary_inventory_name LIKE (p_subinventory_code)
4033: AND lpn_controlled_flag = 1

Line 4079: FROM mtl_secondary_inventories

4075:
4076: BEGIN
4077: SELECT Nvl(subinventory_type,1)
4078: INTO l_sub_type
4079: FROM mtl_secondary_inventories
4080: WHERE secondary_inventory_name = p_subinventory_code
4081: AND organization_id = p_organization_id;
4082: EXCEPTION
4083: WHEN OTHERS THEN

Line 4264: FROM mtl_secondary_inventories

4260:
4261: BEGIN
4262: SELECT Nvl(subinventory_type,1)
4263: INTO l_sub_type
4264: FROM mtl_secondary_inventories
4265: WHERE secondary_inventory_name = p_subinventory_code
4266: AND organization_id = p_organization_id;
4267: EXCEPTION
4268: WHEN OTHERS THEN

Line 4644: FROM mtl_secondary_inventories

4640: , lpn_controlled_flag
4641: , Nvl(subinventory_type,1)
4642: , reservable_type
4643: , enable_locator_alias
4644: FROM mtl_secondary_inventories
4645: WHERE organization_id = p_organization_id
4646: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4647: AND secondary_inventory_name LIKE (p_subinventory_code)
4648: AND inv_ui_item_sub_loc_lovs.validate_lpn_sub(p_organization_id,

Line 4660: FROM mtl_secondary_inventories msub

4656: , lpn_controlled_flag
4657: , Nvl(subinventory_type,1)
4658: , reservable_type
4659: , enable_locator_alias
4660: FROM mtl_secondary_inventories msub
4661: WHERE organization_id = p_organization_id
4662: AND Nvl(subinventory_type,1) = 2
4663: AND msub.secondary_inventory_name LIKE (p_subinventory_code)
4664: AND (trunc(disable_date + (300*365)) >= trunc(SYSDATE) OR

Line 4678: FROM mtl_secondary_inventories msub

4674: , lpn_controlled_flag
4675: , Nvl(subinventory_type,1)
4676: , reservable_type
4677: , enable_locator_alias
4678: FROM mtl_secondary_inventories msub
4679: WHERE organization_id = p_organization_id
4680: AND Nvl(subinventory_type,1) = 2
4681: AND msub.secondary_inventory_name LIKE (p_subinventory_code)
4682: AND (trunc(disable_date + (300*365)) >= trunc(SYSDATE) OR

Line 4696: FROM mtl_secondary_inventories

4692: , lpn_controlled_flag
4693: , Nvl(subinventory_type,1)
4694: , reservable_type
4695: , enable_locator_alias
4696: FROM mtl_secondary_inventories
4697: WHERE organization_id = p_organization_id
4698: AND Nvl(subinventory_type,1) = 1
4699: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4700: AND secondary_inventory_name LIKE (p_subinventory_code)

Line 4716: FROM mtl_secondary_inventories

4712: , lpn_controlled_flag
4713: , Nvl(subinventory_type,1)
4714: , reservable_type
4715: , enable_locator_alias
4716: FROM mtl_secondary_inventories
4717: WHERE organization_id = p_organization_id
4718: AND Nvl(subinventory_type,1) = 1
4719: AND lpn_controlled_flag = 1
4720: AND reservable_type = 1

Line 4737: FROM mtl_secondary_inventories

4733: , lpn_controlled_flag
4734: , Nvl(subinventory_type,1)
4735: , reservable_type
4736: , enable_locator_alias
4737: FROM mtl_secondary_inventories
4738: WHERE organization_id = p_organization_id
4739: AND Nvl(subinventory_type,1) = 1
4740: AND lpn_controlled_flag = 2
4741: AND reservable_type = 2

Line 4759: FROM mtl_secondary_inventories

4755: , lpn_controlled_flag
4756: , Nvl(subinventory_type,1)
4757: , reservable_type
4758: , enable_locator_alias
4759: FROM mtl_secondary_inventories
4760: WHERE organization_id = p_organization_id
4761: AND Nvl(subinventory_type,1) = 1
4762: AND lpn_controlled_flag = 1
4763: AND reservable_type = 1

Line 4778: FROM mtl_secondary_inventories msub

4774: , lpn_controlled_flag
4775: , Nvl(subinventory_type,1)
4776: , reservable_type
4777: , enable_locator_alias
4778: FROM mtl_secondary_inventories msub
4779: WHERE organization_id = p_organization_id
4780: AND Nvl(subinventory_type,1) = 2
4781: AND msub.secondary_inventory_name LIKE (p_subinventory_code)
4782: AND (trunc(disable_date + (300*365)) >= trunc(SYSDATE) OR

Line 4796: FROM mtl_secondary_inventories

4792: , lpn_controlled_flag
4793: , Nvl(subinventory_type,1)
4794: , reservable_type
4795: , enable_locator_alias
4796: FROM mtl_secondary_inventories
4797: WHERE organization_id = p_organization_id
4798: AND Nvl(subinventory_type,1) = 1
4799: AND lpn_controlled_flag = 2
4800: AND reservable_type = 2

Line 4815: FROM mtl_secondary_inventories msub

4811: , lpn_controlled_flag
4812: , Nvl(subinventory_type,1)
4813: , reservable_type
4814: , enable_locator_alias
4815: FROM mtl_secondary_inventories msub
4816: WHERE organization_id = p_organization_id
4817: AND Nvl(subinventory_type,1) = 2
4818: AND msub.secondary_inventory_name LIKE (p_subinventory_code)
4819: AND (trunc(disable_date + (300*365)) >= trunc(SYSDATE) OR

Line 4834: FROM mtl_secondary_inventories

4830: , lpn_controlled_flag
4831: , Nvl(subinventory_type,1)
4832: , reservable_type
4833: , enable_locator_alias
4834: FROM mtl_secondary_inventories
4835: WHERE organization_id = p_organization_id
4836: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4837: AND secondary_inventory_name LIKE (p_subinventory_code)
4838: AND inv_ui_item_sub_loc_lovs.validate_lpn_sub(p_organization_id,

Line 5066: FROM mtl_secondary_inventories

5062: -- get the sub type and based on it set the loc_type
5063: BEGIN
5064: SELECT nvl(subinventory_type,1)
5065: INTO l_sub_type
5066: FROM mtl_secondary_inventories
5067: WHERE organization_id = p_organization_id
5068: AND secondary_inventory_name = p_subinventory_code;
5069: EXCEPTION
5070: WHEN OTHERS THEN

Line 6946: FROM mtl_secondary_inventories

6942:
6943: BEGIN
6944: SELECT Nvl(subinventory_type,1)
6945: INTO l_sub_type
6946: FROM mtl_secondary_inventories
6947: WHERE secondary_inventory_name = p_subinventory_code
6948: AND organization_id = p_organization_id;
6949: EXCEPTION
6950: WHEN OTHERS THEN

Line 7029: FROM mtl_secondary_inventories msi,

7025: , description
7026: , asset_inventory
7027: , lpn_controlled_flag
7028: , enable_locator_alias
7029: FROM mtl_secondary_inventories msi,
7030: mtl_item_sub_inventories misi
7031: WHERE msi.organization_id = p_organization_id
7032: AND msi.organization_id = misi.organization_id
7033: AND msi.secondary_inventory_name = misi.secondary_inventory