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


VIEW: APPS.PO_ECX_DISTRBN_ARCH_V

Object Details
Object Name: PO_ECX_DISTRBN_ARCH_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_ECX_DISTRBN_ARCH_V
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 Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
REVISION_NUM NUMBER

Document revision number
PO_RELEASE_ID NUMBER

Release unique identifier
PO_DISTRIBUTION_ID NUMBER
Yes Document distribution unique identifier
PO_HEADER_ID NUMBER
Yes Document header unique identifier
PO_LINE_ID NUMBER

Document line unique identifier
PO_LINE_LOC_ID NUMBER

Document shipment schedule unique identifier
DISTRIBUTION_NUM NUMBER
Yes Distribution number
PROJECT_NUM VARCHAR2 (4000)
User-defined number that uniquely identifies the project.
PROJECT_TYPE VARCHAR2 (20)
The project type that classifies the project and defaults project information upon project entry
TASK_NUM VARCHAR2 (25)
User-defined number that uniquely identifies the task within a project. It is recommended to number tasks based on the wbs since that is how tasks are ordered in some reports. However note: task numbers do not record the wbs structure
QTY_ORDERED NUMBER

Quantity ordered on the distribution
CONVERSION_RATE NUMBER

Currency conversion rate
CONV_RATE_DATE DATE

Currency conversion date
DESTINATION_TYPE VARCHAR2 (25)
Final destination of the purchased items
REQUESTOR VARCHAR2 (240)
Concatenation of last name, title, first name, middle names and the name the person is known by.
DFF_DIST_ATTR1 VARCHAR2 (30)
Descriptive flexfield segment
DFF_DIST_ATTR2 VARCHAR2 (150)
Descriptive flexfield segment
DFF_DIST_ATTR3 VARCHAR2 (150)
Descriptive flexfield segment
DFF_DIST_ATTR4 VARCHAR2 (150)
Descriptive flexfield segment
DFF_DIST_ATTR5 VARCHAR2 (150)
Descriptive flexfield segment
DFF_DIST_ATTR6 VARCHAR2 (150)
Descriptive flexfield segment
DFF_DIST_ATTR7 VARCHAR2 (150)
Descriptive flexfield segment
DFF_DIST_ATTR8 VARCHAR2 (150)
Descriptive flexfield segment
DFF_DIST_ATTR9 VARCHAR2 (150)
Descriptive flexfield segment
DFF_DIST_ATTR10 VARCHAR2 (150)
Descriptive flexfield segment
DFF_DIST_ATTR11 VARCHAR2 (150)
Descriptive flexfield segment
DFF_DIST_ATTR12 VARCHAR2 (150)
Descriptive flexfield segment
DFF_DIST_ATTR13 VARCHAR2 (150)
Descriptive flexfield segment
DFF_DIST_ATTR14 VARCHAR2 (150)
Descriptive flexfield segment
DFF_DIST_ATTR15 VARCHAR2 (150)
Descriptive flexfield segment
DFF_DIST_ATTR16 VARCHAR2 (150)
Descriptive flexfield segment
Query Text

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


SELECT REVISION_NUM
,      PO_RELEASE_ID
,      PO_DISTRIBUTION_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_LINE_LOC_ID
,      DISTRIBUTION_NUM
,      PROJECT_NUM
,      PROJECT_TYPE
,      TASK_NUM
,      QTY_ORDERED
,      CONVERSION_RATE
,      CONV_RATE_DATE
,      DESTINATION_TYPE
,      REQUESTOR
,      DFF_DIST_ATTR1
,      DFF_DIST_ATTR2
,      DFF_DIST_ATTR3
,      DFF_DIST_ATTR4
,      DFF_DIST_ATTR5
,      DFF_DIST_ATTR6
,      DFF_DIST_ATTR7
,      DFF_DIST_ATTR8
,      DFF_DIST_ATTR9
,      DFF_DIST_ATTR10
,      DFF_DIST_ATTR11
,      DFF_DIST_ATTR12
,      DFF_DIST_ATTR13
,      DFF_DIST_ATTR14
,      DFF_DIST_ATTR15
,      DFF_DIST_ATTR16
FROM APPS.PO_ECX_DISTRBN_ARCH_V;

Dependencies

[top of page]

APPS.PO_ECX_DISTRBN_ARCH_V references the following:

SchemaAPPS
PL/SQL PackageMRP_GET_PROJECT - show dependent code
SynonymPA_PROJECTS_ALL
SynonymPA_TASKS
SynonymPER_ALL_PEOPLE_F
SynonymPO_DISTRIBUTIONS_ARCHIVE_ALL

APPS.PO_ECX_DISTRBN_ARCH_V is not referenced by any database object