APPS.EAM_WO_SCHEDULE_PVT dependencies on WIP_OPERATIONS

Line 925: FROM WIP_OPERATIONS WO,

921: DECODE (WOR.BASIS_TYPE, 1, 1, 2, 1, 1) * 3600) USAGE_RATE,
922: DECODE(WOR.SCHEDULED_FLAG, 1, DECODE(WOR.USAGE_RATE_OR_AMOUNT, 0, 2, 1),
923: WOR.SCHEDULED_FLAG) SCHEDULED_FLAG,
924: DR2.AVAILABLE_24_HOURS_FLAG AVAIL_24_HRS_FLAG
925: FROM WIP_OPERATIONS WO,
926: BOM_DEPARTMENT_RESOURCES DR1,
927: BOM_DEPARTMENT_RESOURCES DR2,
928: WIP_OPERATION_RESOURCES WOR,
929: BOM_RESOURCES RES,

Line 950: FROM wip_operations

946: /* Cursor to identify the operation scheduling sequence considering the dependency */
947:
948: CURSOR OP_FWD_SCD_SEQ_CSR IS
949: SELECT -1 "LEVEL", operation_seq_num "OP_SEQ_NUM"
950: FROM wip_operations
951: WHERE wip_entity_id = p_wip_entity_id
952: AND operation_seq_num not in( SELECT prior_operation
953: FROM WIP_OPERATION_NETWORKS
954: WHERE wip_entity_id = p_wip_entity_id

Line 988: FROM wip_operations

984:
985:
986: CURSOR OP_BWD_SCD_SEQ_CSR IS
987: SELECT -1 "LEVEL", operation_seq_num "OP_SEQ_NUM"
988: FROM wip_operations
989: WHERE wip_entity_id = p_wip_entity_id
990: AND operation_seq_num not in( SELECT prior_operation
991: FROM WIP_OPERATION_NETWORKS
992: WHERE wip_entity_id = p_wip_entity_id

Line 1035: WIP_OPERATIONS WO

1031: FROM BOM_SHIFT_TIMES SHF,
1032: BOM_RESOURCE_SHIFTS RSH,
1033: BOM_DEPARTMENT_RESOURCES BDR,
1034: WIP_OPERATION_RESOURCES WOR,
1035: WIP_OPERATIONS WO
1036: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
1037: AND WO.ORGANIZATION_ID = p_organization_id
1038: AND WO.WIP_ENTITY_ID = WOR.WIP_ENTITY_ID
1039: AND WO.OPERATION_SEQ_NUM = WOR.OPERATION_SEQ_NUM

Line 1060: WIP_OPERATIONS WO

1056: FROM BOM_SHIFT_TIMES SHF,
1057: BOM_RESOURCE_SHIFTS RSH,
1058: BOM_DEPARTMENT_RESOURCES BDR,
1059: WIP_OPERATION_RESOURCES WOR,
1060: WIP_OPERATIONS WO
1061: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
1062: AND WO.ORGANIZATION_ID = p_organization_id
1063: AND WO.WIP_ENTITY_ID = WOR.WIP_ENTITY_ID
1064: AND WO.OPERATION_SEQ_NUM = WOR.OPERATION_SEQ_NUM

Line 1460: UPDATE WIP_OPERATIONS

1456: return;
1457: end if;
1458:
1459:
1460: UPDATE WIP_OPERATIONS
1461: SET FIRST_UNIT_START_DATE = l_op_start_date,
1462: FIRST_UNIT_COMPLETION_DATE = l_op_completion_date,
1463: LAST_UNIT_START_DATE = l_op_start_date,
1464: LAST_UNIT_COMPLETION_DATE = l_op_completion_date

Line 1553: TYPE wip_operations_tbl_type is TABLE OF number INDEX BY BINARY_INTEGER;

1549: l_program_update_date DATE;
1550:
1551: p_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1552:
1553: TYPE wip_operations_tbl_type is TABLE OF number INDEX BY BINARY_INTEGER;
1554: TYPE wip_op_resource_tbl_type is TABLE OF number INDEX BY BINARY_INTEGER;
1555: TYPE wip_op_res_inst_tbl_type is TABLE OF number INDEX BY BINARY_INTEGER;
1556: TYPE wip_op_r_inst_st_tbl_type is TABLE OF DATE INDEX BY BINARY_INTEGER;
1557: TYPE wip_op_r_inst_end_tbl_type is TABLE OF DATE INDEX BY BINARY_INTEGER;

Line 1559: l_WipOperation_tbl wip_operations_tbl_type;

1555: TYPE wip_op_res_inst_tbl_type is TABLE OF number INDEX BY BINARY_INTEGER;
1556: TYPE wip_op_r_inst_st_tbl_type is TABLE OF DATE INDEX BY BINARY_INTEGER;
1557: TYPE wip_op_r_inst_end_tbl_type is TABLE OF DATE INDEX BY BINARY_INTEGER;
1558:
1559: l_WipOperation_tbl wip_operations_tbl_type;
1560: l_WipOperResource_tbl wip_op_resource_tbl_type;
1561: l_WipOperResInst_tbl wip_op_res_inst_tbl_type;
1562: l_WipOperResInstSt_tbl wip_op_r_inst_st_tbl_type;
1563: l_WipOperResInstEnd_tbl wip_op_r_inst_end_tbl_type;