eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.QPR_SR_OFFINV_AR_V

Object Details

Object Name:	QPR_SR_OFFINV_AR_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Off invoice adjustment from AR

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_TRX_ID	NUMBER	(15)	Yes	Customer transaction id
H_REASON_CODE	VARCHAR2	(30)		Reason code
SOLD_TO_CUSTOMER_ID	NUMBER	(15)		Sold to customer
ORG_ID	NUMBER	(15)		Organization id
TRX_NUMBER	VARCHAR2	(20)	Yes	Transaction number
TRX_DATE	DATE		Yes	Transaction date
INVOICE_CURRENCY_CODE	VARCHAR2	(15)		Currency code
TRX_TYP_NAME	VARCHAR2	(20)		Transaction type name
TRX_TYPE	VARCHAR2	(20)		Transaction type id
CUST_TRX_TYPE_ID	NUMBER	(15)	Yes	Customer transaction type id
CUSTOMER_TRX_LINE_ID	VARCHAR2	(43)		Transaction line id
L_REASON_CODE	VARCHAR2	(30)		Line reason code
INVENTORY_ITEM_ID	NUMBER	(15)		Item
DESCRIPTION	VARCHAR2	(240)		Item description
QUANTITY_ORDERED	NUMBER			Ordered quantity
UNIT_SELLING_PRICE	NUMBER			Unit selling price
EXTENDED_AMOUNT	NUMBER			Amount
UOM_CODE	VARCHAR2	(3)		UOM
LINE_NUMBER	NUMBER		Yes	Line number

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CUSTOMER_TRX_ID
,      H_REASON_CODE
,      SOLD_TO_CUSTOMER_ID
,      ORG_ID
,      TRX_NUMBER
,      TRX_DATE
,      INVOICE_CURRENCY_CODE
,      TRX_TYP_NAME
,      TRX_TYPE
,      CUST_TRX_TYPE_ID
,      CUSTOMER_TRX_LINE_ID
,      L_REASON_CODE
,      INVENTORY_ITEM_ID
,      DESCRIPTION
,      QUANTITY_ORDERED
,      UNIT_SELLING_PRICE
,      EXTENDED_AMOUNT
,      UOM_CODE
,      LINE_NUMBER
FROM APPS.QPR_SR_OFFINV_AR_V;

Dependencies

[top of page]

APPS.QPR_SR_OFFINV_AR_V references the following:

APPS: FND_PROFILE - show dependent code; HZ_CUST_ACCOUNTS; QPR_SR_UTIL - show dependent code; RA_CUSTOMER_TRX_ALL; RA_CUSTOMER_TRX_LINES_ALL; RA_CUST_TRX_TYPES_ALL

APPS.QPR_SR_OFFINV_AR_V is not referenced by any database object