APPS.WSMPJUPD dependencies on WIP_OPERATION_RESOURCES

Line 1575: INSERT INTO WIP_OPERATION_RESOURCES

1571:
1572: BEGIN
1573:
1574: forall l_job_counter in indices of p_new_rj_we_id_tbl
1575: INSERT INTO WIP_OPERATION_RESOURCES
1576: (wip_entity_id,
1577: operation_seq_num,
1578: resource_seq_num,
1579: organization_id,

Line 1683: from wip_operation_resources wor

1679: wor.maximum_assigned_units ,
1680: 0 ,
1681: wor.parent_resource_seq
1682: -- ST : Detailed Scheduling --
1683: from wip_operation_resources wor
1684: WHERE wor.wip_entity_id = p_rep_we_id
1685: AND wor.operation_seq_num <= p_curr_op_seq_num
1686: );
1687:

Line 2860: FROM WIP_OPERATION_RESOURCES

2856: )
2857: SELECT wo.WIP_ENTITY_ID,
2858: wo.OPERATION_SEQ_NUM,
2859: rownum + (SELECT nvl(max(resource_seq_num), 10)
2860: FROM WIP_OPERATION_RESOURCES
2861: WHERE wip_entity_id = p_wip_entity_id
2862: AND OPERATION_SEQ_NUM = wo.OPERATION_SEQ_NUM),
2863: wo.ORGANIZATION_ID,
2864: bsor.SUBSTITUTE_GROUP_NUM,

Line 3186: UPDATE WIP_OPERATION_RESOURCES

3182: );
3183:
3184: l_stmt_num := 60;
3185:
3186: UPDATE WIP_OPERATION_RESOURCES
3187: SET autocharge_type = 2
3188: WHERE WIP_ENTITY_ID = p_wip_entity_id
3189: AND ORGANIZATION_ID = p_org_id
3190: AND OPERATION_SEQ_NUM >= l_job_op_seq_num;