DBA Data[Home] [Help]

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