[Home] [Help] [Dependency Information]
Object Name: | PO_REQUISITION_SUPPLIERS# |
---|---|
Object Type: | VIEW |
Owner: | PO |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUISITION_LINE_ID | NUMBER | Yes | ||
VENDOR_ID | NUMBER | Yes | ||
VENDOR_SITE_ID | NUMBER | |||
VENDOR_CONTACT_ID | NUMBER | |||
NOTE_TO_VENDOR | VARCHAR2 | (480) | ||
CANDIDATE_FULL_NAME | VARCHAR2 | (240) | ||
DOCUMENT_TYPE_CODE | VARCHAR2 | (25) | ||
SOURCE_DOC_HEADER_ID | NUMBER | |||
SOURCE_DOC_LINE_ID | NUMBER | |||
SOURCE_DOC_LINE_NUM | NUMBER | |||
UNIT_PRICE | NUMBER | |||
CURRENCY_UNIT_PRICE | NUMBER | |||
AMOUNT | NUMBER | |||
CURRENCY_AMOUNT | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
RATE_TYPE | VARCHAR2 | (30) | ||
RATE_DATE | DATE | |||
RATE | NUMBER | |||
PRICE_BREAK_ID | NUMBER | |||
NOT_TO_EXCEED_PRICE | NUMBER | |||
ALLOW_PRICE_OVERRIDE_FLAG | VARCHAR2 | (1) | ||
ALLOW_RATE_DIFFERENTIAL_FLAG | VARCHAR2 | (1) | ||
SUPPLIER_NOTIFIED_FLAG | VARCHAR2 | (1) | ||
SUPPLIER_NOTIFIED_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
REQUISITION_SUPPLIER_ID | NUMBER | Yes | ||
CANDIDATE_FIRST_NAME | VARCHAR2 | (240) | ||
CANDIDATE_LAST_NAME | VARCHAR2 | (240) | ||
UNIT_MEAS_LOOKUP_CODE | VARCHAR2 | (25) |
Cut, paste (and edit) the following text to query this object:
SELECT REQUISITION_LINE_ID
, VENDOR_ID
, VENDOR_SITE_ID
, VENDOR_CONTACT_ID
, NOTE_TO_VENDOR
, CANDIDATE_FULL_NAME
, DOCUMENT_TYPE_CODE
, SOURCE_DOC_HEADER_ID
, SOURCE_DOC_LINE_ID
, SOURCE_DOC_LINE_NUM
, UNIT_PRICE
, CURRENCY_UNIT_PRICE
, AMOUNT
, CURRENCY_AMOUNT
, CURRENCY_CODE
, RATE_TYPE
, RATE_DATE
, RATE
, PRICE_BREAK_ID
, NOT_TO_EXCEED_PRICE
, ALLOW_PRICE_OVERRIDE_FLAG
, ALLOW_RATE_DIFFERENTIAL_FLAG
, SUPPLIER_NOTIFIED_FLAG
, SUPPLIER_NOTIFIED_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, REQUISITION_SUPPLIER_ID
, CANDIDATE_FIRST_NAME
, CANDIDATE_LAST_NAME
, UNIT_MEAS_LOOKUP_CODE
FROM PO.PO_REQUISITION_SUPPLIERS#;
|
|
|