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_INV_LOVS dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 55: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moqd

51: AND mln.inventory_item_id = p_item_id
52: AND mln.lot_number LIKE (p_lot_number)
53: AND mln.status_id = mmst.status_id (+)
54: AND mmst.language (+) = userenv('LANG')
55: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moqd
56: WHERE moqd.lot_number = mln.lot_number
57: AND moqd.inventory_item_id = mln.inventory_item_id
58: AND moqd.organization_id = mln.organization_id
59: AND ((moqd.containerized_flag = 1 AND p_lpn_id IS NOT NULL)

Line 84: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moqd

80: AND mln.lot_number LIKE (p_lot_number)
81: AND mln.status_id = mmst.status_id (+)
82: AND mmst.language (+) = userenv('LANG')
83: AND mln.parent_lot_number IS NOT NULL
84: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moqd
85: WHERE moqd.lot_number = mln.lot_number
86: AND moqd.inventory_item_id = mln.inventory_item_id
87: AND moqd.organization_id = mln.organization_id
88: AND ((moqd.containerized_flag = 1 AND p_lpn_id IS NOT NULL)

Line 113: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moqd

109: AND mln.inventory_item_id = p_item_id
110: AND mln.lot_number LIKE (p_lot_number)
111: AND mln.status_id = mmst.status_id (+)
112: AND mmst.language (+) = userenv('LANG')
113: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moqd
114: WHERE moqd.lot_number = mln.lot_number
115: AND moqd.inventory_item_id = mln.inventory_item_id
116: AND moqd.organization_id = mln.organization_id
117: AND ((moqd.containerized_flag = 1 AND p_lpn_id IS NOT NULL)

Line 238: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moq

234: mtl_material_statuses_tl mmst
235: WHERE mln.organization_id = p_organization_id
236: AND mln.inventory_item_id = p_item_id
237: AND mln.lot_number LIKE (p_lot_number)
238: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moq
239: WHERE moq.lot_number = mln.lot_number
240: AND moq.inventory_item_id = mln.inventory_item_id
241: AND moq.organization_id = mln.organization_id)
242: AND mln.status_id = mmst.status_id (+)

Line 393: AND exists ( SELECT '1' FROM mtl_onhand_quantities_detail moq

389: mtl_material_statuses_tl mmst
390: WHERE mln.organization_id = p_organization_id
391: AND mln.inventory_item_id = p_item_id
392: AND mln.lot_number LIKE (p_lot_number)
393: AND exists ( SELECT '1' FROM mtl_onhand_quantities_detail moq
394: WHERE mln.lot_number = moq.lot_number
395: AND moq.organization_id = p_organization_id
396: AND moq.lpn_id IS NULL -- added for bug 4614645
397: AND NVL(moq.revision, '@') = NVL(p_revision, NVL(moq.revision, '@'))

Line 443: FROM mtl_lot_numbers mln, mtl_onhand_quantities_detail moq,

439: SELECT DISTINCT moq.lot_number
440: , mln.description
441: , mln.expiration_date
442: , mmst.status_code
443: FROM mtl_lot_numbers mln, mtl_onhand_quantities_detail moq,
444: mtl_material_statuses_tl mmst
445: WHERE mln.lot_number = moq.lot_number
446: AND mln.inventory_item_id = p_inventory_item_id
447: AND mln.organization_id = p_organization_id

Line 758: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq

754: OPEN x_cost_group_lov FOR
755: SELECT ccg.cost_group
756: , ccg.cost_group_id
757: , ccg.description
758: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq
759: WHERE ccg.cost_group LIKE (p_from_cost_group)
760: AND ccg.cost_group_id = moq.cost_group_id
761: AND ccg.cost_group_type <> 1 --PJM-WMS Integration
762: AND ((moq.revision = p_revision)

Line 1001: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil

997: , msik.description
998: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
999: , mms.status_code
1000: , mms.status_id
1001: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1002: WHERE moq.organization_id = p_organization_id
1003: AND moq.lot_number IS NOT NULL
1004: AND moq.organization_id = mil.organization_id
1005: AND moq.organization_id = mln.organization_id

Line 1030: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil

1026: , msik.description
1027: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1028: , NULL status_code
1029: , msik.default_lot_status_id -- Bug#2267947
1030: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1031: WHERE moq.organization_id = p_organization_id
1032: AND moq.lot_number IS NOT NULL
1033: AND moq.organization_id = mil.organization_id
1034: AND moq.organization_id = mln.organization_id

Line 1275: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil

1271: , msik.description
1272: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1273: , mms.status_code
1274: , mms.status_id
1275: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1276: WHERE moq.organization_id = p_organization_id
1277: AND moq.lot_number IS NOT NULL
1278: AND moq.organization_id = mil.organization_id
1279: AND moq.organization_id = mln.organization_id

Line 1305: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil

1301: , msik.description
1302: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1303: , NULL status_code
1304: , msik.default_lot_status_id -- Bug#2267947
1305: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1306: WHERE moq.organization_id = p_organization_id
1307: AND moq.lot_number IS NOT NULL
1308: AND moq.organization_id = mil.organization_id
1309: AND moq.organization_id = mln.organization_id

Line 1801: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq

1797: OPEN x_cost_group FOR
1798: SELECT DISTINCT ccg.cost_group
1799: , ccg.cost_group_id
1800: , ccg.description
1801: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq
1802: WHERE ccg.cost_group_id = moq.cost_group_id
1803: AND ccg.cost_group_type = 3
1804: AND NVL(ccg.organization_id, moq.organization_id) = moq.organization_id
1805: AND NVL(moq.subinventory_code, '@') = NVL(p_subinventory_code, NVL(moq.subinventory_code, '@'))

Line 2013: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moq

2009: AND mln.inventory_item_id = p_item_id
2010: AND mln.lot_number LIKE (p_lot_number)
2011: AND mln.status_id = mmst.status_id (+)
2012: AND mmst.language (+) = userenv('LANG')
2013: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moq
2014: WHERE moq.lot_number = mln.lot_number
2015: AND moq.inventory_item_id = mln.inventory_item_id
2016: AND moq.organization_id = mln.organization_id
2017: AND moq.containerized_flag = 1

Line 2050: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moq

2046: AND mln.inventory_item_id = p_item_id
2047: AND mln.lot_number LIKE (p_lot_number)
2048: AND mln.status_id = mmst.status_id (+)
2049: AND mmst.language (+) = userenv('LANG')
2050: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moq
2051: WHERE moq.lot_number = mln.lot_number
2052: AND moq.inventory_item_id = mln.inventory_item_id
2053: AND moq.organization_id = mln.organization_id
2054: AND moq.containerized_flag = 2

Line 2076: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moq

2072: AND mln.inventory_item_id = p_item_id
2073: AND mln.lot_number LIKE (p_lot_number)
2074: AND mln.status_id = mmst.status_id (+)
2075: AND mmst.language (+) = userenv('LANG')
2076: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moq
2077: WHERE moq.lot_number = mln.lot_number
2078: AND moq.inventory_item_id = mln.inventory_item_id
2079: AND moq.organization_id = mln.organization_id
2080: AND moq.containerized_flag = 1

Line 2112: --selecting mtl_onhand_quantities_detail

2108: BEGIN
2109: -- Since Negative Balance check is through APL Set-up form prameter.We would
2110: --not required to check negative balance here through back-end.
2111: -- Vikas v1 10/04/04 start removed earlier code,also removed AND clause
2112: --selecting mtl_onhand_quantities_detail
2113:
2114:
2115: IF (p_lpn_id IS NULL
2116: OR p_lpn_id = 0

Line 2157: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moq

2153: AND mln.inventory_item_id = p_item_id
2154: AND mln.lot_number LIKE (p_lot_number)
2155: AND mln.status_id = mmst.status_id (+)
2156: AND mmst.language (+) = userenv('LANG')
2157: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moq
2158: WHERE moq.lot_number = mln.lot_number
2159: AND moq.inventory_item_id = mln.inventory_item_id
2160: AND moq.organization_id = mln.organization_id
2161: AND moq.containerized_flag = 1

Line 2433: AND EXISTS ( select 1 from mtl_onhand_quantities_detail moqd

2429: AND mln.status_id = mmst.status_id (+)
2430: AND mmst.language (+) = userenv('LANG')
2431: AND mln.lot_number LIKE (p_lot_number)
2432: /* Bug 8566866 */
2433: AND EXISTS ( select 1 from mtl_onhand_quantities_detail moqd
2434: where moqd.inventory_item_id = mln.inventory_item_id
2435: AND moqd.organization_id = mln.organization_id
2436: AND moqd.lot_number = mln.lot_number
2437: AND moqd.lpn_id IS NULL

Line 2481: AND EXISTS ( select 1 from mtl_onhand_quantities_detail moqd

2477: AND mmst.language (+) = userenv('LANG')
2478: AND mln.lot_number >= p_from_lot_number
2479: AND mln.lot_number LIKE (p_lot_number)
2480: /* Bug 8566866 */
2481: AND EXISTS ( select 1 from mtl_onhand_quantities_detail moqd
2482: where moqd.inventory_item_id = mln.inventory_item_id
2483: AND moqd.organization_id = mln.organization_id
2484: AND moqd.lot_number = mln.lot_number
2485: AND moqd.lpn_id IS NULL