VIEW: APPS.IEX_DISPUTE_LINES_V

Source

View Text - Preformatted

SELECT ral.line_number ,ral.description ,ral.quantity_invoiced ,reql.quantity ,ral.unit_selling_price ,ral.EXTENDED_AMOUNT ,reql.extended_amount ,req.customer_trx_id ,ral.customer_trx_line_id ,req.request_id ,ra.invoice_currency_code from ra_customer_trx ra, ra_customer_trx_lines ral, ra_cm_requests req, ra_cm_request_lines reql WHERE ra.customer_trx_id = ral.customer_trx_id AND ra.customer_trx_id = req.customer_trx_id AND req.request_id = reql.request_id AND ral.customer_trx_line_id = reql.customer_trx_line_id

View Text - HTML Formatted

SELECT RAL.LINE_NUMBER
, RAL.DESCRIPTION
, RAL.QUANTITY_INVOICED
, REQL.QUANTITY
, RAL.UNIT_SELLING_PRICE
, RAL.EXTENDED_AMOUNT
, REQL.EXTENDED_AMOUNT
, REQ.CUSTOMER_TRX_ID
, RAL.CUSTOMER_TRX_LINE_ID
, REQ.REQUEST_ID
, RA.INVOICE_CURRENCY_CODE
FROM RA_CUSTOMER_TRX RA
, RA_CUSTOMER_TRX_LINES RAL
, RA_CM_REQUESTS REQ
, RA_CM_REQUEST_LINES REQL
WHERE RA.CUSTOMER_TRX_ID = RAL.CUSTOMER_TRX_ID
AND RA.CUSTOMER_TRX_ID = REQ.CUSTOMER_TRX_ID
AND REQ.REQUEST_ID = REQL.REQUEST_ID
AND RAL.CUSTOMER_TRX_LINE_ID = REQL.CUSTOMER_TRX_LINE_ID