[Home] [Help] [Dependency Information]

TABLE: PO.PO_REQ_LINES_GT

Object Details

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

For Internal Use Only: This table is global temporary table based on po_requisition_lines_all table. It is used for internal processing of data for PO Approval Submission Checks.

Temporary Table Details

PO.PO_REQ_LINES_GT 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_REQ_LINES_GT_U1	NORMAL	UNIQUE		REQUISITION_LINE_ID
PO_REQ_LINES_GT_N1	NORMAL	NONUNIQUE		REQUISITION_HEADER_ID

Columns

Query Text

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

SELECT REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      CLOSED_REASON
,      CLOSED_DATE
,      TRANSACTION_REASON_CODE
,      QUANTITY_RECEIVED
,      SOURCE_REQ_LINE_ID
,      ORG_ID
,      CANCEL_REASON
,      CLOSED_CODE
,      AGENT_RETURN_NOTE
,      CHANGED_AFTER_RESEARCH_FLAG
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_CONTACT_ID
,      RESEARCH_AGENT_ID
,      ON_LINE_FLAG
,      WIP_ENTITY_ID
,      WIP_LINE_ID
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_OPERATION_SEQ_NUM
,      WIP_RESOURCE_SEQ_NUM
,      ATTRIBUTE_CATEGORY
,      DESTINATION_CONTEXT
,      INVENTORY_SOURCE_CONTEXT
,      VENDOR_SOURCE_CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      BOM_RESOURCE_ID
,      PARENT_REQ_LINE_ID
,      JUSTIFICATION
,      NOTE_TO_AGENT
,      NOTE_TO_RECEIVER
,      PURCHASING_AGENT_ID
,      DOCUMENT_TYPE_CODE
,      BLANKET_PO_HEADER_ID
,      BLANKET_PO_LINE_NUM
,      CURRENCY_CODE
,      RATE_TYPE
,      RATE_DATE
,      RATE
,      CURRENCY_UNIT_PRICE
,      SUGGESTED_VENDOR_NAME
,      SUGGESTED_VENDOR_LOCATION
,      SUGGESTED_VENDOR_CONTACT
,      SUGGESTED_VENDOR_PHONE
,      SUGGESTED_VENDOR_PRODUCT_CODE
,      UN_NUMBER_ID
,      HAZARD_CLASS_ID
,      MUST_USE_SUGG_VENDOR_FLAG
,      REFERENCE_NUM
,      ON_RFQ_FLAG
,      URGENT_FLAG
,      CANCEL_FLAG
,      SOURCE_ORGANIZATION_ID
,      SOURCE_SUBINVENTORY
,      DESTINATION_TYPE_CODE
,      DESTINATION_ORGANIZATION_ID
,      DESTINATION_SUBINVENTORY
,      QUANTITY_CANCELLED
,      CANCEL_DATE
,      REQUISITION_LINE_ID
,      REQUISITION_HEADER_ID
,      LINE_NUM
,      LINE_TYPE_ID
,      CATEGORY_ID
,      ITEM_DESCRIPTION
,      UNIT_MEAS_LOOKUP_CODE
,      UNIT_PRICE
,      QUANTITY
,      DELIVER_TO_LOCATION_ID
,      TO_PERSON_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      SOURCE_TYPE_CODE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ITEM_ID
,      ITEM_REVISION
,      QUANTITY_DELIVERED
,      SUGGESTED_BUYER_ID
,      ENCUMBERED_FLAG
,      RFQ_REQUIRED_FLAG
,      NEED_BY_DATE
,      LINE_LOCATION_ID
,      MODIFIED_BY_AGENT_FLAG
,      KANBAN_CARD_ID
,      CATALOG_TYPE
,      CATALOG_SOURCE
,      MANUFACTURER_ID
,      MANUFACTURER_NAME
,      MANUFACTURER_PART_NUMBER
,      REQUESTER_EMAIL
,      REQUESTER_FAX
,      REQUESTER_PHONE
,      UNSPSC_CODE
,      OTHER_CATEGORY_CODE
,      SUPPLIER_DUNS
,      TAX_STATUS_INDICATOR
,      PCARD_FLAG
,      NEW_SUPPLIER_FLAG
,      AUTO_RECEIVE_FLAG
,      TAX_USER_OVERRIDE_FLAG
,      TAX_CODE_ID
,      NOTE_TO_VENDOR
,      OKE_CONTRACT_HEADER_ID
,      OKE_CONTRACT_VERSION_ID
,      ITEM_SOURCE_ID
,      SUPPLIER_REF_NUMBER
,      SECONDARY_UNIT_OF_MEASURE
,      SECONDARY_QUANTITY
,      PREFERRED_GRADE
,      SECONDARY_QUANTITY_RECEIVED
,      SECONDARY_QUANTITY_CANCELLED
,      AUCTION_HEADER_ID
,      AUCTION_DISPLAY_NUMBER
,      AUCTION_LINE_NUMBER
,      REQS_IN_POOL_FLAG
,      VMI_FLAG
,      BID_NUMBER
,      BID_LINE_NUMBER
,      AMOUNT
FROM PO.PO_REQ_LINES_GT;

Dependencies

[top of page]

PO.PO_REQ_LINES_GT does not reference any database object

PO.PO_REQ_LINES_GT is referenced by following:

APPS

PO_REQ_LINES_GT