DBA Data[Home] [Help]

APPS.BOM_VALIDATE_OP_SEQ dependencies on BOM_DEPARTMENTS

Line 3078: FROM BOM_DEPARTMENTS bd

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