DBA Data[Home] [Help]

APPS.CSD_HV_WIP_JOB_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

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 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