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

VIEW: PO.PO_DISTRIBUTIONS_ALL_EBS#

Object Details
Object Name: PO_DISTRIBUTIONS_ALL_EBS#
Object Type: VIEW
Owner: PO
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PO_DISTRIBUTION_ID NUMBER
Yes
LINE_LOCATION_ID NUMBER
Yes
PO_LINE_ID NUMBER
Yes
PO_HEADER_ID NUMBER
Yes
PO_RELEASE_ID NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

QUANTITY_ORDERED NUMBER

QUANTITY_BILLED NUMBER

QUANTITY_CANCELLED NUMBER

DISTRIBUTION_NUM NUMBER

RATE NUMBER

RATE_DATE DATE

ORG_ID NUMBER

EURO_PO_DISTRIBUTION_ID NUMBER

EURO_LINE_LOCATION_ID NUMBER

EURO_PO_LINE_ID NUMBER

EURO_PO_RELEASE_ID NUMBER

EURO_PO_HEADER_ID NUMBER

QUANTITY_DELIVERED NUMBER

AMOUNT_BILLED NUMBER

SOURCE_DISTRIBUTION_ID NUMBER

EURO_SOURCE_DISTRIBUTION_ID NUMBER

SECURITY_GROUP_ID NUMBER

Query Text

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


SELECT PO_DISTRIBUTION_ID
,      LINE_LOCATION_ID
,      PO_LINE_ID
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      CREATION_DATE
,      CREATED_BY
,      QUANTITY_ORDERED
,      QUANTITY_BILLED
,      QUANTITY_CANCELLED
,      DISTRIBUTION_NUM
,      RATE
,      RATE_DATE
,      ORG_ID
,      EURO_PO_DISTRIBUTION_ID
,      EURO_LINE_LOCATION_ID
,      EURO_PO_LINE_ID
,      EURO_PO_RELEASE_ID
,      EURO_PO_HEADER_ID
,      QUANTITY_DELIVERED
,      AMOUNT_BILLED
,      SOURCE_DISTRIBUTION_ID
,      EURO_SOURCE_DISTRIBUTION_ID
,      SECURITY_GROUP_ID
FROM PO.PO_DISTRIBUTIONS_ALL_EBS#;

Dependencies

[top of page]

PO.PO_DISTRIBUTIONS_ALL_EBS# references the following:

SchemaPO
TablePO_DISTRIBUTIONS_ALL_EBS
PO.PO_DISTRIBUTIONS_ALL_EBS# is referenced by following:

SchemaAPPS
SynonymPO_DISTRIBUTIONS_ALL_EBS