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

TABLE: GML.PO_DIST_DTL_EFC

Object Details
Object Name: PO_DIST_DTL_EFC
Object Type: TABLE
Owner: GML
FND Design Data: TableGML.PO_DIST_DTL_EFC
Subobject Name:
Status: VALID


Shadow table of PO_DIST_DTL for EFC migration.
Stores the original values of columns of PO_DIST_DTL that are to be
converted to Euro currency as a part of EFC migration. The table
consists of the primary key columns of PO_DIST_DTL and only the columns
that are actually converted to Euro currency.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
DOC_ID NUMBER
Yes Fk to the document header: "pord" - op_ordr_hdr (purchase order); "recv" - op_recv_hdr (stock recipt)
RECV_SEQ_NO NUMBER
Yes Additional counter.
LINE_ID NUMBER
Yes Fk to document line: "pord" - po_ordr_dtl (purchase order); "recv" - po_recv_dtl (stock receipt)
SEQ_NO NUMBER
Yes Sequence number for the line.
AMOUNT_BASE NUMBER
Yes Monetary amount converted to base currency.
DOC_TYPE VARCHAR2 (4) Yes Determines the origin of the document: "pord" - purchase order; "recv" - stock receipts
SET_OF_BOOKS_ID NUMBER
Yes Set of books ID
CURRENCY_BASE VARCHAR2 (4)
Base currency.
Query Text

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


SELECT DOC_ID
,      RECV_SEQ_NO
,      LINE_ID
,      SEQ_NO
,      AMOUNT_BASE
,      DOC_TYPE
,      SET_OF_BOOKS_ID
,      CURRENCY_BASE
FROM GML.PO_DIST_DTL_EFC;

Dependencies

[top of page]

GML.PO_DIST_DTL_EFC does not reference any database object

GML.PO_DIST_DTL_EFC is referenced by following:

SchemaAPPS
SynonymPO_DIST_DTL_EFC