[Home] [Help]
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
112: AND NVL(BS.OPERATION_TYPE,1) = 1 and
113: eoctv.wip_entity_id(+)=wo.wip_entity_id and
114: eoctv.operation_seq_num(+)=wo.operation_seq_num
209: wip_operation_resources wor,
210: bom_resources br,
211: bom_resource_employees bre,
212: per_people_f ppf,
213: bom_departments bd
214: WHERE wor.wip_entity_id = wori.wip_entity_id and
215: wor.organization_id = wori.organization_id and
216: wor.operation_seq_num = wori.operation_seq_num and
217: wor.resource_seq_num = wori.resource_seq_num and
372: fu.user_name as "WRORIGINATOR")) WorkRequest
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
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