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

VIEW: APPS.OE_DELIVER_TO_ORGS_V

Object Details
Object Name: OE_DELIVER_TO_ORGS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewONT.OE_DELIVER_TO_ORGS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (15) Yes Site use identifier.
BUSINESS_GROUP_ID VARCHAR2 (0)
Not used.
COST_ALLOCATION_KEYFLEX_ID VARCHAR2 (0)
Not used.
LOCATION_ID NUMBER (15) Yes Site use identifier
SOFT_CODING_KEYFLEX_ID VARCHAR2 (0)
Not used.
START_DATE_ACTIVE VARCHAR2 (0)
Not used.
NAME VARCHAR2 (40) Yes Site use location name.
COMMENTS VARCHAR2 (0)
Not used.
END_DATE_ACTIVE VARCHAR2 (0)
Not used.
INTERNAL_EXTERNAL_FLAG VARCHAR2 (0)
Not used.
INTERNAL_ADDRESS_LINE VARCHAR2 (0)
Not used.
TYPE VARCHAR2 (0)
Not used.
REQUEST_ID VARCHAR2 (0)
Not used.
PROGRAM_APPLICATION_ID VARCHAR2 (0)
Not used.
PROGRAM_ID VARCHAR2 (0)
Not used.
PROGRAM_UPDATE_DATE VARCHAR2 (0)
Not used.
ATTRIBUTE_CATEGORY VARCHAR2 (0)
Not used.
ATTRIBUTE1 VARCHAR2 (0)
Not used.
ATTRIBUTE2 VARCHAR2 (0)
Not used.
ATTRIBUTE3 VARCHAR2 (0)
Not used.
ATTRIBUTE4 VARCHAR2 (0)
Not used.
ATTRIBUTE5 VARCHAR2 (0)
Not used.
ATTRIBUTE6 VARCHAR2 (0)
Not used.
ATTRIBUTE7 VARCHAR2 (0)
Not used.
ATTRIBUTE8 VARCHAR2 (0)
Not used.
ATTRIBUTE9 VARCHAR2 (0)
Not used.
ATTRIBUTE10 VARCHAR2 (0)
Not used.
ATTRIBUTE11 VARCHAR2 (0)
Not used.
ATTRIBUTE12 VARCHAR2 (0)
Not used.
ATTRIBUTE13 VARCHAR2 (0)
Not used.
ATTRIBUTE14 VARCHAR2 (0)
Not used.
ATTRIBUTE15 VARCHAR2 (0)
Not used.
ATTRIBUTE16 VARCHAR2 (0)
Not used.
ATTRIBUTE17 VARCHAR2 (0)
Not used.
ATTRIBUTE18 VARCHAR2 (0)
Not used.
ATTRIBUTE19 VARCHAR2 (0)
Not used.
ATTRIBUTE20 VARCHAR2 (0)
Not used.
LAST_UPDATE_DATE VARCHAR2 (0)
Not used.
LAST_UPDATED_BY VARCHAR2 (0)
Not used.
LAST_UPDATE_LOGIN VARCHAR2 (0)
Not used.
CREATED_BY VARCHAR2 (0)
Not used.
CREATION_DATE VARCHAR2 (0)
Not used.
SITE_USE_ID NUMBER (15) Yes Site use identifier.
STATUS VARCHAR2 (1) Yes Site use status flag.
ADDRESS_ID NUMBER (15) Yes Identifier for the customer account site. Foreign key to the HZ_CUST_ACCT_SITES_ALL table
BILL_TO_SITE_USE_ID NUMBER (15)
Bill-To site use identifier
PRICE_LIST_ID NUMBER (15)
Price list identifier
FOB_POINT_CODE VARCHAR2 (30)
Free on board point. The FOB point indicates the point at which title of goods is transfered to the buyer.
FREIGHT_TERMS_CODE VARCHAR2 (30)
Lookup code for FREIGHT_TERMS
SHIP_PARTIAL_ALLOWED VARCHAR2 (1)
No longer used.
SHIPPING_METHOD_CODE VARCHAR2 (30)
The name of the preferred ship method.
CONTACT_ID NUMBER (15)
No longer used.
SOLD_FROM_ORG_ID NUMBER (15)
Warehouse identifier.
SHIP_FROM_ORG_ID NUMBER (15)
Warehouse identifier.
PRIMARY_FLAG VARCHAR2 (1) Yes Indicates the primary site for this customer account (Y/N).
LOCATION_CODE VARCHAR2 (40) Yes Site use identifier.
CUSTOMER_ID NUMBER (15) Yes Identifier for a customer account. Foreign key to the HZ_CUST_ACCOUNTS table
ADDRESS_LINE_1 VARCHAR2 (240) Yes First line of address.
ADDRESS_LINE_2 VARCHAR2 (240)
Second line of address.
ADDRESS_LINE_3 VARCHAR2 (240)
Third line of address.
ADDRESS_LINE_4 VARCHAR2 (240)
Fourth line of address.
REGION_1 VARCHAR2 (0)
Not used.
REGION_2 VARCHAR2 (0)
Not used.
REGION_3 VARCHAR2 (0)
Not used.
TOWN_OR_CITY VARCHAR2 (60)
City name.
STATE VARCHAR2 (60)
State.
POSTAL_CODE VARCHAR2 (60)
Postal code.
COUNTRY VARCHAR2 (60) Yes Country.
ADDRESS_STATUS VARCHAR2 (1) Yes Site Status flag. Receivables lookup code for CODE_STATUS
ORG_ID NUMBER (15)
Operating Unit
Query Text

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


