[Home] [Help]
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
105: AND NVL(BS.OPERATION_TYPE,1) = 1 and
106: eoctv.wip_entity_id(+)=wo.wip_entity_id and
107: eoctv.operation_seq_num(+)=wo.operation_seq_num
200: wip_operation_resources wor,
201: bom_resources br,
202: bom_resource_employees bre,
203: per_people_f ppf,
204: bom_departments bd
205: WHERE wor.wip_entity_id = wori.wip_entity_id and
206: wor.organization_id = wori.organization_id and
207: wor.operation_seq_num = wori.operation_seq_num and
208: wor.resource_seq_num = wori.resource_seq_num and
354: fu.user_name as "WRORIGINATOR")) WorkRequest
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
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