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


VIEW: APPS.PO_LINES_CHANGE_PRINT

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


ITEM_REVISION VARCHAR2 (3)

LINE_NUM NUMBER


ITEM_DESCRIPTION VARCHAR2 (240)

CANCEL_FLAG VARCHAR2 (1)

CANCEL_DATE DATE


CANCEL_REASON VARCHAR2 (240)

VENDOR_PRODUCT_NUM VARCHAR2 (25)

NOTE_TO_VENDOR VARCHAR2 (480)

PRICE_TO_PRINT NUMBER


QUANTITY_TO_PRINT NUMBER


AMOUNT_TO_PRINT NUMBER


UNIT_OF_MEASURE VARCHAR2 (25)

UN_NUMBER_AND_DESC VARCHAR2 (266)

HAZARD_CLASS VARCHAR2 (40)

LINE_TYPE VARCHAR2 (25)

CONTRACT_NUM VARCHAR2 (25)

PO_QUOTE_NUM VARCHAR2 (20)

VENDOR_QUOTE_NUM VARCHAR2 (25)

QUOTATION_LINE NUMBER


ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
PRICE NUMBER


QUANTITY NUMBER


QUANTITY_COMITTED NUMBER


PO_HEADER_ID NUMBER


PO_LINE_ID NUMBER


PO_RELEASE_ID NUMBER


PO_ITEM_ID NUMBER


ORG_ID NUMBER

Organization identifier
Query Text

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


SELECT REVISION_NUM
,      ITEM_REVISION
,      LINE_NUM
,      ITEM_DESCRIPTION
,      CANCEL_FLAG
,      CANCEL_DATE
,      CANCEL_REASON
,      VENDOR_PRODUCT_NUM
,      NOTE_TO_VENDOR
,      PRICE_TO_PRINT
,      QUANTITY_TO_PRINT
,      AMOUNT_TO_PRINT
,      UNIT_OF_MEASURE
,      UN_NUMBER_AND_DESC
,      HAZARD_CLASS
,      LINE_TYPE
,      CONTRACT_NUM
,      PO_QUOTE_NUM
,      VENDOR_QUOTE_NUM
,      QUOTATION_LINE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PRICE
,      QUANTITY
,      QUANTITY_COMITTED
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_RELEASE_ID
,      PO_ITEM_ID
,      ORG_ID
FROM APPS.PO_LINES_CHANGE_PRINT;

Dependencies

[top of page]

APPS.PO_LINES_CHANGE_PRINT references the following:

SchemaAPPS
SynonymMTL_UNITS_OF_MEASURE
SynonymPO_HAZARD_CLASSES
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINES_ARCHIVE
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_LINE_TYPES
SynonymPO_RELEASES_ALL
SynonymPO_UN_NUMBERS

APPS.PO_LINES_CHANGE_PRINT is not referenced by any database object