eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_WORKORDERREP_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 141: mtl_system_items_b_kfv msikfv,

137: wro.quantity_issued as "REQISSUEDQUANTITY",
138: eam_material_allocqty_pkg.open_quantity(WRO.WIP_ENTITY_ID,WRO.OPERATION_SEQ_NUM,WRO.ORGANIZATION_ID,WRO.INVENTORY_ITEM_ID,WRO.REQUIRED_QUANTITY,WRO.QUANTITY_ISSUED) as "REQQUANTITYOPEN" ,
139: eam_material_allocqty_pkg.allocated_quantity(WRO.WIP_ENTITY_ID,WRO.OPERATION_SEQ_NUM,WRO.ORGANIZATION_ID,WRO.INVENTORY_ITEM_ID) as "REQALLOCATEDQUANTITY")) Material
140: FROM
141: mtl_system_items_b_kfv msikfv,
142: MTL_SYSTEM_ITEMS M,
143: MTL_ITEM_LOCATIONS L,
144: MFG_LOOKUPS LU,
145: WIP_REQUIREMENT_OPERATIONS WRO,

Line 1002: mtl_system_items_b_kfv msi,

998: msi.concatenated_segments,
999: cii.instance_number,cii.serial_number into l_wip_entity_name,l_organization_id,l_asset_group,l_instance_number,l_serial_number
1000: from wip_discrete_jobs wdj,
1001: csi_item_instances cii,
1002: mtl_system_items_b_kfv msi,
1003: wip_entities we
1004: where wdj.wip_entity_id=p_wip_entity_id(i)
1005: and wdj.wip_entity_id=we.wip_entity_id
1006: and cii.instance_id(+) = DECODE(wdj.maintenance_object_type,3,wdj.maintenance_object_id,NULL)

Line 1012: from mtl_system_items_b_kfv msi,

1008: and wdj.organization_id=msi.organization_id;
1009:
1010: begin
1011: select msi.concatenated_segments into l_asset_activity
1012: from mtl_system_items_b_kfv msi,
1013: wip_discrete_jobs wdj
1014: where wdj.primary_item_id=msi.inventory_item_id and
1015: wdj.organization_id=msi.organization_id and
1016: wdj.wip_entity_id=p_wip_entity_id(i) ;

Line 1248: from eam_work_orders_v wewdv ,mtl_system_items_b_kfv msi,eam_pm_schedulings eps,bom_departments bd,mfg_lookups lu1,mfg_lookups lu2

1244: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(eps.base_date), calendar_aware => FND_DATE.calendar_aware_alt) as "BASEDATE",
1245: bd.description as "DEPTDESCRIPTION"),
1246: XMLConcat(l_xmlTemp3,l_xmlTypeFailureData,l_xmlType1,l_xmlTypeOperation,l_xmlTypeMaterial,l_xmlTypeResource,l_xmlTypeDirectMaterial,l_xmlTypeShortAttachment,
1247: l_xmlTypeLongAttachment,l_xmlTypefileattachment,l_xmlTypeWorkRequest,l_xmlTypeMeter,l_xmlTypeQualityPlan,l_xmlTypeAssetBom,l_xmlTypeAssetroutecomp,l_xmlTypePermits,l_xmlTypeClearances,l_xmlTypeParamList))) AS "RESULT" into l_xmlType
1248: from eam_work_orders_v wewdv ,mtl_system_items_b_kfv msi,eam_pm_schedulings eps,bom_departments bd,mfg_lookups lu1,mfg_lookups lu2
1249: ,fnd_common_lookups flm1,fnd_common_lookups flm2,fnd_common_lookups flm3,fnd_common_lookups flm4 ,fnd_common_lookups flm5
1250: where wewdv.wip_entity_id=p_wip_entity_id(i)
1251: and msi.inventory_item_id(+)= wewdv.primary_item_id
1252: and msi.organization_id(+)=wewdv.organization_id