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 217: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moq

213: mtl_material_statuses_tl mmst
214: WHERE mln.organization_id = p_organization_id
215: AND mln.inventory_item_id = p_item_id
216: AND mln.lot_number LIKE (p_lot_number)
217: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moq
218: WHERE moq.lot_number = mln.lot_number
219: AND moq.inventory_item_id = mln.inventory_item_id
220: AND moq.organization_id = mln.organization_id)
221: AND mln.status_id = mmst.status_id (+)

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

367: mtl_material_statuses_tl mmst
368: WHERE mln.organization_id = p_organization_id
369: AND mln.inventory_item_id = p_item_id
370: AND mln.lot_number LIKE (p_lot_number)
371: AND exists ( SELECT '1' FROM mtl_onhand_quantities_detail moq
372: WHERE mln.lot_number = moq.lot_number
373: AND moq.organization_id = p_organization_id
374: AND moq.lpn_id IS NULL -- added for bug 4614645
375: AND NVL(moq.revision, '@') = NVL(p_revision, NVL(moq.revision, '@'))

Line 421: FROM mtl_lot_numbers mln, mtl_onhand_quantities_detail moq,

417: SELECT DISTINCT moq.lot_number
418: , mln.description
419: , mln.expiration_date
420: , mmst.status_code
421: FROM mtl_lot_numbers mln, mtl_onhand_quantities_detail moq,
422: mtl_material_statuses_tl mmst
423: WHERE mln.lot_number = moq.lot_number
424: AND mln.inventory_item_id = p_inventory_item_id
425: AND mln.organization_id = p_organization_id

Line 736: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq

732: OPEN x_cost_group_lov FOR
733: SELECT ccg.cost_group
734: , ccg.cost_group_id
735: , ccg.description
736: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq
737: WHERE ccg.cost_group LIKE (p_from_cost_group)
738: AND ccg.cost_group_id = moq.cost_group_id
739: AND ccg.cost_group_type <> 1 --PJM-WMS Integration
740: AND ((moq.revision = p_revision)

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

973: , msik.description
974: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
975: , mms.status_code
976: , mms.status_id
977: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
978: WHERE moq.organization_id = p_organization_id
979: AND moq.lot_number IS NOT NULL
980: AND moq.organization_id = mil.organization_id
981: AND moq.organization_id = mln.organization_id

Line 1006: 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: , msik.description
1003: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1004: , NULL status_code
1005: , msik.default_lot_status_id -- Bug#2267947
1006: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1007: WHERE moq.organization_id = p_organization_id
1008: AND moq.lot_number IS NOT NULL
1009: AND moq.organization_id = mil.organization_id
1010: AND moq.organization_id = mln.organization_id

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

1247: , msik.description
1248: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1249: , mms.status_code
1250: , mms.status_id
1251: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1252: WHERE moq.organization_id = p_organization_id
1253: AND moq.lot_number IS NOT NULL
1254: AND moq.organization_id = mil.organization_id
1255: AND moq.organization_id = mln.organization_id

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

1277: , msik.description
1278: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1279: , NULL status_code
1280: , msik.default_lot_status_id -- Bug#2267947
1281: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1282: WHERE moq.organization_id = p_organization_id
1283: AND moq.lot_number IS NOT NULL
1284: AND moq.organization_id = mil.organization_id
1285: AND moq.organization_id = mln.organization_id

Line 1777: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq

1773: OPEN x_cost_group FOR
1774: SELECT DISTINCT ccg.cost_group
1775: , ccg.cost_group_id
1776: , ccg.description
1777: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq
1778: WHERE ccg.cost_group_id = moq.cost_group_id
1779: AND ccg.cost_group_type = 3
1780: AND NVL(ccg.organization_id, moq.organization_id) = moq.organization_id
1781: AND NVL(moq.subinventory_code, '@') = NVL(p_subinventory_code, NVL(moq.subinventory_code, '@'))

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

1985: AND mln.inventory_item_id = p_item_id
1986: AND mln.lot_number LIKE (p_lot_number)
1987: AND mln.status_id = mmst.status_id (+)
1988: AND mmst.language (+) = userenv('LANG')
1989: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moq
1990: WHERE moq.lot_number = mln.lot_number
1991: AND moq.inventory_item_id = mln.inventory_item_id
1992: AND moq.organization_id = mln.organization_id
1993: AND moq.containerized_flag = 1

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

2022: AND mln.inventory_item_id = p_item_id
2023: AND mln.lot_number LIKE (p_lot_number)
2024: AND mln.status_id = mmst.status_id (+)
2025: AND mmst.language (+) = userenv('LANG')
2026: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moq
2027: WHERE moq.lot_number = mln.lot_number
2028: AND moq.inventory_item_id = mln.inventory_item_id
2029: AND moq.organization_id = mln.organization_id
2030: AND moq.containerized_flag = 2

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

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

Line 2087: --selecting mtl_onhand_quantities_detail

2083: BEGIN
2084: -- Since Negative Balance check is through APL Set-up form prameter.We would
2085: --not required to check negative balance here through back-end.
2086: -- Vikas v1 10/04/04 start removed earlier code,also removed AND clause
2087: --selecting mtl_onhand_quantities_detail
2088:
2089:
2090: IF (p_lpn_id IS NULL
2091: OR p_lpn_id = 0

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

2128: AND mln.inventory_item_id = p_item_id
2129: AND mln.lot_number LIKE (p_lot_number)
2130: AND mln.status_id = mmst.status_id (+)
2131: AND mmst.language (+) = userenv('LANG')
2132: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moq
2133: WHERE moq.lot_number = mln.lot_number
2134: AND moq.inventory_item_id = mln.inventory_item_id
2135: AND moq.organization_id = mln.organization_id
2136: AND moq.containerized_flag = 1

Line 2396: FROM mtl_lot_numbers mln, mtl_material_statuses_tl mmst , mtl_onhand_quantities_detail moqd

2392: SELECT mln.lot_number
2393: , mln.description
2394: , mln.expiration_date
2395: , mmst.status_code
2396: FROM mtl_lot_numbers mln, mtl_material_statuses_tl mmst , mtl_onhand_quantities_detail moqd
2397: WHERE mln.organization_id = p_organization_id
2398: AND mln.inventory_item_id = p_item_id
2399: AND mln.status_id = mmst.status_id (+)
2400: AND mmst.language (+) = userenv('LANG')

Line 2437: FROM mtl_lot_numbers mln, mtl_material_statuses_tl mmst ,mtl_onhand_quantities_detail moqd

2433: SELECT mln.lot_number
2434: , mln.description
2435: , mln.expiration_date
2436: , mmst.status_code
2437: FROM mtl_lot_numbers mln, mtl_material_statuses_tl mmst ,mtl_onhand_quantities_detail moqd
2438: WHERE mln.organization_id = p_organization_id
2439: AND mln.inventory_item_id = p_item_id
2440: AND mln.status_id = mmst.status_id (+)
2441: AND mmst.language (+) = userenv('LANG')