VIEW: APPS.IEX_CUSTOMER_TRX_LINES_V

Source

View Text - Preformatted

SELECT ctl.customer_trx_line_id customer_trx_line_id, ctl.customer_trx_id customer_trx_id, ctl.line_number line_number, ctl.line_type line_type, ctl.description description, nvl(ctl.quantity_credited, ctl.quantity_invoiced) quantity, nvl(ctl.gross_extended_amount, ctl.extended_amount) extended_amount, nvl(ctl.gross_unit_selling_price, ctl.unit_selling_price) unit_selling_price, lines.tax_rate tax_rate, lines.tax_rate_code tax_code FROM ra_customer_trx_lines_all ctl, zx_lines lines WHERE lines.application_id = 222 AND lines.entity_code = 'TRANSACTIONS' AND lines.trx_id = ctl.customer_trx_id AND lines.trx_line_id = ctl.customer_trx_line_id AND lines.internal_organization_id = ctl.org_id

View Text - HTML Formatted

SELECT CTL.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, CTL.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, CTL.LINE_NUMBER LINE_NUMBER
, CTL.LINE_TYPE LINE_TYPE
, CTL.DESCRIPTION DESCRIPTION
, NVL(CTL.QUANTITY_CREDITED
, CTL.QUANTITY_INVOICED) QUANTITY
, NVL(CTL.GROSS_EXTENDED_AMOUNT
, CTL.EXTENDED_AMOUNT) EXTENDED_AMOUNT
, NVL(CTL.GROSS_UNIT_SELLING_PRICE
, CTL.UNIT_SELLING_PRICE) UNIT_SELLING_PRICE
, LINES.TAX_RATE TAX_RATE
, LINES.TAX_RATE_CODE TAX_CODE
FROM RA_CUSTOMER_TRX_LINES_ALL CTL
, ZX_LINES LINES
WHERE LINES.APPLICATION_ID = 222
AND LINES.ENTITY_CODE = 'TRANSACTIONS'
AND LINES.TRX_ID = CTL.CUSTOMER_TRX_ID
AND LINES.TRX_LINE_ID = CTL.CUSTOMER_TRX_LINE_ID
AND LINES.INTERNAL_ORGANIZATION_ID = CTL.ORG_ID