[Home] [Help] [Dependency Information]
Object Name: | POA_BIS_SAVINGS |
---|---|
Object Type: | TABLE |
Owner: | PO |
FND Design Data: | PO.POA_BIS_SAVINGS |
Subobject Name: | |
Status: | VALID |
This table contains data used to view purchase details and analysis based on contracts. Contract purchases are those that reference a blanket or release purchase order.
Contract, non-contract, and potential savings are calculated to determine performance and savings opportunities. Data within this table is used for Purchasing Intelligence: for the Purchases, Contract Leakage, and Contract Savings reports, and the Contract Savings Discoverer workbook.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
POA_BIS_SAVINGS_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | DISTRIBUTION_TRANSACTION_ID |
POA_BIS_SAVINGS_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SUPPLIER_ID |
POA_BIS_SAVINGS_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | CATEGORY_ID |
POA_BIS_SAVINGS_N3 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SHIP_TO_ORGANIZATION_ID |
POA_BIS_SAVINGS_N4 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | OPERATING_UNIT_ID |
POA_BIS_SAVINGS_N5 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | ITEM_ID |
POA_BIS_SAVINGS_N6 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | PURCHASE_CREATION_DATE |
POA_BIS_SAVINGS_N7 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | BUYER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PURCHASE_AMOUNT | NUMBER | Purchase Amount | ||
CONTRACT_AMOUNT | NUMBER | Amount purchased through the use of contracts. Contracts are defined as Blanket or Release Orders. | ||
NON_CONTRACT_AMOUNT | NUMBER | Amount purchased of an item that has no valid agreements/contracts. Contracts are defined as Blanket or Release Orders. | ||
POT_CONTRACT_AMOUNT | NUMBER | Amount of purchases for an item that can potentially be made through the use of contracts | ||
POTENTIAL_SAVING | NUMBER | Potential savings calculated from the pricing difference between purchases on and off-contract | ||
TOTAL_PURCHASE_QTY | NUMBER | Purchased quantity | ||
DISTRIBUTION_TRANSACTION_ID | NUMBER | Yes | Document distribution unique identifier | |
DOCUMENT_TYPE_CODE | VARCHAR2 | (25) | Document type | |
PURCHASE_CREATION_DATE | DATE | Yes | Document creation date | |
ITEM_ID | NUMBER | Item unique identifier | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
CATEGORY_ID | NUMBER | Item category unique identifier | ||
SUPPLIER_SITE_ID | NUMBER | Supplier site unique identifier | ||
SUPPLIER_ID | NUMBER | Supplier unique identifier | ||
REQUESTOR_ID | NUMBER | Requester unique identifier | ||
SHIP_TO_LOCATION_ID | NUMBER | Ship-to location unique identifier | ||
SHIP_TO_ORGANIZATION_ID | NUMBER | Ship-to organization unique identifier | ||
OPERATING_UNIT_ID | NUMBER | Operating unit unique identifier | ||
BUYER_ID | NUMBER | Buyer unique identifier | ||
PROJECT_ID | NUMBER | Project Accounting project unique identifier | ||
TASK_ID | NUMBER | Project Accounting task unique identifier | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency code | |
RATE_TYPE | VARCHAR2 | (30) | Currency conversion rate type | |
RATE_DATE | DATE | Currency conversion rate date | ||
COST_CENTER_ID | NUMBER | Cost center unique identifier - for future use | ||
ACCOUNT_ID | VARCHAR2 | (2000) | Account unique identifier - for future use | |
COMPANY_ID | VARCHAR2 | (2000) | Company unique identifier - for future use | |
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
APPROVED_DATE | DATE | Approved Date | ||
CURRENCY_CONV_RATE | NUMBER | Currency Conversion Rate | ||
RATE | NUMBER | Rate |
Cut, paste (and edit) the following text to query this object:
SELECT PURCHASE_AMOUNT
, CONTRACT_AMOUNT
, NON_CONTRACT_AMOUNT
, POT_CONTRACT_AMOUNT
, POTENTIAL_SAVING
, TOTAL_PURCHASE_QTY
, DISTRIBUTION_TRANSACTION_ID
, DOCUMENT_TYPE_CODE
, PURCHASE_CREATION_DATE
, ITEM_ID
, ITEM_DESCRIPTION
, CATEGORY_ID
, SUPPLIER_SITE_ID
, SUPPLIER_ID
, REQUESTOR_ID
, SHIP_TO_LOCATION_ID
, SHIP_TO_ORGANIZATION_ID
, OPERATING_UNIT_ID
, BUYER_ID
, PROJECT_ID
, TASK_ID
, CURRENCY_CODE
, RATE_TYPE
, RATE_DATE
, COST_CENTER_ID
, ACCOUNT_ID
, COMPANY_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, APPROVED_DATE
, CURRENCY_CONV_RATE
, RATE
FROM PO.POA_BIS_SAVINGS;
PO.POA_BIS_SAVINGS does not reference any database object
PO.POA_BIS_SAVINGS is referenced by following:
|
|
|