[Home] [Help]
[Dependency Information]
VIEW: APPS.RA_SALESREPS
Object Details
Object Name: | RA_SALESREPS |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AR.RA_SALESREPS
|
---|
Subobject Name: | |
Status: | VALID |
View Type
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
Backward compatible single-org view for ra_salesreps_all
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
SALESREP_ID |
NUMBER |
|
Yes |
|
LAST_UPDATE_DATE |
DATE |
|
Yes |
|
LAST_UPDATED_BY |
NUMBER |
|
Yes |
|
CREATION_DATE |
DATE |
|
Yes |
|
CREATED_BY |
NUMBER |
|
Yes |
|
LAST_UPDATE_LOGIN |
NUMBER |
|
|
|
SALES_CREDIT_TYPE_ID |
NUMBER |
|
Yes |
|
NAME |
VARCHAR2 |
(360) |
|
|
SALESREP_NUMBER |
VARCHAR2 |
(30) |
|
|
STATUS |
VARCHAR2 |
(30) |
|
|
START_DATE_ACTIVE |
DATE |
|
Yes |
|
END_DATE_ACTIVE |
DATE |
|
|
|
GL_ID_REV |
NUMBER |
|
|
|
GL_ID_FREIGHT |
NUMBER |
|
|
|
GL_ID_REC |
NUMBER |
|
|
|
SET_OF_BOOKS_ID |
NUMBER |
|
|
|
ATTRIBUTE_CATEGORY |
VARCHAR2 |
(30) |
|
|
ATTRIBUTE1 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE2 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE3 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE4 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE5 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE6 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE7 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE8 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE9 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE10 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE11 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE12 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE13 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE14 |
VARCHAR2 |
(150) |
|
|
ATTRIBUTE15 |
VARCHAR2 |
(150) |
|
|
ORG_ID |
NUMBER |
|
|
|
EMAIL_ADDRESS |
VARCHAR2 |
(2000) |
|
|
ASSIGNED_TO_USER_ID |
NUMBER |
|
|
|
COST_CENTER |
VARCHAR2 |
(30) |
|
|
CHARGE_TO_COST_CENTER |
VARCHAR2 |
(30) |
|
|
COMPENSATION_CURRENCY_CODE |
VARCHAR2 |
(15) |
|
|
WH_UPDATE_DATE |
DATE |
|
|
|
PERSON_ID |
NUMBER |
|
|
|
TYPE |
VARCHAR2 |
(30) |
Yes |
|
SALES_TAX_GEOCODE |
VARCHAR2 |
(30) |
|
|
SALES_TAX_INSIDE_CITY_LIMITS |
VARCHAR2 |
(1) |
|
|
COMMISSIONABLE_FLAG |
VARCHAR2 |
(1) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT SALESREP_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SALES_CREDIT_TYPE_ID
, NAME
, SALESREP_NUMBER
, STATUS
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, GL_ID_REV
, GL_ID_FREIGHT
, GL_ID_REC
, SET_OF_BOOKS_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORG_ID
, EMAIL_ADDRESS
, ASSIGNED_TO_USER_ID
, COST_CENTER
, CHARGE_TO_COST_CENTER
, COMPENSATION_CURRENCY_CODE
, WH_UPDATE_DATE
, PERSON_ID
, TYPE
, SALES_TAX_GEOCODE
, SALES_TAX_INSIDE_CITY_LIMITS
, COMMISSIONABLE_FLAG
FROM APPS.RA_SALESREPS;
Dependencies
[top of page]
APPS.RA_SALESREPS references the following:
-
APPS
-
JTF_RS_RESOURCE_EXTNS_VL
-
JTF_RS_SALESREPS_MO_V
APPS.RA_SALESREPS is referenced by following:
-
APPS
-
ARFV_AR_TRANSACTIONS
-
ARFV_CREDITS
-
ARFV_CREDIT_MEMO_ARS
-
ARFV_CUSTOMERS
-
ARFV_CUSTOMER_SITES
-
ARFV_DEBITS
-
ARFV_INVOICE_ARS
-
ARFV_NON_REVENUE_CREDITS
-
ARFV_ON_ACCOUNT_CREDIT_MEMOS
-
ARFV_REVENUE_CREDITS
-
ARFV_SALES_CREDITS
-
ARPT_SQL_FUNC_UTIL
- show dependent code
-
ARPT_SQL_FUNC_UTIL
- show dependent code
-
ARP_AUTO_ACCOUNTING
- show dependent code
-
ARP_CORRECT_CC_ERRORS
- show dependent code
-
ARP_PROCESS_CREDIT
- show dependent code
-
ARP_PROCESS_CREDIT
- show dependent code
-
ARP_PROCESS_CREDIT_UTIL
- show dependent code
-
ARP_PROCESS_CREDIT_UTIL
- show dependent code
-
ARP_TRX_VALIDATE
- show dependent code
-
AR_CORRECT_GL_LINES_V
-
AR_DEPOSIT_API_PUB
- show dependent code
-
AR_DEPOSIT_LIB_PVT
- show dependent code
-
AR_INVOICE_ADJ_V
-
AR_INVOICE_DEFAULT_PVT
- show dependent code
-
AR_INVOICE_HEADER_V
-
AR_INVOICE_UTILS
- show dependent code
-
AR_LATE_CHARGE_PKG
- show dependent code
-
AR_MO_CACHE_UTILS
- show dependent code
-
AR_PURGE
- show dependent code
-
AR_RAAPI_UTIL
- show dependent code
-
AR_REVENUE_ADJUSTMENT_PVT
- show dependent code
-
AR_REVENUE_ADJUSTMENT_PVT
- show dependent code
-
AR_SITE_USES_V
-
AR_XML_INVOICE_V
-
ASO_I_RA_SALESREPS_V
-
ASO_ORDER_INT
- show dependent code
-
ECE_CDMO_HEADER_V
-
GMF_AR_GET_SALESREPS
- show dependent code
-
IBU_ORDER_CAPTURE
- show dependent code
-
ICX_CST_SALES_REP_30DAY_V
-
ICX_CST_SALES_REP_7DAY_V
-
ICX_CST_SALES_REP_90DAY_V
-
IGIRRPI
- show dependent code
-
INV_LABEL_PVT10
- show dependent code
-
JL_BR_AR_GENERATE_DEBIT_MEMO
- show dependent code
-
OE_AK_SALESREPS_V
-
OE_AUDIT_HISTORY_PVT
- show dependent code
-
OE_BIS_SALESPERSON
- show dependent code
-
OE_BLANKET_HDRS_HIST_V
-
OE_BLANKET_HEADERS_V
-
OE_BULK_ACK_PVT
- show dependent code
-
OE_BULK_CACHE
- show dependent code
-
OE_BULK_VALUE_TO_ID
- show dependent code
-
OE_CNCL_VALUE_TO_ID
- show dependent code
-
OE_CRM_SALES_CREDITS_V
-
OE_ERROR_WF
- show dependent code
-
OE_FLEX_COGS_PUB
- show dependent code
-
OE_HEADER_SCREDIT_UTIL
- show dependent code
-
OE_HOLDS_PVT
- show dependent code
-
OE_ID_TO_VALUE
- show dependent code
-
OE_INVOICE_PUB
- show dependent code
-
OE_ITORD_PUB
- show dependent code
-
OE_ITORD_UTIL
- show dependent code
-
OE_LINE_SCREDIT_UTIL
- show dependent code
-
OE_OE_FORM_HEADER
- show dependent code
-
OE_OE_FORM_LINE
- show dependent code
-
OE_OE_HTML_HEADER
- show dependent code
-
OE_ORDER_CACHE
- show dependent code
-
OE_VALUE_TO_ID
- show dependent code
-
OKL_ARINTF_PVT
- show dependent code
-
OKL_BPD_ADVANCED_BILLING_PVT
- show dependent code
-
OKL_INVESTOR_BILLING_PVT
- show dependent code
-
OZF_AR_INTERFACE_PVT
- show dependent code
-
OZF_OM_PAYMENT_PVT
- show dependent code
-
PA_SALESREPS
- show dependent code
-
PNP_UTIL_FUNC
- show dependent code
-
PN_EXP_TO_AR
- show dependent code
-
PN_INDEX_LEASE_COMMON_PKG
- show dependent code
-
QP_ID_TO_VALUE
- show dependent code
-
QP_UTIL
- show dependent code
-
RA_CUSTOMER_TRX_CM_V
-
RA_CUSTOMER_TRX_CR_TRX_V
-
RA_CUST_TRX_LINE_SALESREPS_V
-
SO_SALESPERSONS_ACTIVE_V
-
SO_SALES_CREDITS_V
-
WSH_FLEX_PKG_COGS
- show dependent code
-
ZX_TAXWARE_USER_PKG
- show dependent code
-
ZX_VTX_USER_PKG
- show dependent code