PO_REQ_SPLIT_LINES_GT

The Global Temporary table stores the splited requisition line detail.

Details

• Schema: FUSION

• Object owner: PO

• Object type: TABLE

Primary Key

Name	Columns
PO_REQ_SPLIT_LINES_GT_PK	REQUISITION_HEADER_ID, REQUISITION_LINE_ID

Columns

Name

AUCTION_HEADER_IDNUMBERAUCTION_HEADER_ID BID_NUMBERNUMBERBID_NUMBER BID_LINE_NUMBERNUMBERBID_LINE_NUMBER REQUISITION_HEADER_IDNUMBERYesREQUISITION_HEADER_ID REQUISITION_LINE_IDNUMBERYesREQUISITION_LINE_ID ALLOCATED_QTYNUMBERALLOCATED_QTY NEW_REQ_LINE_IDNUMBERNEW_REQ_LINE_ID NEW_LINE_NUMNUMBERNEW_LINE_NUM TOTAL_ALLOC_REQ_LINE_QTYNUMBERTOTAL_ALLOC_REQ_LINE_QTY REQUISITION_LINE_QTYNUMBERREQUISITION_LINE_QTY MIN_BID_NUMBERNUMBERMIN_BID_NUMBER RECORD_STATUSVARCHAR21RECORD_STATUS

Indexes

Index	Uniqueness	Columns
PO_REQ_SPLIT_LINES_GT_U1	Unique	REQUISITION_HEADER_ID, REQUISITION_LINE_ID