[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

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

JTF_RS_RESOURCE_EXTNS_VL

JTF_RS_SALESREPS_MO_V

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

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

PON_EMD_AR_INTEGRATION_GRP - 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