APPS.EAM_WORKORDERREP_PVT dependencies on MFG_LOOKUPS

Line 100: MFG_LOOKUPS LU2,

96: fnd_date.date_to_displayDT(Convert_to_client_time(eoctv.actual_end_date)) as "OPACTUALENDDATE")) Operation
97: FROM
98: eam_op_completion_txns_v eoctv,
99: FND_COMMON_LOOKUPS LU1,
100: MFG_LOOKUPS LU2,
101: WIP_OPERATIONS WO,
102: BOM_STANDARD_OPERATIONS BS,
103: BOM_DEPARTMENTS BD
104: WHERE BD.DEPARTMENT_ID = WO.DEPARTMENT_ID

Line 137: MFG_LOOKUPS LU,

133: FROM
134: mtl_system_items_b_kfv msikfv,
135: MTL_SYSTEM_ITEMS M,
136: MTL_ITEM_LOCATIONS L,
137: MFG_LOOKUPS LU,
138: WIP_REQUIREMENT_OPERATIONS WRO,
139: MTL_ITEM_LOCATIONS_KFV milk
140: WHERE
141: msikfv.organization_id = wro.organization_id

Line 176: MFG_LOOKUPS LU,

172: fnd_date.date_to_displayDT(Convert_to_client_time(WOR.COMPLETION_DATE)) as "RESCOMPLETIONDATE")) Resources
173: FROM
174: BOM_RESOURCES BR,
175: CST_ACTIVITIES CA,
176: MFG_LOOKUPS LU,
177: WIP_OPERATION_RESOURCES WOR
178: WHERE BR.ORGANIZATION_ID = WOR.ORGANIZATION_ID
179: AND WOR.WIP_ENTITY_ID = p_wip_id
180: AND BR.RESOURCE_ID = WOR.RESOURCE_ID

Line 359: mfg_lookups ml1,

355: from
356: wip_eam_work_requests wewr,
357: fnd_user fu,
358: bom_departments bd,
359: mfg_lookups ml1,
360: mfg_lookups ml2
361: where
362: fu.user_id = wewr.created_by
363: and bd.department_id = wewr.work_request_owning_dept

Line 360: mfg_lookups ml2

356: wip_eam_work_requests wewr,
357: fnd_user fu,
358: bom_departments bd,
359: mfg_lookups ml1,
360: mfg_lookups ml2
361: where
362: fu.user_id = wewr.created_by
363: and bd.department_id = wewr.work_request_owning_dept
364: and ml1.lookup_type (+) = 'WIP_EAM_WORK_REQ_STATUS'

Line 478: mfg_lookups ml

474: qpv.plan_type_meaning as "PLANTYPE") QualityPlan
475: FROM
476: QA_PLANS_VAL_V qpv,
477: qa_plan_transactions qpt,
478: mfg_lookups ml
479: Where qpt.plan_id=qpv.plan_id
480: and ml.lookup_code=qpt.mandatory_collection_flag
481: and ml.lookup_type='SYS_YES_NO'
482: and nvl(p_quality_flag,2)=decode(p_quality_flag,1,qpt.mandatory_collection_flag,2,p_quality_flag,2)

Line 504: mfg_lookups lu

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
505: where bic.effectivity_date <= sysdate
506: and (bic.disable_date >= sysdate or
507: bic.disable_date is null)
508: and wdj.maintenance_object_id = cii.instance_id

Line 534: mfg_lookups lu

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
536: and (bic.disable_date >= sysdate or
537: bic.disable_date is null)
538: and wdj.wip_entity_id =p_wip_id

Line 994: 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

990: fnd_date.date_to_displayDT(Convert_to_client_time(eps.base_date)) as "BASEDATE",
991: bd.description as "DEPTDESCRIPTION"),
992: XMLConcat(l_xmlTemp3,l_xmlTypeFailureData,l_xmlType1,l_xmlTypeOperation,l_xmlTypeMaterial,l_xmlTypeResource,l_xmlTypeDirectMaterial,l_xmlTypeShortAttachment,
993: l_xmlTypeLongAttachment,l_xmlTypefileattachment,l_xmlTypeWorkRequest,l_xmlTypeMeter,l_xmlTypeQualityPlan,l_xmlTypeAssetBom,l_xmlTypeAssetroutecomp))) AS "RESULT" into l_xmlType
994: 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
995: ,fnd_common_lookups flm1,fnd_common_lookups flm2,fnd_common_lookups flm3,fnd_common_lookups flm4 ,fnd_common_lookups flm5
996: where wewdv.wip_entity_id=p_wip_entity_id(i)
997: and msi.inventory_item_id(+)= wewdv.primary_item_id
998: and msi.organization_id(+)=wewdv.organization_id