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

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 142: MTL_SYSTEM_ITEMS M,

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,
146: MTL_ITEM_LOCATIONS_KFV milk

Line 160: FROM mtl_system_items

156: AND milk.organization_id (+) = wro.organization_id
157: AND LU.LOOKUP_TYPE = 'WIP_SUPPLY_SHORT'
158: AND LU.LOOKUP_CODE = WRO.WIP_SUPPLY_TYPE
159: AND wro.inventory_item_id in (SELECT inventory_item_id
160: FROM mtl_system_items
161: WHERE stock_enabled_flag = 'Y' AND organization_id = msikfv.organization_id) --bug 13685873
162: ORDER BY WRO.OPERATION_SEQ_NUM;
163:
164: -- Above order by is changed to be in Synch with Self Service WO Details screen.Bug 9735166

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

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