APPS.WIP_PERF_TO_PLAN dependencies on WIP_ENTITIES

Line 246: wip_entities we,

242: BEGIN
243: select nvl(sum(mmt.primary_quantity),0) into complete_quantity
244: from
245: mtl_material_transactions mmt,
246: wip_entities we,
247: wip_discrete_jobs wdj
248:
249: where mmt.transaction_source_type_id = 5
250: and mmt.transaction_action_id in (31,32)

Line 275: wip_entities we,

271: BEGIN
272: select nvl(sum(mmt.primary_quantity),0) into complete_quantity
273: from
274: mtl_material_transactions mmt,
275: wip_entities we,
276: wip_discrete_jobs wdj
277:
278: where mmt.transaction_source_type_id = 5
279: and mmt.transaction_action_id in (31,32)

Line 305: wip_entities we,

301: BEGIN
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

Line 332: wip_entities we,

328: BEGIN
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)

Line 361: wip_entities we,

357: BEGIN
358: select nvl(sum(mmta.primary_quantity),0) into complete_quantity
359: from
360: wip_repetitive_schedules wrs,
361: wip_entities we,
362: mtl_material_transactions mmt,
363: mtl_material_txn_allocations mmta
364: where mmt.transaction_source_type_id = 5
365: and mmt.transaction_action_id in (31,32)

Line 393: wip_entities we,

389: BEGIN
390: select nvl(sum(mmta.primary_quantity),0) into complete_quantity
391: from
392: wip_repetitive_schedules wrs,
393: wip_entities we,
394: mtl_material_transactions mmt,
395: mtl_material_txn_allocations mmta
396: where mmt.transaction_source_type_id = 5
397: and mmt.transaction_action_id in (31,32)