DBA Data[Home] [Help]

APPS.WIP_PERF_TO_PLAN dependencies on MTL_MATERIAL_TXN_ALLOCATIONS

Line 363: mtl_material_txn_allocations mmta

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)
366: and wrs.organization_id = perf_rec.organization_id
367: and we.primary_item_id = perf_rec.inventory_item_id

Line 395: mtl_material_txn_allocations mmta

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)
398: and wrs.organization_id = perf_rec.organization_id
399: and we.primary_item_id = perf_rec.inventory_item_id