DBA Data[Home] [Help]

VIEW: APPS.OKS_BILLPRST_USGDRILL_V

Source

View Text - Preformatted

SELECT bsd.start_Reading previous_counter_reading, bsd.end_reading current_counter_reading, bsd.result net_counter_reading, bsd.bsl_id bsl_id, bsl.cle_id cle_id FROM oks_bill_sub_line_dtls bsd, oks_bill_sub_lines bsl WHERE bsd.bsl_id = bsl.id
View Text - HTML Formatted

SELECT BSD.START_READING PREVIOUS_COUNTER_READING
, BSD.END_READING CURRENT_COUNTER_READING
, BSD.RESULT NET_COUNTER_READING
, BSD.BSL_ID BSL_ID
, BSL.CLE_ID CLE_ID
FROM OKS_BILL_SUB_LINE_DTLS BSD
, OKS_BILL_SUB_LINES BSL
WHERE BSD.BSL_ID = BSL.ID