DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on EAM_WORK_ORDER_DETAILS

Line 1117: eam_work_order_details ewod,

1113: efs.set_name as "SETNAME",
1114: eafc.comments as "COMMENTS")) into l_xmlTypeFailureData
1115: from eam_asset_failures eaf,
1116: eam_asset_failure_codes eafc,
1117: eam_work_order_details ewod,
1118: wip_discrete_jobs wdj,
1119: eam_failure_set_associations easa,
1120: eam_failure_sets efs
1121: where wdj.wip_entity_id =eaf.source_id and

Line 1138: from eam_work_order_details ewod,csi_counters_tl cct

1134:
1135: --Adding PM Base Meter Name
1136: begin
1137: select XMLFOREST(ewod.warranty_active as "WARRANTYACTIVE",cct.name as "PMBASEMETER") into l_xmlTemp3
1138: from eam_work_order_details ewod,csi_counters_tl cct
1139: where ewod.wip_entity_id=p_wip_entity_id(i)
1140: and ewod.pm_base_meter=cct.counter_id
1141: and cct.language=userenv('Lang');
1142: exception