[Home] [Help]
View: ARFV_REVENUES
Product: | AR - Receivables |
Description: | This shows detailed information about the revenue associated with transaction line items. |
Implementation/DBA Data: |
APPS.ARFV_REVENUES
|
View Text
SELECT CTL.CUSTOMER_TRX_LINE_ID
, CTL.LINE_NUMBER
, CTL.EXTENDED_AMOUNT
, '_LA:CTL.REASON_CODE:AR_LOOKUPS:INVOICING_REASON:MEANING'
, CTL.DESCRIPTION
, CTL.QUANTITY_ORDERED
, CTL.QUANTITY_CREDITED
, CTL.QUANTITY_INVOICED
, CTL.UNIT_SELLING_PRICE
, CTL.SALES_ORDER
, CTL.SALES_ORDER_LINE
, CTL.SALES_ORDER_DATE
, CTL.ACCOUNTING_RULE_DURATION
, CTL.RULE_START_DATE
, CT.TRX_NUMBER
, CT.TRX_DATE
, CT.COMPLETE_FLAG
, CRCT.TRX_NUMBER
, CRCTL.LINE_NUMBER
, COCT.TRX_NUMBER
, COCTL.LINE_NUMBER
, UOM.UNIT_OF_MEASURE
, RUL.NAME
, AOU.NAME
, '_DF:AR:RA_CUSTOMER_TRX_LINES:CTL'
, '_DF:AR:RA_INTERFACE_LINES:CTL'
, '_DF:JG:JG_RA_CUSTOMER_TRX_LINES:CTL'
, 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
, CTL.LAST_UPDATE_DATE
, CTL.LAST_UPDATED_BY
, CTL.CREATION_DATE
, CTL.CREATED_BY
FROM RA_CUSTOMER_TRX_LINES CTL
, RA_CUSTOMER_TRX CT
, RA_CUSTOMER_TRX CRCT
, RA_CUSTOMER_TRX_LINES CRCTL
, RA_CUSTOMER_TRX COCT
, RA_CUSTOMER_TRX_LINES COCTL
, MTL_UNITS_OF_MEASURE UOM
, RA_RULES RUL
, HR_ALL_ORGANIZATION_UNITS AOU
WHERE CTL.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID
AND CTL.LINE_TYPE = 'LINE'
AND CT.PREVIOUS_CUSTOMER_TRX_ID = CRCT.CUSTOMER_TRX_ID (+)
AND CTL.PREVIOUS_CUSTOMER_TRX_LINE_ID = CRCTL.CUSTOMER_TRX_LINE_ID (+)
AND CTL.INITIAL_CUSTOMER_TRX_LINE_ID = COCTL.CUSTOMER_TRX_LINE_ID (+)
AND CT.INITIAL_CUSTOMER_TRX_ID = COCT.CUSTOMER_TRX_ID (+)
AND CTL.UOM_CODE = UOM.UOM_CODE (+)
AND CTL.ACCOUNTING_RULE_ID = RUL.RULE_ID (+)
AND CT.ORG_ID = AOU.ORGANIZATION_ID (+) WITH READ ONLY
Columns
TRANSACTION_LINE_ID |
TRANSACTION_LINE_NUMBER |
AMOUNT |
"_LA:REASON" |
ITEM_DESCRIPTION |
QUANTITY_ORDERED |
QUANTITY_CREDITED |
QUANTITY_INVOICED |
UNIT_PRICE |
SALES_ORDER_NUMBER |
SALES_ORDER_LINE |
SALES_ORDER_DATE |
ACCOUNTING_RULE_DURATION |
RULE_START_DATE |
TRANSACTION_NUMBER |
TRANSACTION_DATE |
TRANSACTION_COMPLETE |
CREDITED_TRANSACTION_NUMBER |
CREDITED_TRANSACTION_LINE_NUM |
COMMITMENT_TRANSACTION_NUMBER |
COMMITMENT_LINE_NUMBER |
UNIT_OF_MEASURE |
ACCOUNTING_RULE |
OPERATING_UNIT |
"_DF:INV_LINE_INFO" |
"_DF:LINE_TRANS" |
"_DF:GLOBAL_FLEX" |
CUSTOMER_TRX_ID |
PREVIOUS_CUSTOMER_TRX_ID |
PREVIOUS_CUSTOMER_TRX_LINE_ID |
INITIAL_CUSTOMER_TRX_LINE_ID |
INVENTORY_ITEM_ID |
MEMO_LINE_ID |
UOM_CODE |
ACCOUNTING_RULE_ID |
ORG_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
Name |