APPS.OPI_DBI_WMS_RTP_F_C dependencies on MTL_SECONDARY_INVENTORIES

Line 138: mtl_secondary_inventories sinv

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
140: nvl(wdth.is_parent, 'N') = 'Y'
141: and wdth.task_type = 2
142: and wdth.status = 6

Line 188: mtl_secondary_inventories sinv

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
190: nvl(wdth.is_parent, 'N') = 'Y'
191: and wdth.task_type = 2
192: and wdth.status = 6

Line 295: mtl_secondary_inventories sinv,

291: l_user user_id
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

Line 340: mtl_secondary_inventories sinv,

336: l_user user_id
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