DBA Data[Home] [Help]

APPS.EAM_PM_UTILS dependencies on CSI_TRANSACTIONS

Line 66: from csi_counter_readings ccr, csi_transactions cct,

62:
63: /* Bug # 5154927 : Corrected the query for both correctness and performance */
64: CURSOR METER_READING_IDS(P_WIP_ENTITY_ID NUMBER) IS
65: select ccr.counter_value_id meter_reading_id
66: from csi_counter_readings ccr, csi_transactions cct,
67: csi_counter_associations cca, wip_discrete_jobs wdj
68: where ccr.transaction_id = cct.transaction_id
69: and cct.transaction_type_id = 92
70: and cct.source_header_ref_id = wdj.wip_entity_id