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

TABLE: PO.PO_BC_DISTRIBUTIONS

Object Details
Object Name: PO_BC_DISTRIBUTIONS
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_BC_DISTRIBUTIONS
Subobject Name:
Status: VALID


It contains values for most of the sources used as Transaction Objects in XLA for PO. This is one of the main tables on which those Transaction objects derive values for core PO sources.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_BC_DISTRIBUTIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAE_EVENT_ID
PO_BC_DISTRIBUTIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPACKET_ID
ColumnORIGIN_SEQUENCE_NUM
PO_BC_DISTRIBUTIONS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREFERENCE15
PO_BC_DISTRIBUTIONS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDISTRIBUTION_ID
Columns
Name Datatype Length Mandatory Comments
PACKET_ID NUMBER
Yes Packet Id
AE_EVENT_ID NUMBER

Accounting Event Id
STATUS_CODE VARCHAR2 (30) Yes Status Code
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
GL_DATE DATE
Yes GL Date
LEDGER_ID NUMBER
Yes Ledger Id
CURRENCY_CODE VARCHAR2 (30) Yes Currency Code
JE_SOURCE_NAME VARCHAR2 (30) Yes Je Source Name
JE_CATEGORY_NAME VARCHAR2 (30) Yes Je Category Name
ENTERED_AMT NUMBER
Yes Entered Amount
ACCOUNTED_AMT NUMBER
Yes Accounted Amount
CODE_COMBINATION_ID NUMBER
Yes Code Combination Id
DISTRIBUTION_TYPE VARCHAR2 (30)
Distribution Type
HEADER_ID NUMBER

Header Id
DISTRIBUTION_ID NUMBER

Distribution Id
SEQUENCE_NUMBER NUMBER

Sequence Number
SEGMENT1 VARCHAR2 (20)
Key flexfield segment
REFERENCE_NUMBER VARCHAR2 (100)
Reference Number
APPLIED_TO_APPL_ID NUMBER

Applied to Application Id
APPLIED_TO_DIST_LINK_TYPE VARCHAR2 (30)
Backing Reference
APPLIED_TO_DIST_ID_1 NUMBER

Backing Reference Header Id
APPLIED_TO_DIST_ID_2 NUMBER

Backing Reference Distribution Id
APPLIED_TO_DIST_ID_3 NUMBER

Applied to Third Distribution Identifier
APPLIED_TO_DIST_ID_4 NUMBER

Applied to Fourth Distribution Identifier
APPLIED_TO_DIST_ID_5 NUMBER

Applied to Fifth Distribution Identifier
PA_PROJECT_ID NUMBER

Project Id
PA_AWARD_ID NUMBER

Award Id
PA_TASK_ID NUMBER

Task Id
PA_EXP_ORG_ID NUMBER

Expenditure Organization Id
PA_EXP_TYPE VARCHAR2 (30)
Expenditure Type
PA_EXP_ITEM_DATE DATE

Expenditure Item Date
BC_DISTRIBUTION_ID NUMBER
Yes Primary Key
EVENT_TYPE_CODE VARCHAR2 (50)
Event type code
MAIN_OR_BACKING_CODE VARCHAR2 (30)
main dist or backing dist
JE_LINE_DESCRIPTION VARCHAR2 (240)
Journal Entry line description
BACKING_DIST_ENTERED_AMT NUMBER

PYA original entered amount
BACKING_DIST_ACCOUNTED_AMT NUMBER

PYA original accounted amt
PO_RELEASE_ID NUMBER

Release unique identifier
LINE_ID NUMBER

Uniqe Line identifier
LINE_LOCATION_ID NUMBER

Unique Shipment Identifier
ENCUMBRANCE_TYPE_ID NUMBER

Encumbrance Type identifier
LINE_NUMBER NUMBER

