DBA Data[Home] [Help]

APPS.INV_ITEM_STATUS_CP dependencies on MTL_ITEM_STATUS

Line 548: mtl_item_status pit

544: SELECT pis.status_code,
545: pis.inventory_item_id,
546: pis.organization_id
547: FROM mtl_pending_item_status pis,
548: mtl_item_status pit
549: WHERE pis.effective_date <= sysdate
550: AND pis.pending_flag = 'Y'
551: AND pis.inventory_item_id = nvl(cp_item_id,pis.inventory_item_id)
552: AND pis.organization_id = nvl(cp_org_id,pis.organization_id)