APPS.EAM_PROCESS_WO_PVT dependencies on WIP_OPERATION_RESOURCES

Line 8528: wip_OPERATION_resources wor,

8524: wo.DEPARTMENT_ID,
8525: decode(wor.SCHEDULED_FLAG,2,null,wor.resource_seq_num) ,
8526: wor.SUBSTITUTE_GROUP_NUM
8527: from wip_operations wo,
8528: wip_OPERATION_resources wor,
8529: bom_resources br
8530: where wo.OPERATION_SEQ_NUM = wor.OPERATION_SEQ_NUM
8531: and br.resource_id = wor.resource_id
8532: AND wo.wip_entity_id = wor.wip_entity_id

Line 9459: FROM wip_operation_resources

9455: SELECT start_date,
9456: completion_date,
9457: operation_seq_num,
9458: resource_seq_num
9459: FROM wip_operation_resources
9460: WHERE wip_entity_id = c_wip_entity_id;
9461:
9462:
9463: BEGIN

Line 9695: FROM wip_operation_resources

9691: BEGIN
9692:
9693: SELECT Min(start_date), Max(completion_date)
9694: INTO l_min_res_usg_start_date,l_max_res_usg_compl_date
9695: FROM wip_operation_resources
9696: WHERE wip_entity_id = l_eam_res_inst_tbl( l_res_inst_usage_tbl_index ).WIP_ENTITY_ID
9697: AND operation_seq_num = l_eam_res_inst_tbl( l_res_inst_usage_tbl_index ).operation_seq_num
9698: AND organization_id = l_eam_res_inst_tbl( l_res_inst_usage_tbl_index ).ORGANIZATION_ID
9699: AND resource_seq_num = l_eam_res_inst_tbl( l_res_inst_usage_tbl_index ).resource_seq_num ;

Line 11443: FROM wip_operation_resources

11439: (l_wip_entity_id NUMBER,l_org_id NUMBER,l_op_seq_num NUMBER,l_res_seq_num NUMBER)
11440: IS
11441: SELECT start_date,
11442: completion_date
11443: FROM wip_operation_resources
11444: WHERE wip_entity_id=l_wip_entity_id
11445: AND organization_id=l_org_id
11446: AND operation_seq_num=l_op_seq_num
11447: AND resource_seq_num=l_res_seq_num;