DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on CSI_COUNTERS_TL

Line 403: CSI_COUNTERS_TL CTL,

399: CB.uom_code as "METERUOM",
400: TO_NUMBER(NULL) as "NEWREADING",
401: EAM_METERS_UTIL.IS_METER_READING_MANDATORY_V(p_wip_id, nvl(CBS.COUNTER_ID,CB.COUNTER_ID)) as "MANDATORY" )) Meter
402: FROM csi_counters_b CB,
403: CSI_COUNTERS_TL CTL,
404: CSI_COUNTERS_TL CTL2,
405: CSI_COUNTERS_B CBS,
406: CSI_COUNTER_READINGS CCR1,
407: CSI_COUNTER_READINGS CCR2,

Line 404: CSI_COUNTERS_TL CTL2,

400: TO_NUMBER(NULL) as "NEWREADING",
401: EAM_METERS_UTIL.IS_METER_READING_MANDATORY_V(p_wip_id, nvl(CBS.COUNTER_ID,CB.COUNTER_ID)) as "MANDATORY" )) Meter
402: FROM csi_counters_b CB,
403: CSI_COUNTERS_TL CTL,
404: CSI_COUNTERS_TL CTL2,
405: CSI_COUNTERS_B CBS,
406: CSI_COUNTER_READINGS CCR1,
407: CSI_COUNTER_READINGS CCR2,
408: csi_item_instances cii,

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