APPS.OPI_DBI_WMS_RTP_F_C dependencies on WMS_OP_PLANS_B

Line 137: wms_op_plans_b oplan,

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

Line 187: wms_op_plans_b oplan,

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

Line 294: wms_op_plans_b oplan,

290: l_login login_id,
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

Line 339: wms_op_plans_b oplan,

335: l_login login_id,
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