VIEW: APPS.OKI_BILL_HIST_V

Source

View Text - Preformatted

SELECT sil.chr_id contract_id ,sil.cle_id contract_line_id ,sil.contract_number contract_number ,sil.contract_number_modifier contract_number_modifier ,sil.line_number line_number ,btn.trx_date invoice_date ,btn.trx_number invoice_number ,btn.trx_amount invoice_amount ,btn.currency_code currency_code ,btn.trx_class invoice_class ,bcl.amount line_amount ,bcl.date_billed_from date_billed_from ,bcl.date_billed_to date_billed_to ,bcl.bill_action FROM OKI_SOLD_ITM_LINES SIL,OKS_BILL_CONT_LINES BCL,OKS_BILL_TRANSACTIONS BTN WHERE btn.id = bcl.btn_id and bcl.cle_id = sil.cle_id

View Text - HTML Formatted

SELECT SIL.CHR_ID CONTRACT_ID
, SIL.CLE_ID CONTRACT_LINE_ID
, SIL.CONTRACT_NUMBER CONTRACT_NUMBER
, SIL.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, SIL.LINE_NUMBER LINE_NUMBER
, BTN.TRX_DATE INVOICE_DATE
, BTN.TRX_NUMBER INVOICE_NUMBER
, BTN.TRX_AMOUNT INVOICE_AMOUNT
, BTN.CURRENCY_CODE CURRENCY_CODE
, BTN.TRX_CLASS INVOICE_CLASS
, BCL.AMOUNT LINE_AMOUNT
, BCL.DATE_BILLED_FROM DATE_BILLED_FROM
, BCL.DATE_BILLED_TO DATE_BILLED_TO
, BCL.BILL_ACTION
FROM OKI_SOLD_ITM_LINES SIL
, OKS_BILL_CONT_LINES BCL
, OKS_BILL_TRANSACTIONS BTN
WHERE BTN.ID = BCL.BTN_ID
AND BCL.CLE_ID = SIL.CLE_ID