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

TABLE: JA.JAI_PO_COPYDOC_T

Object Details
Object Name: JAI_PO_COPYDOC_T
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_PO_COPYDOC_T
Subobject Name:
Status: VALID


Temporary table used to store data of Purchase orders during Copy functionality.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
TYPE VARCHAR2 (2)
Indicates the PO Document type that is getting created.
PO_HEADER_ID NUMBER

Foreign key to PO_HEADERS_ALL.po_header_id.
PO_LINE_ID NUMBER

Foreign key to PO_LINES_ALL.po_line_id.
LINE_LOCATION_ID NUMBER

Foreign key to PO_LINE_LOCATIONS_ALL.line_location_id.
LINE_NUM NUMBER

Indicates the Copied PO Line number that got created.
SHIPMENT_NUM NUMBER

Indicates the Copied PO Shipment number that got created.
ITEM_ID NUMBER

Indicates Inventory Item identifier with which the PO Line is created.
FROM_HEADER_ID NUMBER

Indicates the po_header_id from which the Copy document happened.
FROM_TYPE_LOOKUP_CODE VARCHAR2 (25)
Indicates the type lookup code of the document from which the copy document happened.
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
OBJECT_VERSION_NUMBER NUMBER

Object version number
Query Text

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


SELECT TYPE
,      PO_HEADER_ID
,      PO_LINE_ID
,      LINE_LOCATION_ID
,      LINE_NUM
,      SHIPMENT_NUM
,      ITEM_ID
,      FROM_HEADER_ID
,      FROM_TYPE_LOOKUP_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_PO_COPYDOC_T;

Dependencies

[top of page]

JA.JAI_PO_COPYDOC_T does not reference any database object

JA.JAI_PO_COPYDOC_T is referenced by following:

SchemaAPPS
SynonymJAI_PO_COPYDOC_T