[Home] [Help] [Dependency Information]
Object Name: | PO_ENCUMBRANCE_GT1 |
---|---|
Object Type: | TABLE |
Owner: | PO |
FND Design Data: | PO.PO_ENCUMBRANCE_GT1 |
Subobject Name: | |
Status: | VALID |
PO.PO_ENCUMBRANCE_GT1 is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PO_ENCUMBRANCE_GT1_N1 | NORMAL | NONUNIQUE | DISTRIBUTION_ID | |
PO_ENCUMBRANCE_GT1_N2 | NORMAL | NONUNIQUE | SEQUENCE_NUM | |
PO_ENCUMBRANCE_GT1_N3 | NORMAL | NONUNIQUE | ORIGIN_SEQUENCE_NUM | |
PO_ENCUMBRANCE_GT1_N4 | NORMAL | NONUNIQUE | REFERENCE15 | |
PO_ENCUMBRANCE_GT1_N5 | NORMAL | NONUNIQUE | REQ_DISTRIBUTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADJUSTMENT_STATUS | VARCHAR2 | (5) | ||
DISTRIBUTION_TYPE | VARCHAR2 | (25) | ||
HEADER_ID | NUMBER | |||
PO_RELEASE_ID | NUMBER | |||
LINE_ID | NUMBER | |||
LINE_LOCATION_ID | NUMBER | |||
DISTRIBUTION_ID | NUMBER | |||
FROM_HEADER_ID | NUMBER | |||
SOURCE_DISTRIBUTION_ID | NUMBER | |||
REQ_DISTRIBUTION_ID | NUMBER | |||
SEGMENT1 | VARCHAR2 | (20) | ||
LINE_NUM | NUMBER | |||
SHIPMENT_NUM | NUMBER | |||
DISTRIBUTION_NUM | NUMBER | |||
REFERENCE_NUM | VARCHAR2 | (25) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
COMMENTS | VARCHAR2 | (240) | ||
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
BUDGET_ACCOUNT_ID | NUMBER | |||
GL_ENCUMBERED_DATE | DATE | |||
LINE_TYPE_ID | NUMBER | |||
ACCRUE_ON_RECEIPT_FLAG | VARCHAR2 | (1) | ||
AMOUNT_TO_ENCUMBER | NUMBER | |||
UNENCUMBERED_AMOUNT | NUMBER | |||
ENCUMBERED_AMOUNT | NUMBER | |||
AMOUNT_ORDERED | NUMBER | |||
AMOUNT_DELIVERED | NUMBER | |||
AMOUNT_BILLED | NUMBER | |||
AMOUNT_CANCELLED | NUMBER | |||
UNENCUMBERED_QUANTITY | NUMBER | |||
QUANTITY_ORDERED | NUMBER | |||
QUANTITY_DELIVERED | NUMBER | |||
QUANTITY_BILLED | NUMBER | |||
QUANTITY_CANCELLED | NUMBER | |||
QUANTITY_ON_LINE | NUMBER | |||
UNIT_MEAS_LOOKUP_CODE | VARCHAR2 | (25) | ||
ITEM_ID | NUMBER | |||
PRICE | NUMBER | |||
NONRECOVERABLE_TAX | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
RATE | NUMBER | |||
TRANSFERRED_TO_OE_FLAG | VARCHAR2 | (1) | ||
SOURCE_TYPE_CODE | VARCHAR2 | (25) | ||
CANCEL_FLAG | VARCHAR2 | (1) | ||
CLOSED_CODE | VARCHAR2 | (30) | ||
ENCUMBERED_FLAG | VARCHAR2 | (1) | ||
ENCUMBRANCE_REQUIRED_FLAG | VARCHAR2 | (1) | ||
APPROVED_FLAG | VARCHAR2 | (1) | ||
PREVENT_ENCUMBRANCE_FLAG | VARCHAR2 | (1) | ||
PROJECT_ID | NUMBER | |||
TASK_ID | NUMBER | |||
AWARD_NUM | VARCHAR2 | (15) | ||
EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
EXPENDITURE_ORGANIZATION_ID | NUMBER | |||
EXPENDITURE_ITEM_DATE | DATE | |||
VENDOR_ID | NUMBER | |||
ROW_INDEX | NUMBER | |||
SEQUENCE_NUM | NUMBER | |||
ORIGIN_SEQUENCE_NUM | NUMBER | |||
AGREEMENT_DIST_ID | NUMBER | |||
AMOUNT_BASED_FLAG | VARCHAR2 | (1) | ||
CUR_PRECISION_FOREIGN | NUMBER | |||
MIN_ACCT_UNIT_FOREIGN | NUMBER | |||
PRE_ROUND_AMT | NUMBER | |||
FINAL_AMT | NUMBER | |||
AMT_TO_ENCUMBER_FUNC | NUMBER | |||
AMT_ORDERED | NUMBER | |||
AMT_CLOSED | NUMBER | |||
AMT_OPEN | NUMBER | |||
QTY_ORDERED | NUMBER | |||
QTY_CLOSED | NUMBER | |||
QTY_OPEN | NUMBER | |||
ENCUMBERED_AMOUNT_CHANGE | NUMBER | |||
UOM_CONVERSION_RATE | NUMBER | |||
ENTERED_CR | NUMBER | |||
ACCOUNTED_CR | NUMBER | |||
ENTERED_DR | NUMBER | |||
ACCOUNTED_DR | NUMBER | |||
PERIOD_NAME | VARCHAR2 | (15) | ||
PERIOD_YEAR | NUMBER | |||
PERIOD_NUM | NUMBER | |||
QUARTER_NUM | NUMBER | |||
JE_CATEGORY_NAME | VARCHAR2 | (25) | ||
JE_LINE_DESCRIPTION | VARCHAR2 | (240) | ||
ENCUMBRANCE_TYPE_ID | NUMBER | |||
CODE_COMBINATION_ID | 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) | ||
REFERENCE15 | VARCHAR2 | (100) | ||
GL_STATUS_CODE | VARCHAR2 | (1) | ||
GL_RESULT_CODE | VARCHAR2 | (3) | ||
RESULT_TYPE | VARCHAR2 | (1) | ||
RESULT_TEXT | VARCHAR2 | (2000) | ||
UPDATE_ENCUMBERED_AMOUNT_FLAG | VARCHAR2 | (1) | ||
NONRECOVERABLE_TAX_RATE | NUMBER | |||
REFERENCE14 | VARCHAR2 | (100) | ||
DOC_LEVEL | VARCHAR2 | (30) | ||
DOC_LEVEL_ID | NUMBER | |||
AMT_CLOSED_FUNC | NUMBER | |||
MODIFIED_BY_AGENT_FLAG | VARCHAR2 | (1) | ||
SEND_TO_GL_FLAG | VARCHAR2 | (1) | ||
ENTERED_AMOUNT | NUMBER | |||
ACCOUNTED_AMOUNT | NUMBER | |||
VALUE_BASIS | VARCHAR2 | (25) | ||
PAYMENT_TYPE | VARCHAR2 | (30) | ||
GL_PERIOD_DATE | DATE | |||
CLM_DOC_FLAG | VARCHAR2 | (1) | ||
FUNDED_VALUE | NUMBER | |||
QUANTITY_FUNDED | NUMBER | |||
AMOUNT_FUNDED | NUMBER | |||
CHANGE_IN_FUNDED_VALUE | NUMBER | |||
AMOUNT_CHANGED_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT ADJUSTMENT_STATUS
, DISTRIBUTION_TYPE
, HEADER_ID
, PO_RELEASE_ID
, LINE_ID
, LINE_LOCATION_ID
, DISTRIBUTION_ID
, FROM_HEADER_ID
, SOURCE_DISTRIBUTION_ID
, REQ_DISTRIBUTION_ID
, SEGMENT1
, LINE_NUM
, SHIPMENT_NUM
, DISTRIBUTION_NUM
, REFERENCE_NUM
, ITEM_DESCRIPTION
, COMMENTS
, USSGL_TRANSACTION_CODE
, BUDGET_ACCOUNT_ID
, GL_ENCUMBERED_DATE
, LINE_TYPE_ID
, ACCRUE_ON_RECEIPT_FLAG
, AMOUNT_TO_ENCUMBER
, UNENCUMBERED_AMOUNT
, ENCUMBERED_AMOUNT
, AMOUNT_ORDERED
, AMOUNT_DELIVERED
, AMOUNT_BILLED
, AMOUNT_CANCELLED
, UNENCUMBERED_QUANTITY
, QUANTITY_ORDERED
, QUANTITY_DELIVERED
, QUANTITY_BILLED
, QUANTITY_CANCELLED
, QUANTITY_ON_LINE
, UNIT_MEAS_LOOKUP_CODE
, ITEM_ID
, PRICE
, NONRECOVERABLE_TAX
, CURRENCY_CODE
, RATE
, TRANSFERRED_TO_OE_FLAG
, SOURCE_TYPE_CODE
, CANCEL_FLAG
, CLOSED_CODE
, ENCUMBERED_FLAG
, ENCUMBRANCE_REQUIRED_FLAG
, APPROVED_FLAG
, PREVENT_ENCUMBRANCE_FLAG
, PROJECT_ID
, TASK_ID
, AWARD_NUM
, EXPENDITURE_TYPE
, EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_ITEM_DATE
, VENDOR_ID
, ROW_INDEX
, SEQUENCE_NUM
, ORIGIN_SEQUENCE_NUM
, AGREEMENT_DIST_ID
, AMOUNT_BASED_FLAG
, CUR_PRECISION_FOREIGN
, MIN_ACCT_UNIT_FOREIGN
, PRE_ROUND_AMT
, FINAL_AMT
, AMT_TO_ENCUMBER_FUNC
, AMT_ORDERED
, AMT_CLOSED
, AMT_OPEN
, QTY_ORDERED
, QTY_CLOSED
, QTY_OPEN
, ENCUMBERED_AMOUNT_CHANGE
, UOM_CONVERSION_RATE
, ENTERED_CR
, ACCOUNTED_CR
, ENTERED_DR
, ACCOUNTED_DR
, PERIOD_NAME
, PERIOD_YEAR
, PERIOD_NUM
, QUARTER_NUM
, JE_CATEGORY_NAME
, JE_LINE_DESCRIPTION
, ENCUMBRANCE_TYPE_ID
, CODE_COMBINATION_ID
, REFERENCE1
, REFERENCE2
, REFERENCE3
, REFERENCE4
, REFERENCE5
, REFERENCE6
, REFERENCE7
, REFERENCE8
, REFERENCE9
, REFERENCE10
, REFERENCE11
, REFERENCE12
, REFERENCE13
, REFERENCE15
, GL_STATUS_CODE
, GL_RESULT_CODE
, RESULT_TYPE
, RESULT_TEXT
, UPDATE_ENCUMBERED_AMOUNT_FLAG
, NONRECOVERABLE_TAX_RATE
, REFERENCE14
, DOC_LEVEL
, DOC_LEVEL_ID
, AMT_CLOSED_FUNC
, MODIFIED_BY_AGENT_FLAG
, SEND_TO_GL_FLAG
, ENTERED_AMOUNT
, ACCOUNTED_AMOUNT
, VALUE_BASIS
, PAYMENT_TYPE
, GL_PERIOD_DATE
, CLM_DOC_FLAG
, FUNDED_VALUE
, QUANTITY_FUNDED
, AMOUNT_FUNDED
, CHANGE_IN_FUNDED_VALUE
, AMOUNT_CHANGED_FLAG
FROM PO.PO_ENCUMBRANCE_GT1;
PO.PO_ENCUMBRANCE_GT1 does not reference any database object
PO.PO_ENCUMBRANCE_GT1 is referenced by following:
|
|
|