APPS.CSD_HV_WIP_JOB_PVT dependencies on MTL_SYSTEM_ITEMS

Line 242: from mtl_system_items_kfv mtl

238:
239: Cursor c_item_name (p_inventory_item_id_new number,
240: p_organization_id number) is
241: select mtl.concatenated_segments
242: from mtl_system_items_kfv mtl
243: where mtl.inventory_item_id = p_inventory_item_id_new
244: and mtl.organization_id = p_organization_id;
245: BEGIN
246:

Line 1823: from wip_discrete_jobs wdj, mtl_system_items_kfv msi

1819: transaction_quantity,
1820: wdj.completion_subinventory, wdj.completion_locator_id,
1821: msi.primary_uom_code, msi.revision_qty_control_code,
1822: msi.SERIAL_NUMBER_CONTROL_CODE, msi.LOT_CONTROL_CODE
1823: from wip_discrete_jobs wdj, mtl_system_items_kfv msi
1824: where wdj.wip_entity_id = p_comp_job_dtls_rec.wip_entity_id and
1825: wdj.primary_item_id = msi.inventory_item_id and
1826: wdj.organization_id = msi.organization_id;
1827:

Line 1905: from mtl_system_items_b

1901:
1902: CURSOR get_inv_location_control_code ( p_organization_id NUMBER,
1903: p_inventory_item_id NUMBER ) IS
1904: SELECT location_control_code
1905: from mtl_system_items_b
1906: where
1907: organization_id = p_organization_id and
1908: inventory_item_id = p_inventory_item_id;
1909:

Line 2913: select location_control_code from mtl_system_items_b where

2909: secondary_inventory_name = p_secondary_inventory_name;
2910:
2911: CURSOR get_inv_location_control_code ( p_organization_id NUMBER,
2912: p_inventory_item_id NUMBER ) IS
2913: select location_control_code from mtl_system_items_b where
2914: organization_id = p_organization_id and
2915: inventory_item_id = p_inventory_item_id;
2916:
2917:

Line 4724: select location_control_code from mtl_system_items_b where

4720:
4721:
4722: CURSOR get_inv_location_control_code ( p_organization_id NUMBER,
4723: p_inventory_item_id NUMBER ) IS
4724: select location_control_code from mtl_system_items_b where
4725: organization_id = p_organization_id and
4726: inventory_item_id = p_inventory_item_id;
4727:
4728:

Line 4739: from mtl_system_items_b where

4735:
4736: CURSOR get_wip_supply_info ( p_organization_id NUMBER,
4737: p_inventory_item_id NUMBER ) IS
4738: select wip_supply_type, wip_supply_subinventory, wip_supply_locator_id
4739: from mtl_system_items_b where
4740: organization_id = p_organization_id and
4741: inventory_item_id = p_inventory_item_id;
4742: --bug#8465719 end
4743:

Line 6377: FROM mtl_system_items

6373: p_item_id NUMBER
6374: )
6375: IS
6376: SELECT serial_number_control_code
6377: FROM mtl_system_items
6378: WHERE organization_id = p_org_id AND inventory_item_id = p_item_id;
6379:
6380:
6381: Cursor c_get_serial_info(p_item_id number, p_serial_number varchar2, p_org_id number) is

Line 7187: FROM mtl_system_items

7183: p_item_id NUMBER
7184: )
7185: IS
7186: SELECT serial_number_control_code
7187: FROM mtl_system_items
7188: WHERE organization_id = p_org_id AND inventory_item_id = p_item_id;
7189:
7190:
7191: Cursor c_get_serial_info(p_item_id number, p_serial_number varchar2, p_org_id number) is

Line 8059: MTL_SYSTEM_ITEMS_KFV MSIK,

8055: , CWTD.create_ro_flag --bug#13698799 auto create ro, parent ro
8056: FROM
8057: CSD_REPAIR_JOB_XREF CRJX,
8058: WIP_REQUIREMENT_OPERATIONS WRO,
8059: MTL_SYSTEM_ITEMS_KFV MSIK,
8060: WIP_ENTITIES WE,
8061: CSD_WIP_TRANSACTION_DETAILS CWTD,
8062: WIP_DISCRETE_JOBS WDJ,
8063: WIP_OPERATIONS WO,

Line 8460: mtl_system_items_kfv msik,

8456: BOM_DEPARTMENTS BD,
8457: wip_discrete_jobs wdj,
8458: wip_entities we,
8459: mfg_lookups ml,
8460: mtl_system_items_kfv msik,
8461: csd_service_codes_vl cscv,
8462: csd_wip_transaction_details WTD,
8463: bom_standard_operations bso
8464: WHERE