[Home] [Help] [Dependency Information]
Object Name: | PO_WF_CANDIDATE_REQ_LINES_TEM# |
---|---|
Object Type: | VIEW |
Owner: | PO |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | |||
REQUISITION_HEADER_ID | NUMBER | |||
REQUISITION_LINE_ID | NUMBER | |||
LINE_NUM | NUMBER | |||
SUGGESTED_BUYER_ID | NUMBER | |||
SOURCE_DOC_TYPE_CODE | VARCHAR2 | (25) | ||
SOURCE_DOC_ID | NUMBER | |||
SOURCE_DOC_LINE | NUMBER | |||
SUGGESTED_VENDOR_ID | NUMBER | |||
SUGGESTED_VENDOR_SITE_ID | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
RATE_TYPE | VARCHAR2 | (30) | ||
RATE_DATE | DATE | |||
RATE | NUMBER | |||
PROCESS_CODE | VARCHAR2 | (30) | ||
RELEASE_GENERATION_METHOD | VARCHAR2 | (25) | ||
ITEM_ID | NUMBER | |||
PCARD_ID | NUMBER | (15) | ||
CONTRACT_ID | NUMBER | (20) | ||
JOB_ID | NUMBER |
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_TEM#;
|
|
|