DBA Data[Home] [Help]

APPS.WIP_BFLPROC_PRIV dependencies on MTL_SYSTEM_ITEMS_KFV

Line 149: mtl_system_items_kfv msi,

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

Line 216: mtl_system_items_kfv msi,

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

Line 968: mtl_system_items_kfv msi,

964: 2,milk.concatenated_segments,
965: 1, inv_project.get_pjm_locsegs(milk.concatenated_segments)) locatorName
966: from bom_explosion_temp be,
967: bom_inventory_components bic,
968: mtl_system_items_kfv msi,
969: mtl_item_locations_kfv milk,
970: mtl_parameters mp
971: where be.group_id = v_grpID
972: and be.component_sequence_id = bic.component_sequence_id

Line 2868: FROM mtl_system_items_kfv msik,

2864: msik.lot_control_code,
2865: msik.serial_number_control_code,
2866: msik.inventory_asset_flag,
2867: mmtt.transaction_quantity
2868: FROM mtl_system_items_kfv msik,
2869: mtl_units_of_measure muom
2870: WHERE mmtt.organization_id = msik.organization_id
2871: AND mmtt.inventory_item_id = msik.inventory_item_id
2872: AND msik.primary_uom_code = muom.uom_code)