Line Number
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REFERENCE1 VARCHAR2 (100)
REFERENCE1
REFERENCE2 VARCHAR2 (100)
REFERENCE2
REFERENCE3 VARCHAR2 (100)
REFERENCE3
REFERENCE4 VARCHAR2 (100)
REFERENCE4
REFERENCE5 VARCHAR2 (100)
Reference5
REFERENCE6 VARCHAR2 (100)
Reference6
REFERENCE7 VARCHAR2 (100)
Reference7
REFERENCE8 VARCHAR2 (100)
Reference8
REFERENCE9 VARCHAR2 (100)
REFERENCE9
REFERENCE10 VARCHAR2 (100)
REFERENCE10
REFERENCE11 VARCHAR2 (100)
REFERENCE11
REFERENCE12 VARCHAR2 (100)
REFERENCE12
REFERENCE13 VARCHAR2 (100)
REFERENCE13
REFERENCE14 VARCHAR2 (100)
REFERENCE14
REFERENCE15 VARCHAR2 (100)
REFERENCE15
APPLIED_TO_ENTITY_CODE VARCHAR2 (25)
Entity Code
APPLIED_TO_HEADER_ID_1 NUMBER

Header ID of the document
APPLIED_TO_HEADER_ID_2 NUMBER

Header ID of the document
APPLIED_TO_HEADER_ID_3 NUMBER

Header ID of the document
APPLIED_TO_HEADER_ID_4 NUMBER

Header ID of the document
ADJUSTMENT_STATUS VARCHAR2 (5)
Adjustment Status
ORIGIN_SEQUENCE_NUM NUMBER

Unique Identifier for Sequence Number of the main document distribution for which the current line is.
ONLINE_REPORT_ID NUMBER

Online Report Unique identifier
CLM_DOC_FLAG VARCHAR2 (1)
Flag to indicate whether it is a CLM document or not
Query Text

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


SELECT PACKET_ID
,      AE_EVENT_ID
,      STATUS_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      GL_DATE
,      LEDGER_ID
,      CURRENCY_CODE
,      JE_SOURCE_NAME
,      JE_CATEGORY_NAME
,      ENTERED_AMT
,      ACCOUNTED_AMT
,      CODE_COMBINATION_ID
,      DISTRIBUTION_TYPE
,      HEADER_ID
,      DISTRIBUTION_ID
,      SEQUENCE_NUMBER
,      SEGMENT1
,      REFERENCE_NUMBER
,      APPLIED_TO_APPL_ID
,      APPLIED_TO_DIST_LINK_TYPE
,      APPLIED_TO_DIST_ID_1
,      APPLIED_TO_DIST_ID_2
,      APPLIED_TO_DIST_ID_3
,      APPLIED_TO_DIST_ID_4
,      APPLIED_TO_DIST_ID_5
,      PA_PROJECT_ID
,      PA_AWARD_ID
,      PA_TASK_ID
,      PA_EXP_ORG_ID
,      PA_EXP_TYPE
,      PA_EXP_ITEM_DATE
,      BC_DISTRIBUTION_ID
,      EVENT_TYPE_CODE
,      MAIN_OR_BACKING_CODE
,      JE_LINE_DESCRIPTION
,      BACKING_DIST_ENTERED_AMT
,      BACKING_DIST_ACCOUNTED_AMT
,      PO_RELEASE_ID
,      LINE_ID
,      LINE_LOCATION_ID
,      ENCUMBRANCE_TYPE_ID
,      LINE_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      REFERENCE6
,      REFERENCE7
,      REFERENCE8
,      REFERENCE9
,      REFERENCE10
,      REFERENCE11
,      REFERENCE12
,      REFERENCE13
,      REFERENCE14
,      REFERENCE15
,      APPLIED_TO_ENTITY_CODE
,      APPLIED_TO_HEADER_ID_1
,      APPLIED_TO_HEADER_ID_2
,      APPLIED_TO_HEADER_ID_3
,      APPLIED_TO_HEADER_ID_4
,      ADJUSTMENT_STATUS
,      ORIGIN_SEQUENCE_NUM
,      ONLINE_REPORT_ID
,      CLM_DOC_FLAG
FROM PO.PO_BC_DISTRIBUTIONS;

Dependencies

[top of page]

PO.PO_BC_DISTRIBUTIONS does not reference any database object

PO.PO_BC_DISTRIBUTIONS is referenced by following:

SchemaPO
ViewPO_BC_DISTRIBUTIONS#