DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on STANDARD

Line 109: BOM_STANDARD_OPERATIONS BS,

105: eam_op_completion_txns_v eoctv,
106: FND_COMMON_LOOKUPS LU1,
107: MFG_LOOKUPS LU2,
108: WIP_OPERATIONS WO,
109: BOM_STANDARD_OPERATIONS BS,
110: BOM_DEPARTMENTS BD
111: WHERE BD.DEPARTMENT_ID = WO.DEPARTMENT_ID
112: AND NVL(BS.OPERATION_TYPE,1) = 1 and
113: eoctv.wip_entity_id(+)=wo.wip_entity_id and

Line 121: AND BS.STANDARD_OPERATION_ID (+) = WO.STANDARD_OPERATION_ID

117: AND LU2.LOOKUP_CODE(+) = WO.SHUTDOWN_TYPE
118: AND LU2.LOOKUP_TYPE(+) = 'BOM_EAM_SHUTDOWN_TYPE'
119: AND LU1.LOOKUP_CODE(+) = WO.OPERATION_COMPLETED
120: AND LU1.LOOKUP_TYPE(+) = 'EAM_YES_NO'
121: AND BS.STANDARD_OPERATION_ID (+) = WO.STANDARD_OPERATION_ID
122: ORDER BY WO.OPERATION_SEQ_NUM;
123:
124: --Cursor for Materials
125: