DBA Data[Home] [Help]

APPS.INVPVDR5 dependencies on MTL_ITEM_STATUS

Line 733: from MTL_ITEM_STATUS

729: -- validate foreign keys
730: if cr.INVENTORY_ITEM_STATUS_CODE is not null then
731: begin
732: select 'x' into temp
733: from MTL_ITEM_STATUS
734: where INVENTORY_ITEM_STATUS_CODE = cr.INVENTORY_ITEM_STATUS_CODE
735: and SYSDATE < nvl(DISABLE_DATE, SYSDATE+1); /*NP 16OCT94*/
736: exception
737: when NO_DATA_FOUND then