DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 518: mtl_system_items_kfv msik,

514: bic.component_quantity as "QUANTITY",
515: msik.primary_uom_code as "UOM",
516: lu.meaning as "SUPPLYTYPE")) AssetBom
517: from bom_inventory_components bic,
518: mtl_system_items_kfv msik,
519: wip_discrete_jobs wdj,
520: csi_item_instances cii,
521: bom_bill_of_materials bbom,
522: mfg_lookups lu

Line 549: mtl_system_items_kfv msik,

545: bic.component_quantity as "QUANTITY",
546: msik.primary_uom_code as "UOM",
547: lu.meaning as "SUPPLYTYPE")) AssetBom
548: from bom_inventory_components bic,
549: mtl_system_items_kfv msik,
550: wip_discrete_jobs wdj,
551: bom_bill_of_materials bbom,
552: mfg_lookups lu
553: where bic.effectivity_date <= sysdate

Line 1183: from mtl_system_items_kfv msi, wip_discrete_jobs wdj

1179:
1180: --Adding Asset Group Description
1181: begin
1182: select XMLConcat(XMLELEMENT("ASSETGRPDESC",msi.description),l_xmlTemp3) into l_xmlTemp3
1183: from mtl_system_items_kfv msi, wip_discrete_jobs wdj
1184: where nvl(wdj.asset_group_id,wdj.rebuild_item_id)=msi.inventory_item_id
1185: and wdj.organization_id=msi.organization_id
1186: and wdj.wip_entity_id=p_wip_entity_id(i);
1187: exception