[Home] [Help] [Dependency Information]
Object Name: | PO_BC_DISTRIBUTIONS# |
---|---|
Object Type: | VIEW |
Owner: | PO |
Subobject Name: | |
Status: | VALID |
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_LINK_TYPE | VARCHAR2 | (30) | ||
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) |
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#;
|
|
|