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

VIEW: APPS.OE_INVOICE_TO_ORGS_V

Object Details
Object Name: OE_INVOICE_TO_ORGS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewONT.OE_INVOICE_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
BUSINESS_GROUP_ID VARCHAR2 (0)
COST_ALLOCATION_KEYFLEX_ID VARCHAR2 (0)
LOCATION_ID NUMBER (15) Yes
SOFT_CODING_KEYFLEX_ID VARCHAR2 (0)
START_DATE_ACTIVE VARCHAR2 (0)
NAME VARCHAR2 (40) Yes
COMMENTS VARCHAR2 (0)
END_DATE_ACTIVE VARCHAR2 (0)
INTERNAL_EXTERNAL_FLAG VARCHAR2 (0)
INTERNAL_ADDRESS_LINE VARCHAR2 (0)
TYPE VARCHAR2 (0)
REQUEST_ID VARCHAR2 (0)
PROGRAM_APPLICATION_ID VARCHAR2 (0)
PROGRAM_ID VARCHAR2 (0)
PROGRAM_UPDATE_DATE VARCHAR2 (0)
ATTRIBUTE_CATEGORY VARCHAR2 (0)
ATTRIBUTE1 VARCHAR2 (0)
ATTRIBUTE2 VARCHAR2 (0)
ATTRIBUTE3 VARCHAR2 (0)
ATTRIBUTE4 VARCHAR2 (0)
ATTRIBUTE5 VARCHAR2 (0)
ATTRIBUTE6 VARCHAR2 (0)
ATTRIBUTE7 VARCHAR2 (0)
ATTRIBUTE8 VARCHAR2 (0)
ATTRIBUTE9 VARCHAR2 (0)
ATTRIBUTE10 VARCHAR2 (0)
ATTRIBUTE11 VARCHAR2 (0)
ATTRIBUTE12 VARCHAR2 (0)
ATTRIBUTE13 VARCHAR2 (0)
ATTRIBUTE14 VARCHAR2 (0)
ATTRIBUTE15 VARCHAR2 (0)
ATTRIBUTE16 VARCHAR2 (0)
ATTRIBUTE17 VARCHAR2 (0)
ATTRIBUTE18 VARCHAR2 (0)
ATTRIBUTE19 VARCHAR2 (0)
ATTRIBUTE20 VARCHAR2 (0)
LAST_UPDATE_DATE VARCHAR2 (0)
LAST_UPDATED_BY VARCHAR2 (0)
LAST_UPDATE_LOGIN VARCHAR2 (0)
CREATED_BY VARCHAR2 (0)
CREATION_DATE VARCHAR2 (0)
SITE_USE_ID NUMBER (15) Yes
STATUS VARCHAR2 (1) Yes
ADDRESS_ID NUMBER (15) Yes
PRICE_LIST_ID NUMBER (15)
PAYMENT_TERM_ID NUMBER (15)
FOB_POINT_CODE VARCHAR2 (30)
FREIGHT_TERMS_CODE VARCHAR2 (30)
SHIP_PARTIAL_ALLOWED VARCHAR2 (1)
SHIPPING_METHOD_CODE VARCHAR2 (30)
SALESREP_ID NUMBER (15)
CONTACT_ID NUMBER (15)
PRIMARY_FLAG VARCHAR2 (1) Yes
LOCATION_CODE VARCHAR2 (40) Yes
CUSTOMER_ID NUMBER (15) Yes
ADDRESS_LINE_1 VARCHAR2 (240) Yes
ADDRESS_LINE_2 VARCHAR2 (240)
ADDRESS_LINE_3 VARCHAR2 (240)
ADDRESS_LINE_4 VARCHAR2 (240)
REGION_1 VARCHAR2 (0)
REGION_2 VARCHAR2 (0)
REGION_3 VARCHAR2 (0)
TOWN_OR_CITY VARCHAR2 (60)
POSTAL_CODE VARCHAR2 (60)
COUNTRY VARCHAR2 (60) Yes
COUNTY VARCHAR2 (60)
STATE VARCHAR2 (60)
OVER_SHIPMENT_TOLERANCE NUMBER

UNDER_SHIPMENT_TOLERANCE NUMBER

OVER_RETURN_TOLERANCE NUMBER

UNDER_RETURN_TOLERANCE NUMBER

ORDER_TYPE_ID NUMBER (15)
ADDRESS_STATUS VARCHAR2 (1) Yes
DEFAULT_LINE_SET VARCHAR2 (7)
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
,      PRICE_LIST_ID
,      PAYMENT_TERM_ID
,      FOB_POINT_CODE
,      FREIGHT_TERMS_CODE
,      SHIP_PARTIAL_ALLOWED
,      SHIPPING_METHOD_CODE
,      SALESREP_ID
,      CONTACT_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
,      POSTAL_CODE
,      COUNTRY
,      COUNTY
,      STATE
,      OVER_SHIPMENT_TOLERANCE
,      UNDER_SHIPMENT_TOLERANCE
,      OVER_RETURN_TOLERANCE
,      UNDER_RETURN_TOLERANCE
,      ORDER_TYPE_ID
,      ADDRESS_STATUS
,      DEFAULT_LINE_SET
,      ORG_ID
FROM APPS.OE_INVOICE_TO_ORGS_V;

Dependencies

[top of page]

APPS.OE_INVOICE_TO_ORGS_V references the following:

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

SchemaAPPS
ViewASO_I_ORDER_HEADERS_V
Package BodyECEPOI - show dependent code
Package BodyJAI_OM_WDD_PROCESSING_PKG - show dependent code
Package BodyJAI_OM_WDD_TRIGGER_PKG - show dependent code
ViewOE_AK_INVOICE_TO_ORGS_V
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_CREDIT_PUB - show dependent code
Package BodyOE_DEFAULT_PVT - show dependent code
Package BodyOE_EXTERNAL_CREDIT_PVT - show dependent code
Package BodyOE_EXT_CREDIT_EXPOSURE_PVT - show dependent code
Package BodyOE_HEADER_PAYMENT_UTIL - 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_LINE_PAYMENT_UTIL - show dependent code
Package BodyOE_OE_PRICING_AVAILABILITY - show dependent code
Package BodyOE_ORDER_CACHE - 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 BodyOE_VERIFY_PAYMENT_PUB - show dependent code
Package BodyOZF_FUNDS_PUB - show dependent code