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_REPLENISH_COUNT_LOVS dependencies on MTL_REPLENISH_LINES

Line 109: FROM mtl_replenish_lines mrl

105: AND mrh.default_count_type_code = ml.lookup_code
106: AND mrh.replenishment_count_name LIKE p_replenish_count
107: AND((msi.planning_level = 1
108: AND NOT EXISTS(SELECT 1
109: FROM mtl_replenish_lines mrl
110: WHERE mrl.replenishment_header_id = mrh.replenishment_header_id
111: AND mrl.locator_id IS NULL
112: )
113: )

Line 116: FROM mtl_replenish_lines mrl

112: )
113: )
114: OR(msi.planning_level = 2
115: AND NOT EXISTS(SELECT 1
116: FROM mtl_replenish_lines mrl
117: WHERE mrl.replenishment_header_id = mrh.replenishment_header_id
118: AND mrl.locator_id IS NOT NULL
119: )
120: )

Line 244: , mtl_replenish_lines mrl

240: AND NVL(milk.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
241: AND milk.concatenated_segments LIKE(p_locator||'%')
242: AND EXISTS( SELECT 1
243: FROM mtl_secondary_locators msl
244: , mtl_replenish_lines mrl
245: WHERE msl.secondary_locator = milk.inventory_location_id
246: AND msl.organization_id = milk.organization_id
247: AND mrl.replenishment_header_id = p_replenish_header_id
248: AND mrl.locator_id = msl.secondary_locator

Line 320: , mtl_replenish_lines mrl

316: AND NVL(milk.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
317: AND milk.alias = p_alias
318: AND EXISTS( SELECT 1
319: FROM mtl_secondary_locators msl
320: , mtl_replenish_lines mrl
321: WHERE msl.secondary_locator = milk.inventory_location_id
322: AND msl.organization_id = milk.organization_id
323: AND mrl.replenishment_header_id = p_replenish_header_id
324: AND mrl.locator_id = msl.secondary_locator

Line 441: , mtl_replenish_lines mrl

437: AND msik.concatenated_segments LIKE p_item||l_append
438: AND ((p_locator_id IS NULL
439: AND EXISTS(SELECT 1
440: FROM mtl_item_sub_inventories mis
441: , mtl_replenish_lines mrl
442: WHERE mis.organization_id = msik.organization_id
443: AND mis.secondary_inventory = p_subinventory
444: AND mis.inventory_item_id = msik.inventory_item_id
445: AND mrl.replenishment_header_id = p_replenish_header_id

Line 457: , mtl_replenish_lines mrl

453: )
454: OR (p_locator_id IS NOT NULL
455: AND EXISTS(SELECT 1
456: FROM mtl_secondary_locators msl
457: , mtl_replenish_lines mrl
458: WHERE msl.secondary_locator = p_locator_id
459: AND msl.inventory_item_id = msik.inventory_item_id
460: AND msl.organization_id = msik.organization_id
461: AND mrl.replenishment_header_id = p_replenish_header_id

Line 533: , mtl_replenish_lines mrl

529: AND msik.stock_enabled_flag = 'Y'
530: AND ((p_locator_id IS NULL
531: AND EXISTS(SELECT 1
532: FROM mtl_item_sub_inventories mis
533: , mtl_replenish_lines mrl
534: WHERE mis.organization_id = msik.organization_id
535: AND mis.secondary_inventory = p_subinventory
536: AND mis.inventory_item_id = msik.inventory_item_id
537: AND mrl.replenishment_header_id = p_replenish_header_id

Line 549: , mtl_replenish_lines mrl

545: )
546: OR (p_locator_id IS NOT NULL
547: AND EXISTS(SELECT 1
548: FROM mtl_secondary_locators msl
549: , mtl_replenish_lines mrl
550: WHERE msl.secondary_locator = p_locator_id
551: AND msl.inventory_item_id = msik.inventory_item_id
552: AND msl.organization_id = msik.organization_id
553: AND mrl.replenishment_header_id = p_replenish_header_id