DBA Data[Home] [Help]

APPS.PJM_TASK_AUTO_ASSIGN dependencies on BOM_OPERATION_SEQUENCES

Line 1216: , bom_operation_sequences s

1212: IS
1213: SELECT s.standard_operation_id
1214: FROM wip_flow_schedules f
1215: , bom_operational_routings r
1216: , bom_operation_sequences s
1217: WHERE f.wip_entity_id = C_wip_entity_id
1218: AND f.organization_id = C_organization_id
1219: AND nvl(f.alternate_routing_designator, 'a') = nvl(r.alternate_routing_designator, 'a')
1220: AND r.assembly_item_id = C_primary_item_id