View: SO_COMMITMENTS_V

View Text

SELECT RATRX.TRX_NUMBER "TRX_NUMBER"
, RATRX.TRX_NUMBER "TRX_NUMBER_SERVICE"
, OEAGR.NAME "NAME"
, RATRL.EXTENDED_AMOUNT "EXTENDED_AMOUNT"
, RATRX.START_DATE_COMMITMENT "START_DATE_COMMITMENT"
, RACST.CUSTOMER_NAME "CUSTOMER_NAME"
, RATRX.CUSTOMER_TRX_ID "CUSTOMER_TRX_ID"
, RATRX.BILL_TO_CUSTOMER_ID "BILL_TO_CUSTOMER_ID"
, RATRX.INVOICE_CURRENCY_CODE "INVOICE_CURRENCY_CODE"
, RATRL.INVENTORY_ITEM_ID "INVENTORY_ITEM_ID"
FROM RA_CUSTOMER_TRX RATRX
, RA_CUSTOMER_TRX_LINES RATRL
, RA_CUSTOMERS RACST
, SO_AGREEMENTS OEAGR
, RA_CUST_TRX_TYPES RACTT
WHERE RACTT.TYPE IN ( 'DEP'
, 'GUAR' )
AND RATRX.CUST_TRX_TYPE_ID = RACTT.CUST_TRX_TYPE_ID
AND RATRX.COMPLETE_FLAG = 'Y'
AND SYSDATE BETWEEN NVL( RATRX.START_DATE_COMMITMENT
, SYSDATE )
AND NVL( RATRX.END_DATE_COMMITMENT
, SYSDATE )
AND RACST.CUSTOMER_ID = RATRX.BILL_TO_CUSTOMER_ID
AND OEAGR.AGREEMENT_ID (+) = RATRX.AGREEMENT_ID
AND RATRL.CUSTOMER_TRX_ID = RATRX.CUSTOMER_TRX_ID

Columns