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

TABLE: PO.PO_REQUISITION_SUPPLIERS

Object Details
Object Name: PO_REQUISITION_SUPPLIERS
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_REQUISITION_SUPPLIERS
Subobject Name:
Status: VALID


This table holds the list of suppliers to which the contractor request is sent out


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_REQUISITION_SUPPLIER_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUISITION_SUPPLIER_ID
PO_REQUISITION_SUPPLIERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUISITION_LINE_ID
Columns
Name Datatype Length Mandatory Comments
REQUISITION_LINE_ID NUMBER
Yes Requisition Line id
VENDOR_ID NUMBER
Yes supplier Id
VENDOR_SITE_ID NUMBER

supplier site Id
VENDOR_CONTACT_ID NUMBER

Supplier contact Id
NOTE_TO_VENDOR VARCHAR2 (480)
Note to the supplier
CANDIDATE_FULL_NAME VARCHAR2 (240)
Cndidate Full name
DOCUMENT_TYPE_CODE VARCHAR2 (25)
Document Type
SOURCE_DOC_HEADER_ID NUMBER

Source document Header id
SOURCE_DOC_LINE_ID NUMBER

Source document Line Id
SOURCE_DOC_LINE_NUM NUMBER

Source document Line Id
UNIT_PRICE NUMBER

Unit Price on the requisition Line
CURRENCY_UNIT_PRICE NUMBER

Unit price in the foreign currency
AMOUNT NUMBER

Req Line Amount
CURRENCY_AMOUNT NUMBER

Amount in foreign currency
CURRENCY_CODE VARCHAR2 (15)
Currency Code
RATE_TYPE VARCHAR2 (30)
Exchange Rate Type
RATE_DATE DATE

Exchange Rate date
RATE NUMBER

Exchange Rate
PRICE_BREAK_ID NUMBER

Price break Id : Id of the price break from where the price is returned
NOT_TO_EXCEED_PRICE NUMBER

Price limit on the source agreement line
ALLOW_PRICE_OVERRIDE_FLAG VARCHAR2 (1)
Flag on the source document line to indicate if chnaging the price is allowed or not
ALLOW_RATE_DIFFERENTIAL_FLAG VARCHAR2 (1)
Flag to indicate if price differentials are allowed for the contractor request
SUPPLIER_NOTIFIED_FLAG VARCHAR2 (1)
Flag to indicate if the supplier has been notified of the contractor request
SUPPLIER_NOTIFIED_DATE DATE

Date on which the supplier is notified about the contractor request
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER
Yes Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
REQUISITION_SUPPLIER_ID NUMBER
Yes Requisition supplier Id
CANDIDATE_FIRST_NAME VARCHAR2 (240)
Candidate First name
CANDIDATE_LAST_NAME VARCHAR2 (240)
Candidate Last name
UNIT_MEAS_LOOKUP_CODE VARCHAR2 (25)
Req line unit of measure
Query Text

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;

Dependencies

[top of page]

PO.PO_REQUISITION_SUPPLIERS does not reference any database object

PO.PO_REQUISITION_SUPPLIERS is referenced by following:

SchemaAPPS
SynonymPO_REQUISITION_SUPPLIERS