DBA Data[Home] [Help]

APPS.BOM_VALIDATE_OP_SEQ dependencies on BOM_DEPARTMENTS

Line 3077: FROM BOM_DEPARTMENTS bd

3073: IS
3074: SELECT 'Dept is invalid'
3075: FROM DUAL
3076: WHERE NOT EXISTS (SELECT NULL
3077: FROM BOM_DEPARTMENTS bd
3078: WHERE NVL(TRUNC(bd.disable_date) , TRUNC(p_start_effective_date) + 1)
3079: > TRUNC(p_start_effective_date)
3080: AND bd.organization_id = p_organization_id
3081: AND bd.department_id = p_dept_id