DBA Data[Home] [Help]

APPS.INVPVDR5 dependencies on MTL_ITEM_STATUS

Line 753: from MTL_ITEM_STATUS

749: -- validate foreign keys
750: if cr.INVENTORY_ITEM_STATUS_CODE is not null then
751: begin
752: select 'x' into temp
753: from MTL_ITEM_STATUS
754: where INVENTORY_ITEM_STATUS_CODE = cr.INVENTORY_ITEM_STATUS_CODE
755: and SYSDATE < nvl(DISABLE_DATE, SYSDATE+1); /*NP 16OCT94*/
756: exception
757: when NO_DATA_FOUND then