DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on CSI_COUNTERS_TL

Line 385: CSI_COUNTERS_TL CTL,

381: CB.uom_code as "METERUOM",
382: TO_NUMBER(NULL) as "NEWREADING",
383: EAM_METERS_UTIL.IS_METER_READING_MANDATORY_V(p_wip_id, nvl(CBS.COUNTER_ID,CB.COUNTER_ID)) as "MANDATORY" )) Meter
384: FROM csi_counters_b CB,
385: CSI_COUNTERS_TL CTL,
386: CSI_COUNTERS_TL CTL2,
387: CSI_COUNTERS_B CBS,
388: CSI_COUNTER_READINGS CCR1,
389: CSI_COUNTER_READINGS CCR2,

Line 386: CSI_COUNTERS_TL CTL2,

382: TO_NUMBER(NULL) as "NEWREADING",
383: EAM_METERS_UTIL.IS_METER_READING_MANDATORY_V(p_wip_id, nvl(CBS.COUNTER_ID,CB.COUNTER_ID)) as "MANDATORY" )) Meter
384: FROM csi_counters_b CB,
385: CSI_COUNTERS_TL CTL,
386: CSI_COUNTERS_TL CTL2,
387: CSI_COUNTERS_B CBS,
388: CSI_COUNTER_READINGS CCR1,
389: CSI_COUNTER_READINGS CCR2,
390: csi_item_instances cii,

Line 886: from eam_work_order_details ewod,csi_counters_tl cct

882:
883: --Adding PM Base Meter Name
884: begin
885: select XMLFOREST(ewod.warranty_active as "WARRANTYACTIVE",cct.name as "PMBASEMETER") into l_xmlTemp3
886: from eam_work_order_details ewod,csi_counters_tl cct
887: where ewod.wip_entity_id=p_wip_entity_id(i)
888: and ewod.pm_base_meter=cct.counter_id
889: and cct.language=userenv('Lang');
890: exception