DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on MTL_CATEGORY_SET_VALID_CATS

Line 606: FROM MTL_CATEGORY_SET_VALID_CATS MCSV

602: MCK.STRUCTURE_ID=MCS.STRUCTURE_ID AND
603: NVL(MCK.DISABLE_DATE, SYSDATE + 1) > SYSDATE AND
604: (MCS.VALIDATE_FLAG='Y' AND MCK.CATEGORY_ID IN
605: (SELECT MCSV.CATEGORY_ID
606: FROM MTL_CATEGORY_SET_VALID_CATS MCSV
607: WHERE MCSV.CATEGORY_SET_ID=MCS.CATEGORY_SET_ID)
608: OR MCS.VALIDATE_FLAG <> 'Y')
609: AND MCK.CATEGORY_ID = MC.CATEGORY_ID
610: AND MCK.CATEGORY_ID = sel_category_id )