eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.OKI_SBILLHIST_DTL_V

Source

View Text - Preformatted


SELECT SIL.CHR_ID , SIL.SLE_ID , SIL.CONTRACT_NUMBER , SIL.CONTRACT_NUMBER_MODIFIER , SIL.COMPLETE_K_NUMBER , BTN.TRX_DATE DATE_BILLED , BTN.TRX_NUMBER INVOICE_NUMBER , BTN.TRX_AMOUNT INVOICE_AMOUNT , BTN.TRX_AMOUNT * SIL.TRX_FUNC_CURR_RATE INVOICE_AMOUNT_F , BTN.TRX_AMOUNT * SIL.TRX_FUNC_CURR_RATE * SIL.FUNC_GLOBAL_CURR_RATE INVOICE_AMOUNT_G , BTN.TRX_AMOUNT * SIL.TRX_FUNC_CURR_RATE * SIL.FUNC_SGLOBAL_CURR_RATE INVOICE_AMOUNT_SG , BTN.CURRENCY_CODE CURRENCY_CODE , SIL.CURR_CODE_F CURR_CODE_F , SIL.CURR_CODE_G CURR_CODE_G , SIL.CURR_CODE_SG CURR_CODE_SG , BTN.TRX_CLASS INVOICE_CLASS , BCL.AMOUNT LINE_AMOUNT , BCL.AMOUNT * SIL.TRX_FUNC_CURR_RATE LINE_AMOUNT_F , BCL.AMOUNT * SIL.TRX_FUNC_CURR_RATE * SIL.FUNC_GLOBAL_CURR_RATE LINE_AMOUNT_G , BCL.AMOUNT * SIL.TRX_FUNC_CURR_RATE * SIL.FUNC_SGLOBAL_CURR_RATE LINE_AMOUNT_SG , BCL.DATE_BILLED_FROM DATE_BILLED_FROM , BCL.DATE_BILLED_TO DATE_BILLED_TO , BCL.BILL_ACTION FROM OKI_SRM_005_V SIL , OKS_BILL_CONT_LINES BCL , OKS_BILL_TRANSACTIONS BTN WHERE BTN.ID = BCL.BTN_ID AND BCL.CLE_ID = SIL.SLE_ID

View Text - HTML Formatted

SELECT SIL.CHR_ID
, SIL.SLE_ID
, SIL.CONTRACT_NUMBER
, SIL.CONTRACT_NUMBER_MODIFIER
, SIL.COMPLETE_K_NUMBER
, BTN.TRX_DATE DATE_BILLED
, BTN.TRX_NUMBER INVOICE_NUMBER
, BTN.TRX_AMOUNT INVOICE_AMOUNT
, BTN.TRX_AMOUNT * SIL.TRX_FUNC_CURR_RATE INVOICE_AMOUNT_F
, BTN.TRX_AMOUNT * SIL.TRX_FUNC_CURR_RATE * SIL.FUNC_GLOBAL_CURR_RATE INVOICE_AMOUNT_G
, BTN.TRX_AMOUNT * SIL.TRX_FUNC_CURR_RATE * SIL.FUNC_SGLOBAL_CURR_RATE INVOICE_AMOUNT_SG
, BTN.CURRENCY_CODE CURRENCY_CODE
, SIL.CURR_CODE_F CURR_CODE_F
, SIL.CURR_CODE_G CURR_CODE_G
, SIL.CURR_CODE_SG CURR_CODE_SG
, BTN.TRX_CLASS INVOICE_CLASS
, BCL.AMOUNT LINE_AMOUNT
, BCL.AMOUNT * SIL.TRX_FUNC_CURR_RATE LINE_AMOUNT_F
, BCL.AMOUNT * SIL.TRX_FUNC_CURR_RATE * SIL.FUNC_GLOBAL_CURR_RATE LINE_AMOUNT_G
, BCL.AMOUNT * SIL.TRX_FUNC_CURR_RATE * SIL.FUNC_SGLOBAL_CURR_RATE LINE_AMOUNT_SG
, BCL.DATE_BILLED_FROM DATE_BILLED_FROM
, BCL.DATE_BILLED_TO DATE_BILLED_TO
, BCL.BILL_ACTION
FROM OKI_SRM_005_V SIL
, OKS_BILL_CONT_LINES BCL
, OKS_BILL_TRANSACTIONS BTN
WHERE BTN.ID = BCL.BTN_ID
AND BCL.CLE_ID = SIL.SLE_ID