APPS.EAM_WO_SCHEDULE_PVT dependencies on WIP_OPERATIONS

Line 944: FROM WIP_OPERATIONS WO,

940: DECODE (WOR.BASIS_TYPE, 1, 1, 2, 1, 1) * 3600) USAGE_RATE,
941: DECODE(WOR.SCHEDULED_FLAG, 1, DECODE(WOR.USAGE_RATE_OR_AMOUNT, 0, 2, 1),
942: WOR.SCHEDULED_FLAG) SCHEDULED_FLAG,
943: DR2.AVAILABLE_24_HOURS_FLAG AVAIL_24_HRS_FLAG
944: FROM WIP_OPERATIONS WO,
945: BOM_DEPARTMENT_RESOURCES DR1,
946: BOM_DEPARTMENT_RESOURCES DR2,
947: WIP_OPERATION_RESOURCES WOR,
948: BOM_RESOURCES RES,

Line 969: FROM wip_operations

965: /* Cursor to identify the operation scheduling sequence considering the dependency */
966:
967: CURSOR OP_FWD_SCD_SEQ_CSR IS
968: SELECT -1 "LEVEL", operation_seq_num "OP_SEQ_NUM"
969: FROM wip_operations
970: WHERE wip_entity_id = p_wip_entity_id
971: AND operation_seq_num not in( SELECT prior_operation
972: FROM WIP_OPERATION_NETWORKS
973: WHERE wip_entity_id = p_wip_entity_id

Line 1007: FROM wip_operations

1003:
1004:
1005: CURSOR OP_BWD_SCD_SEQ_CSR IS
1006: SELECT -1 "LEVEL", operation_seq_num "OP_SEQ_NUM"
1007: FROM wip_operations
1008: WHERE wip_entity_id = p_wip_entity_id
1009: AND operation_seq_num not in( SELECT prior_operation
1010: FROM WIP_OPERATION_NETWORKS
1011: WHERE wip_entity_id = p_wip_entity_id

Line 1054: WIP_OPERATIONS WO

1050: FROM BOM_SHIFT_TIMES SHF,
1051: BOM_RESOURCE_SHIFTS RSH,
1052: BOM_DEPARTMENT_RESOURCES BDR,
1053: WIP_OPERATION_RESOURCES WOR,
1054: WIP_OPERATIONS WO
1055: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
1056: AND WO.ORGANIZATION_ID = p_organization_id
1057: AND WO.WIP_ENTITY_ID = WOR.WIP_ENTITY_ID
1058: AND WO.OPERATION_SEQ_NUM = WOR.OPERATION_SEQ_NUM

Line 1079: WIP_OPERATIONS WO

1075: FROM BOM_SHIFT_TIMES SHF,
1076: BOM_RESOURCE_SHIFTS RSH,
1077: BOM_DEPARTMENT_RESOURCES BDR,
1078: WIP_OPERATION_RESOURCES WOR,
1079: WIP_OPERATIONS WO
1080: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
1081: AND WO.ORGANIZATION_ID = p_organization_id
1082: AND WO.WIP_ENTITY_ID = WOR.WIP_ENTITY_ID
1083: AND WO.OPERATION_SEQ_NUM = WOR.OPERATION_SEQ_NUM

Line 1479: UPDATE WIP_OPERATIONS

1475: return;
1476: end if;
1477:
1478:
1479: UPDATE WIP_OPERATIONS
1480: SET FIRST_UNIT_START_DATE = l_op_start_date,
1481: FIRST_UNIT_COMPLETION_DATE = l_op_completion_date,
1482: LAST_UNIT_START_DATE = l_op_start_date,
1483: LAST_UNIT_COMPLETION_DATE = l_op_completion_date

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

1568: l_program_update_date DATE;
1569:
1570: p_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
1571:
1572: TYPE wip_operations_tbl_type is TABLE OF number INDEX BY BINARY_INTEGER;
1573: TYPE wip_op_resource_tbl_type is TABLE OF number INDEX BY BINARY_INTEGER;
1574: TYPE wip_op_res_inst_tbl_type is TABLE OF number INDEX BY BINARY_INTEGER;
1575: TYPE wip_op_r_inst_st_tbl_type is TABLE OF DATE INDEX BY BINARY_INTEGER;
1576: TYPE wip_op_r_inst_end_tbl_type is TABLE OF DATE INDEX BY BINARY_INTEGER;

Line 1578: l_WipOperation_tbl wip_operations_tbl_type;

1574: TYPE wip_op_res_inst_tbl_type is TABLE OF number INDEX BY BINARY_INTEGER;
1575: TYPE wip_op_r_inst_st_tbl_type is TABLE OF DATE INDEX BY BINARY_INTEGER;
1576: TYPE wip_op_r_inst_end_tbl_type is TABLE OF DATE INDEX BY BINARY_INTEGER;
1577:
1578: l_WipOperation_tbl wip_operations_tbl_type;
1579: l_WipOperResource_tbl wip_op_resource_tbl_type;
1580: l_WipOperResInst_tbl wip_op_res_inst_tbl_type;
1581: l_WipOperResInstSt_tbl wip_op_r_inst_st_tbl_type;
1582: l_WipOperResInstEnd_tbl wip_op_r_inst_end_tbl_type;