eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PO.PO_WF_CANDIDATE_REQ_LINES_TEMP

Object Details

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

PO_WF_CANDIDATE_REQ_LINES_TEMP stores requisition lines that can be
automatically created into purchase orders using Oracle Workflow.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	5
PCT Used:

Columns

Name	Datatype	Length	Comments
GROUP_ID	NUMBER		Allows multiple requisition lines to be processed in groups
REQUISITION_HEADER_ID	NUMBER		Requisition header unique identifier
REQUISITION_LINE_ID	NUMBER		Requisition line unique identifier
LINE_NUM	NUMBER		Line number
SUGGESTED_BUYER_ID	NUMBER		Suggested buyer unique identifier
SOURCE_DOC_TYPE_CODE	VARCHAR2	(25)	Source document type
SOURCE_DOC_ID	NUMBER		Source document unique identifier
SOURCE_DOC_LINE	NUMBER		Source document line number
SUGGESTED_VENDOR_ID	NUMBER		Suggested supplier unique identifier
SUGGESTED_VENDOR_SITE_ID	NUMBER		Suggested supplier site unique identifier
CURRENCY_CODE	VARCHAR2	(15)	Unique identifier for the currency
RATE_TYPE	VARCHAR2	(30)	Currency conversion rate type
RATE_DATE	DATE		Currency conversion rate date
RATE	NUMBER		Currency conversion rate
PROCESS_CODE	VARCHAR2	(30)	Indicates what processing state the requisition line is in
RELEASE_GENERATION_METHOD	VARCHAR2	(25)	Release generation method tied to the approved supplier list for the item
ITEM_ID	NUMBER		Item unique identifier
PCARD_ID	NUMBER	(15)	Unique identifer for the procurement card used on the requisition
CONTRACT_ID	NUMBER	(20)	Identifier for the Contract Id referenced in the requisition
JOB_ID	NUMBER		Reference to the HR job

Query Text

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


SELECT GROUP_ID
,      REQUISITION_HEADER_ID
,      REQUISITION_LINE_ID
,      LINE_NUM
,      SUGGESTED_BUYER_ID
,      SOURCE_DOC_TYPE_CODE
,      SOURCE_DOC_ID
,      SOURCE_DOC_LINE
,      SUGGESTED_VENDOR_ID
,      SUGGESTED_VENDOR_SITE_ID
,      CURRENCY_CODE
,      RATE_TYPE
,      RATE_DATE
,      RATE
,      PROCESS_CODE
,      RELEASE_GENERATION_METHOD
,      ITEM_ID
,      PCARD_ID
,      CONTRACT_ID
,      JOB_ID
FROM PO.PO_WF_CANDIDATE_REQ_LINES_TEMP;

Dependencies

[top of page]

PO.PO_WF_CANDIDATE_REQ_LINES_TEMP does not reference any database object

PO.PO_WF_CANDIDATE_REQ_LINES_TEMP is referenced by following:

APPS: PO_WF_CANDIDATE_REQ_LINES_TEMP