APPS.ISC_MAINT_LAB_BLG_ETL_PKG dependencies on ISC_MAINT_WORK_ORDERS_F
Line 249: ,ISC_MAINT_WORK_ORDERS_F fact -- get only the work orders that satisfy the G_start_date criteria
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:
252: where
253: fact.status_type in (17,6,3,1) and --to get the work orders in the status draft,released,unreleased and on-hold