DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on FND_COMMON_LOOKUPS

Line 106: FND_COMMON_LOOKUPS LU1,

102: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(eoctv.actual_start_date),calendar_aware => FND_DATE.calendar_aware_alt) as "OPACTUALSTARTDATE",
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

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

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