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.EDWBV_TPRT_TPARTNER_LOC_LCV

Object Details

Object Name:	EDWBV_TPRT_TPARTNER_LOC_LCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.EDWBV_TPRT_TPARTNER_LOC_LCV
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

[View Source]

Columns

Name	Datatype	Length	Comments
TPARTNER_LOC_PK	VARCHAR2	(126)
TRADE_PARTNER_FK	VARCHAR2	(81)
ADDRESS_LINE1	VARCHAR2	(240)
ADDRESS_LINE2	VARCHAR2	(240)
ADDRESS_LINE3	VARCHAR2	(240)
ADDRESS_LINE4	VARCHAR2	(240)
CITY	VARCHAR2	(60)
COUNTY	VARCHAR2	(150)
STATE	VARCHAR2	(150)
POSTAL_CODE	VARCHAR2	(60)
PROVINCE	VARCHAR2	(150)
COUNTRY	VARCHAR2	(60)
BUSINESS_TYPE	VARCHAR2	(17)
TPARTNER_LOC_DP	VARCHAR2	(320)
NAME	VARCHAR2	(320)
DATE_FROM	DATE
DATE_TO	DATE
VNDR_PURCH_SITE	VARCHAR2	(1)
VNDR_RFQ_ONLY	VARCHAR2	(1)
VNDR_PAY_SITE	VARCHAR2	(1)
VNDR_PAY_TERMS	VARCHAR2	(50)
CUST_SITE_USE	VARCHAR2	(30)
CUST_LOCATION	VARCHAR2	(40)
CUST_PRIMARY_FLAG	VARCHAR2	(1)
CUST_STATUS	VARCHAR2	(1)
CUST_ORIG_SYS_REF	VARCHAR2	(240)
CUST_SIC_CODE	VARCHAR2	(30)
CUST_PAY_TERMS	VARCHAR2	(50)
CUST_GSA_IND	VARCHAR2	(1)
CUST_SHIP_PARTIAL	VARCHAR2	(1)
CUST_SHIP_VIA	VARCHAR2	(30)
CUST_FOB_POINT	VARCHAR2	(30)
CUST_ORDER_TYPE	VARCHAR2	(30)
CUST_PRICE_LIST	VARCHAR2	(30)
CUST_FREIGHT	VARCHAR2	(30)
CUST_TERRITORY	VARCHAR2	(40)
CUST_TAX_REF	VARCHAR2	(50)
CUST_SORT_PRTY	NUMBER
CUST_TAX_CODE	VARCHAR2	(50)
CUST_DEMAND_CLASS	VARCHAR2	(30)
CUST_TAX_CLASSFN	VARCHAR2	(0)
CUST_TAX_HDR_FLAG	VARCHAR2	(1)
CUST_TAX_ROUND	VARCHAR2	(30)
CUST_SALES_REP	VARCHAR2	(120)
INSTANCE	VARCHAR2	(30)
TPARTNER_LOC_ID	NUMBER
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
CREATION_DATE	DATE		Standard who column - date when this row was created.
USER_ATTRIBUTE1	VARCHAR2	(0)
USER_ATTRIBUTE2	VARCHAR2	(0)
USER_ATTRIBUTE3	VARCHAR2	(0)
USER_ATTRIBUTE4	VARCHAR2	(0)
USER_ATTRIBUTE5	VARCHAR2	(0)
OPERATION_CODE	VARCHAR2	(0)
LEVEL_NAME	VARCHAR2	(13)
_DF:VNDR_SITE:_EDW	VARCHAR2	(33)
_DF:ACCT_SITE:_EDW	VARCHAR2	(34)
_DF:SITE_USES:_EDW	VARCHAR2	(34)

Query Text

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


SELECT TPARTNER_LOC_PK
,      TRADE_PARTNER_FK
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINE4
,      CITY
,      COUNTY
,      STATE
,      POSTAL_CODE
,      PROVINCE
,      COUNTRY
,      BUSINESS_TYPE
,      TPARTNER_LOC_DP
,      NAME
,      DATE_FROM
,      DATE_TO
,      VNDR_PURCH_SITE
,      VNDR_RFQ_ONLY
,      VNDR_PAY_SITE
,      VNDR_PAY_TERMS
,      CUST_SITE_USE
,      CUST_LOCATION
,      CUST_PRIMARY_FLAG
,      CUST_STATUS
,      CUST_ORIG_SYS_REF
,      CUST_SIC_CODE
,      CUST_PAY_TERMS
,      CUST_GSA_IND
,      CUST_SHIP_PARTIAL
,      CUST_SHIP_VIA
,      CUST_FOB_POINT
,      CUST_ORDER_TYPE
,      CUST_PRICE_LIST
,      CUST_FREIGHT
,      CUST_TERRITORY
,      CUST_TAX_REF
,      CUST_SORT_PRTY
,      CUST_TAX_CODE
,      CUST_DEMAND_CLASS
,      CUST_TAX_CLASSFN
,      CUST_TAX_HDR_FLAG
,      CUST_TAX_ROUND
,      CUST_SALES_REP
,      INSTANCE
,      TPARTNER_LOC_ID
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      OPERATION_CODE
,      LEVEL_NAME
,      _DF:VNDR_SITE:_EDW
,      _DF:ACCT_SITE:_EDW
,      _DF:SITE_USES:_EDW
FROM APPS.EDWBV_TPRT_TPARTNER_LOC_LCV;

Dependencies

[top of page]

APPS.EDWBV_TPRT_TPARTNER_LOC_LCV references the following:

APPS: AP_TERMS_TL; EDW_LOCAL_INSTANCE; HZ_CUST_ACCOUNTS; HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_PARTIES; OE_TRANSACTION_TYPES_TL; PO_VENDORS; PO_VENDOR_SITES_ALL; RA_SALESREPS_ALL; RA_TERRITORIES; SO_PRICE_LISTS_TL

APPS.EDWBV_TPRT_TPARTNER_LOC_LCV is referenced by following:

APPS: EDW_TPRT_TPARTNER_LOC_LCV