SELECT ORGANIZATION_ID
,      BUSINESS_GROUP_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      LOCATION_ID
,      SOFT_CODING_KEYFLEX_ID
,      START_DATE_ACTIVE
,      NAME
,      COMMENTS
,      END_DATE_ACTIVE
,      INTERNAL_EXTERNAL_FLAG
,      INTERNAL_ADDRESS_LINE
,      TYPE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      SITE_USE_ID
,      STATUS
,      ADDRESS_ID
,      BILL_TO_SITE_USE_ID
,      PRICE_LIST_ID
,      FOB_POINT_CODE
,      FREIGHT_TERMS_CODE
,      SHIP_PARTIAL_ALLOWED
,      SHIPPING_METHOD_CODE
,      CONTACT_ID
,      SOLD_FROM_ORG_ID
,      SHIP_FROM_ORG_ID
,      PRIMARY_FLAG
,      LOCATION_CODE
,      CUSTOMER_ID
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      ADDRESS_LINE_4
,      REGION_1
,      REGION_2
,      REGION_3
,      TOWN_OR_CITY
,      STATE
,      POSTAL_CODE
,      COUNTRY
,      ADDRESS_STATUS
,      ORG_ID
FROM APPS.OE_DELIVER_TO_ORGS_V;

Dependencies

[top of page]

APPS.OE_DELIVER_TO_ORGS_V references the following:

SchemaAPPS
SynonymHZ_CUST_ACCT_SITES
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_LOCATIONS
SynonymHZ_PARTY_SITES
APPS.OE_DELIVER_TO_ORGS_V is referenced by following:

SchemaAPPS
ViewOE_AK_DELIVER_TO_ORGS_V
Package BodyOE_BLANKET_UTIL - show dependent code
Package BodyOE_BULK_PROCESS_HEADER - show dependent code
Package BodyOE_CNCL_VALIDATE - show dependent code
Package BodyOE_CNCL_VALIDATE_HEADER - show dependent code
Package BodyOE_CNCL_VALIDATE_LINE - show dependent code
Package BodyOE_CNCL_VALUE_TO_ID - show dependent code
Package BodyOE_HOLDS_PVT - show dependent code
Package BodyOE_ID_TO_VALUE - show dependent code
Package BodyOE_ORDER_CACHE - show dependent code
Package BodyOE_VALIDATE - show dependent code
Package BodyOE_VALIDATE_HEADER - show dependent code
Package BodyOE_VALIDATE_LINE - show dependent code
Package BodyOE_VALUE_TO_ID - show dependent code
Package BodyONT_OEXOECOD_XMLP_PKG - show dependent code