Skip to content

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

VIEW: PO.PO_BC_DISTRIBUTIONS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
PACKET_ID NUMBER
Yes
AE_EVENT_ID NUMBER

STATUS_CODE VARCHAR2 (30) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
GL_DATE DATE
Yes
LEDGER_ID NUMBER
Yes
CURRENCY_CODE VARCHAR2 (30) Yes
JE_SOURCE_NAME VARCHAR2 (30) Yes
JE_CATEGORY_NAME VARCHAR2 (30) Yes
ENTERED_AMT NUMBER
Yes
ACCOUNTED_AMT NUMBER
Yes
CODE_COMBINATION_ID NUMBER
Yes
DISTRIBUTION_TYPE VARCHAR2 (30)
HEADER_ID NUMBER

DISTRIBUTION_ID NUMBER

SEQUENCE_NUMBER NUMBER

SEGMENT1 VARCHAR2 (20)
REFERENCE_NUMBER VARCHAR2 (100)
APPLIED_TO_APPL_ID NUMBER

APPLIED_TO_DIST_ID_1 NUMBER

APPLIED_TO_DIST_ID_2 NUMBER

APPLIED_TO_DIST_ID_3 NUMBER

APPLIED_TO_DIST_ID_4 NUMBER

APPLIED_TO_DIST_ID_5 NUMBER

PA_PROJECT_ID NUMBER

PA_AWARD_ID NUMBER

PA_TASK_ID NUMBER

PA_EXP_ORG_ID NUMBER

PA_EXP_TYPE VARCHAR2 (30)
PA_EXP_ITEM_DATE DATE

BC_DISTRIBUTION_ID NUMBER
Yes
EVENT_TYPE_CODE VARCHAR2 (50)
MAIN_OR_BACKING_CODE VARCHAR2 (30)
JE_LINE_DESCRIPTION VARCHAR2 (240)
BACKING_DIST_ENTERED_AMT NUMBER

BACKING_DIST_ACCOUNTED_AMT NUMBER

PO_RELEASE_ID NUMBER

LINE_ID NUMBER

LINE_LOCATION_ID NUMBER

ENCUMBRANCE_TYPE_ID NUMBER

LINE_NUMBER NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

REFERENCE1 VARCHAR2 (100)
REFERENCE2 VARCHAR2 (100)
REFERENCE3 VARCHAR2 (100)
REFERENCE4 VARCHAR2 (100)
REFERENCE5 VARCHAR2 (100)
REFERENCE6 VARCHAR2 (100)
REFERENCE7 VARCHAR2 (100)
REFERENCE8 VARCHAR2 (100)
REFERENCE9 VARCHAR2 (100)
REFERENCE10 VARCHAR2 (100)
REFERENCE11 VARCHAR2 (100)
REFERENCE12 VARCHAR2 (100)
REFERENCE13 VARCHAR2 (100)
REFERENCE14 VARCHAR2 (100)
REFERENCE15 VARCHAR2 (100)
APPLIED_TO_ENTITY_CODE VARCHAR2 (25)
APPLIED_TO_HEADER_ID_1 NUMBER

APPLIED_TO_HEADER_ID_2 NUMBER

APPLIED_TO_HEADER_ID_3 NUMBER

APPLIED_TO_HEADER_ID_4 NUMBER

ADJUSTMENT_STATUS VARCHAR2 (5)
ORIGIN_SEQUENCE_NUM NUMBER

ONLINE_REPORT_ID NUMBER

CLM_DOC_FLAG VARCHAR2 (1)
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# references the following:

SchemaPO
TablePO_BC_DISTRIBUTIONS
PO.PO_BC_DISTRIBUTIONS# is referenced by following:

SchemaAPPS
SynonymPO_BC_DISTRIBUTIONS