DBA Data[Home] [Help]

APPS.CSD_HV_WIP_JOB_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 210: from mtl_system_items_kfv mtl

206:
207: Cursor c_item_name (p_inventory_item_id_new number,
208: p_organization_id number) is
209: select mtl.concatenated_segments
210: from mtl_system_items_kfv mtl
211: where mtl.inventory_item_id = p_inventory_item_id_new
212: and mtl.organization_id = p_organization_id;
213: BEGIN
214:

Line 1618: from wip_discrete_jobs wdj, mtl_system_items_kfv msi

1614: transaction_quantity,
1615: wdj.completion_subinventory, wdj.completion_locator_id,
1616: msi.primary_uom_code, msi.revision_qty_control_code,
1617: msi.SERIAL_NUMBER_CONTROL_CODE, msi.LOT_CONTROL_CODE
1618: from wip_discrete_jobs wdj, mtl_system_items_kfv msi
1619: where wdj.wip_entity_id = p_comp_job_dtls_rec.wip_entity_id and
1620: wdj.primary_item_id = msi.inventory_item_id and
1621: wdj.organization_id = msi.organization_id;
1622: