DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 500: mtl_system_items_kfv msik,

496: bic.component_quantity as "QUANTITY",
497: msik.primary_uom_code as "UOM",
498: lu.meaning as "SUPPLYTYPE")) AssetBom
499: from bom_inventory_components bic,
500: mtl_system_items_kfv msik,
501: wip_discrete_jobs wdj,
502: csi_item_instances cii,
503: bom_bill_of_materials bbom,
504: mfg_lookups lu

Line 531: mtl_system_items_kfv msik,

527: bic.component_quantity as "QUANTITY",
528: msik.primary_uom_code as "UOM",
529: lu.meaning as "SUPPLYTYPE")) AssetBom
530: from bom_inventory_components bic,
531: mtl_system_items_kfv msik,
532: wip_discrete_jobs wdj,
533: bom_bill_of_materials bbom,
534: mfg_lookups lu
535: where bic.effectivity_date <= sysdate

Line 930: from mtl_system_items_kfv msi, wip_discrete_jobs wdj

926:
927: --Adding Asset Group Description
928: begin
929: select XMLConcat(XMLELEMENT("ASSETGRPDESC",msi.description),l_xmlTemp3) into l_xmlTemp3
930: from mtl_system_items_kfv msi, wip_discrete_jobs wdj
931: where nvl(wdj.asset_group_id,wdj.rebuild_item_id)=msi.inventory_item_id
932: and wdj.organization_id=msi.organization_id
933: and wdj.wip_entity_id=p_wip_entity_id(i);
934: exception