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

VIEW: APPS.OE_SHIP_TO_ORGS_V

Object Details
Object Name: OE_SHIP_TO_ORGS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewONT.OE_SHIP_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 identifier
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, Lookup code for the CODE_STATUS column.
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
PAYMENT_TERM_ID NUMBER (15)
Payment term 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)
Order Management 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.
DEMAND_CLASS_CODE VARCHAR2 (30)
Demand class (user-defined Lookup used by Oracle Manufacturing)
SALESREP_ID NUMBER (15)
Identifies a salesperson associated with a business site. Also used to default salesrep in the Transactions window. The hierarchy of defaulting would follow from Bill-To site to Ship-To site to Customer, if not a multi-org setup.
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 if this site is the primary site for this customer account. Y for the primary customer account site. N for other customer account sites.
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 for address
ADDRESS_LINE_2 VARCHAR2 (240)
Second line for address
ADDRESS_LINE_3 VARCHAR2 (240)
Third line for address
ADDRESS_LINE_4 VARCHAR2 (240)
Fourth line for 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
STATE VARCHAR2 (60)
State
POSTAL_CODE VARCHAR2 (60)
Postal code
COUNTRY VARCHAR2 (60) Yes Country code from the TERRITORY_CODE column in the FND_TERRITORY table
OVER_SHIPMENT_TOLERANCE NUMBER

Percentage tolerance for over shipment
UNDER_SHIPMENT_TOLERANCE NUMBER

Percentage tolerance for under shipment
DATES_NEGATIVE_TOLERANCE NUMBER

Acceptable range of days prior to a specified date
DATES_POSITIVE_TOLERANCE NUMBER

Acceptable range of days after a specified date
DATE_TYPE_PREFERENCE VARCHAR2 (20)
Preference for ship or arrival dates
OVER_RETURN_TOLERANCE NUMBER

Percentage tolerance for over return
UNDER_RETURN_TOLERANCE NUMBER

Percentage tolerance for under return
ITEM_IDENTIFIER_TYPE VARCHAR2 (30)
Lookup for item cross-reference preference for placing orders
ORDER_TYPE_ID NUMBER (15)
Order type identifier
ADDRESS_STATUS VARCHAR2 (1) Yes Customer 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
,      PAYMENT_TERM_ID
,      FOB_POINT_CODE
,      FREIGHT_TERMS_CODE
,      SHIP_PARTIAL_ALLOWED
,      SHIPPING_METHOD_CODE
,      DEMAND_CLASS_CODE
,      SALESREP_ID
,      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
,      OVER_SHIPMENT_TOLERANCE
,      UNDER_SHIPMENT_TOLERANCE
,      DATES_NEGATIVE_TOLERANCE
,      DATES_POSITIVE_TOLERANCE
,      DATE_TYPE_PREFERENCE
,      OVER_RETURN_TOLERANCE
,      UNDER_RETURN_TOLERANCE
,      ITEM_IDENTIFIER_TYPE
,      ORDER_TYPE_ID
,      ADDRESS_STATUS
,      ORG_ID
FROM APPS.OE_SHIP_TO_ORGS_V;

Dependencies

[top of page]

APPS.OE_SHIP_TO_ORGS_V references the following:

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

SchemaAPPS
Package BodyAHL_OSP_SHIPMENT_PUB - show dependent code
ViewAHL_VENDOR_CUSTOMER_RELS_V
ViewASO_I_ORDER_HEADERS_V
Package BodyECEPOI - show dependent code
Package BodyMRP_CREATE_SCHEDULE_ISO - show dependent code
Package BodyOE_BLANKET_UTIL - show dependent code
Package BodyOE_BULK_VALUE_TO_ID - 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_HOLD_SOURCES_PVT - show dependent code
Package BodyOE_ID_TO_VALUE - show dependent code
Package BodyOE_OE_PRICING_AVAILABILITY - show dependent code
Package BodyOE_ORDER_CACHE - show dependent code
Package BodyOE_ORDER_WF_UTIL - show dependent code
Package BodyOE_SCHEDULE_UTIL - show dependent code
ViewOE_SHIP_TO_ADDRESSES_V
Package BodyOE_VALIDATE_HEADER - show dependent code
Package BodyOE_VALIDATE_LINE - show dependent code
Package BodyOE_VALUE_TO_ID - show dependent code
Package BodyOE_VERIFY_PAYMENT_PUB - show dependent code