DBA Data[Home] [Help]

APPS.BOM_VALIDATE_OP_RES dependencies on BOM_RESOURCE_SETUPS

Line 492: FROM BOM_RESOURCE_SETUPS brs

488: SELECT 'Setup Id is invalid'
489: FROM DUAL
490: WHERE NOT EXISTS(
491: SELECT NULL
492: FROM BOM_RESOURCE_SETUPS brs
493: , BOM_SETUP_TYPES bst
494: WHERE brs.setup_id = bst.setup_id
495: AND brs.organization_id = bst.organization_id
496: AND brs.resource_id = p_resource_id

Line 2081: FROM bom_resource_setups

2077: , p_org_id NUMBER
2078: )
2079: IS
2080: SELECT count(setup_id)
2081: FROM bom_resource_setups
2082: WHERE resource_id = p_resource_id
2083: AND organization_id = p_org_id;
2084:
2085: