VIEW: APPS.ARBV_REVENUES

Source

View Text - Preformatted

SELECT /* UNIQUE ATTRIBUTES */ CTL.CUSTOMER_TRX_LINE_ID , /* REGULAR ATTRIBUTES */ CTL.EXTENDED_AMOUNT , '_LA:CTL.REASON_CODE:AR_LOOKUPS:INVOICING_REASON:MEANING' , CTL.DESCRIPTION , CTL.QUANTITY_ORDERED , CTL.QUANTITY_INVOICED , CTL.UNIT_SELLING_PRICE , CTL.SALES_ORDER , CTL.SALES_ORDER_LINE , CTL.SALES_ORDER_DATE , CTL.ACCOUNTING_RULE_DURATION , /* IDS */ CTL.CUSTOMER_TRX_ID , CTL.PREVIOUS_CUSTOMER_TRX_ID , CTL.PREVIOUS_CUSTOMER_TRX_LINE_ID , CTL.INITIAL_CUSTOMER_TRX_LINE_ID , CTL.INVENTORY_ITEM_ID , CTL.MEMO_LINE_ID , CTL.UOM_CODE , CTL.ACCOUNTING_RULE_ID , CTL.ORG_ID , /* WHO COLUMNS */ CTL.LAST_UPDATE_DATE , CTL.LAST_UPDATED_BY , CTL.CREATION_DATE , CTL.CREATED_BY FROM RA_CUSTOMER_TRX_LINES CTL WHERE CTL.LINE_TYPE = 'LINE' WITH READ ONLY

View Text - HTML Formatted

SELECT /* UNIQUE ATTRIBUTES */ CTL.CUSTOMER_TRX_LINE_ID
, /* REGULAR ATTRIBUTES */ CTL.EXTENDED_AMOUNT
, '_LA:CTL.REASON_CODE:AR_LOOKUPS:INVOICING_REASON:MEANING'
, CTL.DESCRIPTION
, CTL.QUANTITY_ORDERED
, CTL.QUANTITY_INVOICED
, CTL.UNIT_SELLING_PRICE
, CTL.SALES_ORDER
, CTL.SALES_ORDER_LINE
, CTL.SALES_ORDER_DATE
, CTL.ACCOUNTING_RULE_DURATION
, /* IDS */ CTL.CUSTOMER_TRX_ID
, CTL.PREVIOUS_CUSTOMER_TRX_ID
, CTL.PREVIOUS_CUSTOMER_TRX_LINE_ID
, CTL.INITIAL_CUSTOMER_TRX_LINE_ID
, CTL.INVENTORY_ITEM_ID
, CTL.MEMO_LINE_ID
, CTL.UOM_CODE
, CTL.ACCOUNTING_RULE_ID
, CTL.ORG_ID
, /* WHO COLUMNS */ CTL.LAST_UPDATE_DATE
, CTL.LAST_UPDATED_BY
, CTL.CREATION_DATE
, CTL.CREATED_BY
FROM RA_CUSTOMER_TRX_LINES CTL
WHERE CTL.LINE_TYPE = 'LINE' WITH READ ONLY