APPS.ISC_MAINT_LAB_BLG_ETL_PKG dependencies on WIP_OPERATION_RESOURCES

Line 247: ,WIP_OPERATION_RESOURCES wor

243:
244:
245: from
246: WIP_OPERATIONS wo
247: ,WIP_OPERATION_RESOURCES wor
248: ,BOM_RESOURCES br
249: ,ISC_MAINT_WORK_ORDERS_F fact -- get only the work orders that satisfy the G_start_date criteria
250: ,mtl_uom_conversions m1
251:

Line 258: -- courtesy etrm (wip_operation_resources)

254: fact.organization_id = wo.organization_id and -- to get the same organizational work orders.
255: fact.organization_id = wor.organization_id and -- to get the same organizational work orders.
256: fact.organization_id = br.organization_id and -- to get the same organizational work orders.
257: -- departmental level join not required as it is not specified in the join.
258: -- courtesy etrm (wip_operation_resources)
259: nvl(wo.operation_completed,'N') = 'N' and -- to get the non completed operations
260: fact.work_order_id = wo.wip_entity_id and -- to get the same work orders.
261: fact.work_order_id = wor.wip_entity_id and -- to get the same work orders.
262: wo.operation_seq_num = wor.operation_seq_num and -- to get the resource