DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on FND_COMMON_LOOKUPS

Line 99: FND_COMMON_LOOKUPS LU1,

95: fnd_date.date_to_displayDT(Convert_to_client_time(eoctv.actual_start_date)) as "OPACTUALSTARTDATE",
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

Line 995: ,fnd_common_lookups flm1,fnd_common_lookups flm2,fnd_common_lookups flm3,fnd_common_lookups flm4 ,fnd_common_lookups flm5

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
999: and lu1.lookup_code(+)=wewdv.firm_planned_flag