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

VIEW: APPS.OZF_SD_FROM_ROLE_V

Object Details
Object Name: OZF_SD_FROM_ROLE_V
Object Type: VIEW
Owner: APPS
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.


Contains the distributor information for Ship and debit request


[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUEST_HEADER_ID NUMBER
Yes Request Header ID
DIST_NAME VARCHAR2 (240) Yes Distributor name
DIST_EMAIL VARCHAR2 (2000)
Distributor email
DIST_TEL VARCHAR2 (40)
Distributor phone
PARTNER_CLASSIFICATION_CODE CHAR (19)
Partner classification code
DIST_DUNS_NUMBER CHAR (9)
DUNS number of the distributor
DIST_CATEGORY_CODE VARCHAR2 (30)
Category code of the distributor
DIST_CONTACT_NAME VARCHAR2 (360)
Distributor contact name
DIST_CONTACT_EMAIL VARCHAR2 (2000)
Distributor contact email
DIST_LOCATION_CODE VARCHAR2 (60)
Distributor location code
DIST_ADD1 VARCHAR2 (240)
Distributor Address Line1
DIST_ADD2 VARCHAR2 (240)
Distributor Address Line2
DIST_ADD3 VARCHAR2 (240)
Distributor Address Line3
DIST_CITY VARCHAR2 (30)
Distributor city name
DIST_COUNTRY VARCHAR2 (60)
Country
DIST_POSTAL_CODE VARCHAR2 (30)
zip code
Query Text

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


SELECT REQUEST_HEADER_ID
,      DIST_NAME
,      DIST_EMAIL
,      DIST_TEL
,      PARTNER_CLASSIFICATION_CODE
,      DIST_DUNS_NUMBER
,      DIST_CATEGORY_CODE
,      DIST_CONTACT_NAME
,      DIST_CONTACT_EMAIL
,      DIST_LOCATION_CODE
,      DIST_ADD1
,      DIST_ADD2
,      DIST_ADD3
,      DIST_CITY
,      DIST_COUNTRY
,      DIST_POSTAL_CODE
FROM APPS.OZF_SD_FROM_ROLE_V;

Dependencies

[top of page]

APPS.OZF_SD_FROM_ROLE_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_LOCATIONS_ALL
SynonymHZ_PARTIES
SynonymJTF_RS_RESOURCE_EXTNS
SynonymOZF_SD_REQUEST_HEADERS_ALL_B

APPS.OZF_SD_FROM_ROLE_V is not referenced by any database object