DBA Data[Home] [Help]

APPS.PJM_TASK_AUTO_ASSIGN dependencies on BOM_OPERATIONAL_ROUTINGS

Line 1215: , bom_operational_routings r

1211: CURSOR f1 ( C_organization_id NUMBER, C_wip_entity_id NUMBER, C_operation_seq_num NUMBER, C_primary_item_id NUMBER )
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')