APPS.INVTVTUS dependencies on MTL_ITEM_CATEGORIES

Line 490: from mtl_item_categories mic

486: and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
487: and mmt.subinventory_code = sub
488: and (mmt.locator_id = nvl(locid, mmt.locator_id) or mmt.locator_id is null)
489: and exists ( select 'X'
490: from mtl_item_categories mic
491: where mic.category_set_id = nvl(catsetid, mic.category_set_id)
492: and mic.category_id = nvl(catid, mic.category_id)
493: and mic.inventory_item_id = mmt.inventory_item_id
494: and mic.organization_id = orgid)

Line 737: from mtl_item_categories mic

733: and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
734: and mmt.subinventory_code = sub
735: and (mmt.locator_id = nvl(locid, mmt.locator_id) or mmt.locator_id is null)
736: and exists ( select 'X'
737: from mtl_item_categories mic
738: where mic.category_set_id = nvl(catsetid, mic.category_set_id)
739: and mic.category_id = nvl(catid, mic.category_id)
740: and mic.inventory_item_id = mmt.inventory_item_id
741: and mic.organization_id = orgid)

Line 765: from mtl_item_categories mic

761: and mmt.transaction_date <= NVL(edate, mmt.transaction_date + 1)
762: and mmt.subinventory_code = sub
763: and (mmt.locator_id = nvl(locid, mmt.locator_id) or mmt.locator_id is null)
764: and exists ( select 'X'
765: from mtl_item_categories mic
766: where mic.category_set_id = nvl(catsetid, mic.category_set_id)
767: and mic.category_id = nvl(catid, mic.category_id)
768: and mic.inventory_item_id = mmt.inventory_item_id
769: and mic.organization_id = orgid)