DBA Data[Home] [Help]

APPS.INV_ITEM_STATUS_CP dependencies on MTL_ITEM_STATUS

Line 602: mtl_item_status pit

598: SELECT pis.status_code,
599: pis.inventory_item_id,
600: pis.organization_id
601: FROM mtl_pending_item_status pis,
602: mtl_item_status pit
603: WHERE pis.effective_date <= sysdate
604: AND pis.pending_flag = 'Y'
605: AND pis.inventory_item_id = nvl(cp_item_id,pis.inventory_item_id)
606: AND pis.organization_id = nvl(cp_org_id,pis.organization_id)

Line 622: mtl_item_status pit

618: SELECT pis.status_code,
619: pis.inventory_item_id,
620: pis.organization_id
621: FROM mtl_pending_item_status pis,
622: mtl_item_status pit
623: WHERE pis.effective_date <= sysdate
624: AND pis.pending_flag = 'Y'
625: AND pis.inventory_item_id = nvl(cp_item_id,pis.inventory_item_id)
626: AND pis.organization_id = nvl(cp_org_id,pis.organization_id)