APPS.WIP_WS_DL_UTIL dependencies on WIP_OPERATION_RESOURCES

Line 550: from wip_operation_resources wor

546: is
547: cursor c_num_setups(p_wip_entity_id number, p_op_seq number)
548: Is
549: select count(distinct wor.setup_id)
550: from wip_operation_resources wor
551: where wor.wip_entity_id = p_wip_entity_id and
552: wor.operation_seq_num = p_op_seq;
553:
554: cursor c_setups(p_wip_entity_id number, p_op_seq number)

Line 557: from wip_operation_resources wor, bom_setup_types bst

553:
554: cursor c_setups(p_wip_entity_id number, p_op_seq number)
555: Is
556: select bst.setup_code
557: from wip_operation_resources wor, bom_setup_types bst
558: where wor.wip_entity_id = p_wip_entity_id and
559: wor.operation_seq_num = p_op_seq and
560: wor.setup_id = bst.setup_id;
561:

Line 735: wip_operation_resources wor,

731: wor.actual_start_date,
732: wor.assigned_units
733: from wip_discrete_jobs wdj,
734: wip_operations wo,
735: wip_operation_resources wor,
736: bom_resources br,
737: bom_department_resources bdr,
738: wip_parameters mp
739: where wdj.wip_entity_id = wo.wip_entity_id and

Line 1281: ' from wip_operation_resources wor1, ' ||

1277: l_tmp :=
1278: ' exists ' ||
1279: ' ( ' ||
1280: ' select 1 ' ||
1281: ' from wip_operation_resources wor1, ' ||
1282: ' wip_op_resource_instances wori1 ' ||
1283: ' where qrslt.wip_entity_id = wor1.wip_entity_id ' ||
1284: ' and qrslt.organization_id = wor1.organization_id ' ||
1285: ' and qrslt.operation_seq_num = wor1.operation_seq_num ' ||

Line 1306: ' from wip_operation_resources wor1, bom_department_resources bdr ' ||

1302: add_where(l_where,
1303: ' exists ' ||
1304: ' ( ' ||
1305: ' select 1 ' ||
1306: ' from wip_operation_resources wor1, bom_department_resources bdr ' ||
1307: ' where wor1.wip_entity_id = qrslt.wip_entity_id ' ||
1308: ' and wor1.organization_id = qrslt.organization_id ' ||
1309: ' and wor1.operation_seq_num = qrslt.operation_seq_num ' ||
1310: ' and bdr.department_id = qrslt.department_id ' ||

Line 1335: ' from wip_operation_resources wor1, ' ||

1331: add_string
1332: (l_tmp,
1333: ' ( ' ||
1334: ' select 1 ' ||
1335: ' from wip_operation_resources wor1, ' ||
1336: ' wip_op_resource_instances wori1 ' ||
1337: ' where qrslt.wip_entity_id = wor1.wip_entity_id ' ||
1338: ' and qrslt.organization_id = wor1.organization_id ' ||
1339: ' and qrslt.operation_seq_num = wor1.operation_seq_num ' ||