[Home] [Help] [Dependency Information]

TABLE: PO.PO_ENCUMBRANCE_GT1

Object Details

Object Name:	PO_ENCUMBRANCE_GT1
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.PO_ENCUMBRANCE_GT1
Subobject Name:
Status:	VALID

Temporary Table Details

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.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

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

Columns

Query Text

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;

Dependencies

[top of page]

PO.PO_ENCUMBRANCE_GT1 does not reference any database object

PO.PO_ENCUMBRANCE_GT1 is referenced by following:

APPS

PO_ENCUMBRANCE_GT

PO_ENCUMBRANCE_GT1