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.

[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on MFG_LOOKUPS

Line 107: MFG_LOOKUPS LU2,

103: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(eoctv.actual_end_date),calendar_aware => FND_DATE.calendar_aware_alt) as "OPACTUALENDDATE")) Operation
104: FROM
105: eam_op_completion_txns_v eoctv,
106: FND_COMMON_LOOKUPS LU1,
107: MFG_LOOKUPS LU2,
108: WIP_OPERATIONS WO,
109: BOM_STANDARD_OPERATIONS BS,
110: BOM_DEPARTMENTS BD
111: WHERE BD.DEPARTMENT_ID = WO.DEPARTMENT_ID

Line 144: MFG_LOOKUPS LU,

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
147: WHERE
148: msikfv.organization_id = wro.organization_id

Line 185: MFG_LOOKUPS LU,

181: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WOR.COMPLETION_DATE), calendar_aware => FND_DATE.calendar_aware_alt) as "RESCOMPLETIONDATE")) Resources
182: FROM
183: BOM_RESOURCES BR,
184: CST_ACTIVITIES CA,
185: MFG_LOOKUPS LU,
186: WIP_OPERATION_RESOURCES WOR
187: WHERE BR.ORGANIZATION_ID = WOR.ORGANIZATION_ID
188: AND WOR.WIP_ENTITY_ID = p_wip_id
189: AND BR.RESOURCE_ID = WOR.RESOURCE_ID

Line 377: mfg_lookups ml1,

373: from
374: wip_eam_work_requests wewr,
375: fnd_user fu,
376: bom_departments bd,
377: mfg_lookups ml1,
378: mfg_lookups ml2
379: where
380: fu.user_id = wewr.created_by
381: and bd.department_id = wewr.work_request_owning_dept

Line 378: mfg_lookups ml2

374: wip_eam_work_requests wewr,
375: fnd_user fu,
376: bom_departments bd,
377: mfg_lookups ml1,
378: mfg_lookups ml2
379: where
380: fu.user_id = wewr.created_by
381: and bd.department_id = wewr.work_request_owning_dept
382: and ml1.lookup_type (+) = 'WIP_EAM_WORK_REQ_STATUS'

Line 496: mfg_lookups ml

492: qpv.plan_type_meaning as "PLANTYPE") QualityPlan
493: FROM
494: QA_PLANS_VAL_V qpv,
495: qa_plan_transactions qpt,
496: mfg_lookups ml
497: Where qpt.plan_id=qpv.plan_id
498: and ml.lookup_code=qpt.mandatory_collection_flag
499: and ml.lookup_type='SYS_YES_NO'
500: and nvl(p_quality_flag,2)=decode(p_quality_flag,1,qpt.mandatory_collection_flag,2,p_quality_flag,2)

Line 522: mfg_lookups lu

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
523: where bic.effectivity_date <= sysdate
524: and (bic.disable_date >= sysdate or
525: bic.disable_date is null)
526: and wdj.maintenance_object_id = cii.instance_id

Line 552: mfg_lookups lu

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
554: and (bic.disable_date >= sysdate or
555: bic.disable_date is null)
556: and wdj.wip_entity_id =p_wip_id

Line 627: mfg_lookups ml

623: from
624: EAM_WORK_PERMITS EWP,
625: EAM_SAFETY_ASSOCIATIONS ESA,
626: EAM_PERMIT_STATUSES_VL EPSV,
627: mfg_lookups ml
628: WHERE EWP.PERMIT_ID = ESA.SOURCE_ID
629: AND ESA.TARGET_REF_ID =p_wip_id
630: AND EWP.ORGANIZATION_ID =p_org_id
631: AND EPSV.STATUS_ID =EWP.USER_DEFINED_STATUS_ID

Line 648: mfg_lookups ml1

644: FROM EAM_WORK_PERMITS EWP1,
645: EAM_SAFETY_ASSOCIATIONS ESA1,
646: eam_safety_associations esa2,
647: EAM_PERMIT_STATUSES_VL EPSV1,
648: mfg_lookups ml1
649: WHERE EWP1.PERMIT_ID = ESA1.SOURCE_ID
650: AND ESA2.TARGET_REF_ID =p_wip_id
651: AND esa2.source_id =esa1.target_ref_id
652: AND esa2.association_type =4

Line 706: mfg_lookups ml1 ,

702: FROM
703: eam_work_clearances ewc ,
704: eam_safety_associations esa ,
705: wip_discrete_jobs wdj ,
706: mfg_lookups ml1 ,
707: mfg_lookups ml2 ,
708: EAM_WORK_CLEARANCE_STATUSES_VL ewsv,
709: eam_isolations iso
710: WHERE esa.target_ref_id =wdj.wip_entity_id

Line 707: mfg_lookups ml2 ,

703: eam_work_clearances ewc ,
704: eam_safety_associations esa ,
705: wip_discrete_jobs wdj ,
706: mfg_lookups ml1 ,
707: mfg_lookups ml2 ,
708: EAM_WORK_CLEARANCE_STATUSES_VL ewsv,
709: eam_isolations iso
710: WHERE esa.target_ref_id =wdj.wip_entity_id
711: AND esa.source_id =ewc.WORK_CLEARANCE_ID

Line 739: mfg_lookups ml3 ,

735: FROM eam_work_clearances ewc1 ,
736: eam_work_permits permit ,
737: eam_safety_associations esa1 ,
738: eam_safety_associations esa2 ,
739: mfg_lookups ml3 ,
740: mfg_lookups ml4 ,
741: eam_work_clearance_statuses_vl ewsv1,
742: eam_isolations iso1 ,
743: wip_discrete_jobs wdj1

Line 740: mfg_lookups ml4 ,

736: eam_work_permits permit ,
737: eam_safety_associations esa1 ,
738: eam_safety_associations esa2 ,
739: mfg_lookups ml3 ,
740: mfg_lookups ml4 ,
741: eam_work_clearance_statuses_vl ewsv1,
742: eam_isolations iso1 ,
743: wip_discrete_jobs wdj1
744: WHERE esa2.source_id =permit.permit_id

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