DBA Data[Home] [Help]

APPS.BOM_DEFAULT_OP_RES dependencies on BOM_OPERATION_SEQUENCES

Line 263: , BOM_OPERATION_SEQUENCES bos

259: ) default_autocharge
260: , NVL(br.standard_rate_flag, 1) standard_rate_flag
261: FROM BOM_RESOURCES br
262: , BOM_DEPARTMENTS bd
263: , BOM_OPERATION_SEQUENCES bos
264: , CST_ACTIVITIES_VAL_V ca
265: WHERE bd.department_id = bos.department_id
266: AND ca.activity_id (+) = br.default_activity_id
267: AND NVL(ca.organization_id, p_org_id) = p_org_id

Line 343: FROM BOM_OPERATION_SEQUENCES bos

339: , p_op_seq_id NUMBER
340: )
341: IS
342: SELECT bdr.available_24_hours_flag
343: FROM BOM_OPERATION_SEQUENCES bos
344: , BOM_DEPARTMENT_RESOURCES bdr
345: WHERE bdr.department_id = bos.department_id
346: AND bdr.resource_id = p_resource_id
347: AND bos.operation_sequence_id = p_op_seq_id ;