DBA Data[Home] [Help]

APPS.WIP_BFLPROC_PRIV dependencies on MTL_SYSTEM_ITEMS_KFV

Line 150: mtl_system_items_kfv msi,

146: msi.location_control_code,
147: mil.project_id,
148: mil.task_id
149: from wip_requirement_operations wro,
150: mtl_system_items_kfv msi,
151: wip_operations wo,
152: mtl_item_locations_kfv milk,
153: wip_discrete_jobs wdj,
154: mtl_parameters mp,

Line 217: mtl_system_items_kfv msi,

213: mil.task_id
214: from wip_requirement_operations wro,
215: wip_repetitive_schedules wrs,
216: wip_repetitive_items wri,
217: mtl_system_items_kfv msi,
218: wip_operations wo,
219: mtl_item_locations_kfv milk,
220: mtl_parameters mp,
221: -- Fixed bug 4692413. We should not refer to column in kfv directly.

Line 952: mtl_system_items_kfv msi,

948: 2,milk.concatenated_segments,
949: 1, inv_project.get_pjm_locsegs(milk.concatenated_segments)) locatorName
950: from bom_explosion_temp be,
951: bom_inventory_components bic,
952: mtl_system_items_kfv msi,
953: mtl_item_locations_kfv milk,
954: mtl_parameters mp
955: where be.group_id = v_grpID
956: and be.component_sequence_id = bic.component_sequence_id

Line 2759: FROM mtl_system_items_kfv msik,

2755: msik.lot_control_code,
2756: msik.serial_number_control_code,
2757: msik.inventory_asset_flag,
2758: mmtt.transaction_quantity
2759: FROM mtl_system_items_kfv msik,
2760: mtl_units_of_measure muom
2761: WHERE mmtt.organization_id = msik.organization_id
2762: AND mmtt.inventory_item_id = msik.inventory_item_id
2763: AND msik.primary_uom_code = muom.uom_code)