View: POA_BIS_SAVINGS_RPT_V

View Text

SELECT "GROUPNO"
, "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"
, "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"
FROM POA_BIS_SAVINGS_RPT

Columns