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 1275: ' from wip_operation_resources wor1, ' ||

1271: l_tmp :=
1272: ' exists ' ||
1273: ' ( ' ||
1274: ' select 1 ' ||
1275: ' from wip_operation_resources wor1, ' ||
1276: ' wip_op_resource_instances wori1 ' ||
1277: ' where qrslt.wip_entity_id = wor1.wip_entity_id ' ||
1278: ' and qrslt.organization_id = wor1.organization_id ' ||
1279: ' and qrslt.operation_seq_num = wor1.operation_seq_num ' ||

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

1296: add_where(l_where,
1297: ' exists ' ||
1298: ' ( ' ||
1299: ' select 1 ' ||
1300: ' from wip_operation_resources wor1, bom_department_resources bdr ' ||
1301: ' where wor1.wip_entity_id = qrslt.wip_entity_id ' ||
1302: ' and wor1.organization_id = qrslt.organization_id ' ||
1303: ' and wor1.operation_seq_num = qrslt.operation_seq_num ' ||
1304: ' and bdr.department_id = qrslt.department_id ' ||

Line 1329: ' from wip_operation_resources wor1, ' ||

1325: add_string
1326: (l_tmp,
1327: ' ( ' ||
1328: ' select 1 ' ||
1329: ' from wip_operation_resources wor1, ' ||
1330: ' wip_op_resource_instances wori1 ' ||
1331: ' where qrslt.wip_entity_id = wor1.wip_entity_id ' ||
1332: ' and qrslt.organization_id = wor1.organization_id ' ||
1333: ' and qrslt.operation_seq_num = wor1.operation_seq_num ' ||