VIEW: APPS.CS_CONTRACTS_BILLING_V

Source

View Text - Preformatted

SELECT E.CONTRACT_BILLING_ID , E.CP_SERVICE_ID , E.CONTRACT_ID , E.CUST_TRX_TYPE_ID , E.BILLED_UNTIL_DATE , E.CURRENCY_CODE , E.LAST_UPDATE_DATE , E.LAST_UPDATED_BY , E.CREATION_DATE , E.CREATED_BY , E.LAST_UPDATE_LOGIN , I.START_DATE_ACTIVE , I.END_DATE_ACTIVE , I.SERVICE_INVENTORY_ITEM_ID , E.TRX_CLASS , DECODE(TRX_CLASS,'INV',TRX_NUMBER, NULL) INV_NUMBER , DECODE(TRX_CLASS,'INV',TRX_DATE, NULL) INV_DATE , DECODE(TRX_CLASS,'INV',TRX_AMOUNT, NULL) INV_AMOUNT , DECODE(TRX_CLASS,'CM',TRX_NUMBER, NULL) CREDIT_NUMBER , DECODE(TRX_CLASS,'CM',TRX_DATE, NULL) CREDIT_DATE , DECODE(TRX_CLASS,'CM',TRX_AMOUNT, NULL) CREDIT_AMOUNT FROM CS_CONTRACTS_BILLING E, CS_CP_SERVICES I WHERE E.CP_SERVICE_ID = I.CP_SERVICE_ID

View Text - HTML Formatted

SELECT E.CONTRACT_BILLING_ID
, E.CP_SERVICE_ID
, E.CONTRACT_ID
, E.CUST_TRX_TYPE_ID
, E.BILLED_UNTIL_DATE
, E.CURRENCY_CODE
, E.LAST_UPDATE_DATE
, E.LAST_UPDATED_BY
, E.CREATION_DATE
, E.CREATED_BY
, E.LAST_UPDATE_LOGIN
, I.START_DATE_ACTIVE
, I.END_DATE_ACTIVE
, I.SERVICE_INVENTORY_ITEM_ID
, E.TRX_CLASS
, DECODE(TRX_CLASS
, 'INV'
, TRX_NUMBER
, NULL) INV_NUMBER
, DECODE(TRX_CLASS
, 'INV'
, TRX_DATE
, NULL) INV_DATE
, DECODE(TRX_CLASS
, 'INV'
, TRX_AMOUNT
, NULL) INV_AMOUNT
, DECODE(TRX_CLASS
, 'CM'
, TRX_NUMBER
, NULL) CREDIT_NUMBER
, DECODE(TRX_CLASS
, 'CM'
, TRX_DATE
, NULL) CREDIT_DATE
, DECODE(TRX_CLASS
, 'CM'
, TRX_AMOUNT
, NULL) CREDIT_AMOUNT
FROM CS_CONTRACTS_BILLING E
, CS_CP_SERVICES I
WHERE E.CP_SERVICE_ID = I.CP_SERVICE_ID