98: eam_op_completion_txns_v eoctv,
99: FND_COMMON_LOOKUPS LU1,
100: MFG_LOOKUPS LU2,
101: WIP_OPERATIONS WO,
102: BOM_STANDARD_OPERATIONS BS,
103: BOM_DEPARTMENTS BD
104: WHERE BD.DEPARTMENT_ID = WO.DEPARTMENT_ID
105: AND NVL(BS.OPERATION_TYPE,1) = 1 and
106: eoctv.wip_entity_id(+)=wo.wip_entity_id and
110: AND LU2.LOOKUP_CODE(+) = WO.SHUTDOWN_TYPE
111: AND LU2.LOOKUP_TYPE(+) = 'BOM_EAM_SHUTDOWN_TYPE'
112: AND LU1.LOOKUP_CODE(+) = WO.OPERATION_COMPLETED
113: AND LU1.LOOKUP_TYPE(+) = 'EAM_YES_NO'
114: AND BS.STANDARD_OPERATION_ID (+) = WO.STANDARD_OPERATION_ID
115: ORDER BY WO.OPERATION_SEQ_NUM;
116:
117: --Cursor for Materials
118: