DBA Data[Home] [Help]

APPS.WIP_PERF_TO_PLAN dependencies on WIP_FLOW_SCHEDULES

Line 306: wip_flow_schedules wfs

302: select nvl(sum(mmt.primary_quantity),0) into complete_quantity
303: from
304: mtl_material_transactions mmt,
305: wip_entities we,
306: wip_flow_schedules wfs
307: where mmt.transaction_source_type_id = 5
308: and mmt.transaction_action_id in (31,32)
309: and wfs.organization_id = perf_rec.organization_id
310: and wfs.primary_item_id = perf_rec.inventory_item_id

Line 333: wip_flow_schedules wfs

329: select nvl(sum(mmt.primary_quantity),0) into complete_quantity
330: from
331: mtl_material_transactions mmt,
332: wip_entities we,
333: wip_flow_schedules wfs
334:
335: where mmt.transaction_source_type_id = 5
336: and mmt.transaction_action_id in (31,32)
337: and wfs.organization_id = perf_rec.organization_id