VIEW: APPS.POA_BIS_SAVINGS_RPT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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