APPS.OPI_DBI_WMS_RTP_F_C dependencies on MTL_SYSTEM_ITEMS

Line 135: mtl_system_items msi,

131: msi.primary_uom_code,
132: wdth.transaction_uom_code
133: from
134: wms_dispatched_tasks_history wdth,
135: mtl_system_items msi,
136: poa_dbi_rtx_f rtx,
137: wms_op_plans_b oplan,
138: mtl_secondary_inventories sinv
139: where

Line 185: mtl_system_items msi,

181: msi.primary_uom_code,
182: wdth.transaction_uom_code
183: from
184: wms_dispatched_tasks_history wdth,
185: mtl_system_items msi,
186: poa_dbi_rtx_f rtx,
187: wms_op_plans_b oplan,
188: mtl_secondary_inventories sinv
189: where

Line 296: mtl_system_items msi,

292: FROM wms_dispatched_tasks_history wdth,
293: poa_dbi_rtx_f rtx,
294: wms_op_plans_b oplan,
295: mtl_secondary_inventories sinv,
296: mtl_system_items msi,
297: opi_dbi_wms_uom_rates rat
298: WHERE nvl(wdth.is_parent, 'N') = 'Y' -- make sure that op plan started after inspections have 18/1/27 and task_type of 2, checked that 18/1/27 is true.. need to check 2
299: and wdth.task_type = 2
300: and wdth.status = 6

Line 341: mtl_system_items msi,

337: FROM wms_dispatched_tasks_history wdth,
338: poa_dbi_rtx_f rtx,
339: wms_op_plans_b oplan,
340: mtl_secondary_inventories sinv,
341: mtl_system_items msi,
342: opi_dbi_wms_uom_rates rat
343: WHERE nvl(wdth.is_parent, 'N') = 'Y' -- make sure that op plan started after inspections have 18/1/27 and task_type of 2, checked that 18/1/27 is true.. need to check 2
344: and wdth.task_type = 2
345: and wdth.status = 6