APPS.CSD_HV_WIP_JOB_PVT dependencies on MTL_SYSTEM_ITEMS

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:

Line 1700: from mtl_system_items_b

1696:
1697: CURSOR get_inv_location_control_code ( p_organization_id NUMBER,
1698: p_inventory_item_id NUMBER ) IS
1699: SELECT location_control_code
1700: from mtl_system_items_b
1701: where
1702: organization_id = p_organization_id and
1703: inventory_item_id = p_inventory_item_id;
1704:

Line 2568: select location_control_code from mtl_system_items_b where

2564: secondary_inventory_name = p_secondary_inventory_name;
2565:
2566: CURSOR get_inv_location_control_code ( p_organization_id NUMBER,
2567: p_inventory_item_id NUMBER ) IS
2568: select location_control_code from mtl_system_items_b where
2569: organization_id = p_organization_id and
2570: inventory_item_id = p_inventory_item_id;
2571:
2572:

Line 5486: FROM mtl_system_items

5482: p_item_id NUMBER
5483: )
5484: IS
5485: SELECT serial_number_control_code
5486: FROM mtl_system_items
5487: WHERE organization_id = p_org_id AND inventory_item_id = p_item_id;
5488:
5489:
5490: Cursor c_get_serial_info(p_item_id number, p_serial_number varchar2, p_org_id number) is

Line 6159: FROM mtl_system_items

6155: p_item_id NUMBER
6156: )
6157: IS
6158: SELECT serial_number_control_code
6159: FROM mtl_system_items
6160: WHERE organization_id = p_org_id AND inventory_item_id = p_item_id;
6161:
6162:
6163: Cursor c_get_serial_info(p_item_id number, p_serial_number varchar2, p_org_id number) is