VIEW: AMS.AMS_DELIVERABLES_ALL_B#

Source

View Text - Preformatted

select DELIVERABLE_ID DELIVERABLE_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LANGUAGE_CODE LANGUAGE_CODE, VERSION VERSION, APPLICATION_ID APPLICATION_ID, USER_STATUS_ID USER_STATUS_ID, STATUS_CODE STATUS_CODE, STATUS_DATE STATUS_DATE, ACTIVE_FLAG ACTIVE_FLAG, PRIVATE_FLAG PRIVATE_FLAG, OWNER_USER_ID OWNER_USER_ID, ORG_ID ORG_ID, FUND_SOURCE_ID FUND_SOURCE_ID, FUND_SOURCE_TYPE FUND_SOURCE_TYPE, CATEGORY_TYPE_ID CATEGORY_TYPE_ID, CATEGORY_SUB_TYPE_ID CATEGORY_SUB_TYPE_ID, KIT_FLAG KIT_FLAG, INVENTORY_FLAG INVENTORY_FLAG, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, INVENTORY_ITEM_ORG_ID INVENTORY_ITEM_ORG_ID, PRICELIST_HEADER_ID PRICELIST_HEADER_ID, PRICELIST_LINE_ID PRICELIST_LINE_ID, NON_INV_CTRL_CODE NON_INV_CTRL_CODE, NON_INV_QUANTITY_ON_HAND NON_INV_QUANTITY_ON_HAND, NON_INV_QUANTITY_ON_ORDER NON_INV_QUANTITY_ON_ORDER, NON_INV_QUANTITY_ON_RESERVE NON_INV_QUANTITY_ON_RESERVE, REPLACED_BY_DELIVERABLE_ID REPLACED_BY_DELIVERABLE_ID, CAN_FULFILL_ELECTRONIC_FLAG CAN_FULFILL_ELECTRONIC_FLAG, CAN_FULFILL_PHYSICAL_FLAG CAN_FULFILL_PHYSICAL_FLAG, JTF_AMV_ITEM_ID JTF_AMV_ITEM_ID, TRANSACTION_CURRENCY_CODE TRANSACTION_CURRENCY_CODE, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, BUDGET_AMOUNT_TC BUDGET_AMOUNT_TC, BUDGET_AMOUNT_FC BUDGET_AMOUNT_FC, ACTUAL_AVAIL_FROM_DATE ACTUAL_AVAIL_FROM_DATE, ACTUAL_AVAIL_TO_DATE ACTUAL_AVAIL_TO_DATE, CHARGEBACK_AMOUNT CHARGEBACK_AMOUNT, CHARGEBACK_UOM CHARGEBACK_UOM, CHARGEBACK_AMOUNT_CURR_CODE CHARGEBACK_AMOUNT_CURR_CODE, DELIVERABLE_CODE DELIVERABLE_CODE, DELIVERABLE_PICK_FLAG DELIVERABLE_PICK_FLAG, CURRENCY_CODE CURRENCY_CODE, FORECASTED_COST FORECASTED_COST, ACTUAL_COST ACTUAL_COST, FORECASTED_RESPONSES FORECASTED_RESPONSES, ACTUAL_RESPONSES ACTUAL_RESPONSES, COUNTRY COUNTRY, DEFAULT_APPROVER_ID DEFAULT_APPROVER_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, FORECASTED_COMPLETE_DATE FORECASTED_COMPLETE_DATE, ACTUAL_COMPLETE_DATE ACTUAL_COMPLETE_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, DELIVERABLE_CALENDAR DELIVERABLE_CALENDAR, START_PERIOD_NAME START_PERIOD_NAME, END_PERIOD_NAME END_PERIOD_NAME, ACCOUNTS_CLOSED_FLAG ACCOUNTS_CLOSED_FLAG, COUNTRY_ID COUNTRY_ID, CUSTOM_SETUP_ID CUSTOM_SETUP_ID, EMAIL_CONTENT_TYPE EMAIL_CONTENT_TYPE from "AMS"."AMS_DELIVERABLES_ALL_B"

View Text - HTML Formatted

SELECT DELIVERABLE_ID DELIVERABLE_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LANGUAGE_CODE LANGUAGE_CODE
, VERSION VERSION
, APPLICATION_ID APPLICATION_ID
, USER_STATUS_ID USER_STATUS_ID
, STATUS_CODE STATUS_CODE
, STATUS_DATE STATUS_DATE
, ACTIVE_FLAG ACTIVE_FLAG
, PRIVATE_FLAG PRIVATE_FLAG
, OWNER_USER_ID OWNER_USER_ID
, ORG_ID ORG_ID
, FUND_SOURCE_ID FUND_SOURCE_ID
, FUND_SOURCE_TYPE FUND_SOURCE_TYPE
, CATEGORY_TYPE_ID CATEGORY_TYPE_ID
, CATEGORY_SUB_TYPE_ID CATEGORY_SUB_TYPE_ID
, KIT_FLAG KIT_FLAG
, INVENTORY_FLAG INVENTORY_FLAG
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, INVENTORY_ITEM_ORG_ID INVENTORY_ITEM_ORG_ID
, PRICELIST_HEADER_ID PRICELIST_HEADER_ID
, PRICELIST_LINE_ID PRICELIST_LINE_ID
, NON_INV_CTRL_CODE NON_INV_CTRL_CODE
, NON_INV_QUANTITY_ON_HAND NON_INV_QUANTITY_ON_HAND
, NON_INV_QUANTITY_ON_ORDER NON_INV_QUANTITY_ON_ORDER
, NON_INV_QUANTITY_ON_RESERVE NON_INV_QUANTITY_ON_RESERVE
, REPLACED_BY_DELIVERABLE_ID REPLACED_BY_DELIVERABLE_ID
, CAN_FULFILL_ELECTRONIC_FLAG CAN_FULFILL_ELECTRONIC_FLAG
, CAN_FULFILL_PHYSICAL_FLAG CAN_FULFILL_PHYSICAL_FLAG
, JTF_AMV_ITEM_ID JTF_AMV_ITEM_ID
, TRANSACTION_CURRENCY_CODE TRANSACTION_CURRENCY_CODE
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, BUDGET_AMOUNT_TC BUDGET_AMOUNT_TC
, BUDGET_AMOUNT_FC BUDGET_AMOUNT_FC
, ACTUAL_AVAIL_FROM_DATE ACTUAL_AVAIL_FROM_DATE
, ACTUAL_AVAIL_TO_DATE ACTUAL_AVAIL_TO_DATE
, CHARGEBACK_AMOUNT CHARGEBACK_AMOUNT
, CHARGEBACK_UOM CHARGEBACK_UOM
, CHARGEBACK_AMOUNT_CURR_CODE CHARGEBACK_AMOUNT_CURR_CODE
, DELIVERABLE_CODE DELIVERABLE_CODE
, DELIVERABLE_PICK_FLAG DELIVERABLE_PICK_FLAG
, CURRENCY_CODE CURRENCY_CODE
, FORECASTED_COST FORECASTED_COST
, ACTUAL_COST ACTUAL_COST
, FORECASTED_RESPONSES FORECASTED_RESPONSES
, ACTUAL_RESPONSES ACTUAL_RESPONSES
, COUNTRY COUNTRY
, DEFAULT_APPROVER_ID DEFAULT_APPROVER_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, FORECASTED_COMPLETE_DATE FORECASTED_COMPLETE_DATE
, ACTUAL_COMPLETE_DATE ACTUAL_COMPLETE_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, DELIVERABLE_CALENDAR DELIVERABLE_CALENDAR
, START_PERIOD_NAME START_PERIOD_NAME
, END_PERIOD_NAME END_PERIOD_NAME
, ACCOUNTS_CLOSED_FLAG ACCOUNTS_CLOSED_FLAG
, COUNTRY_ID COUNTRY_ID
, CUSTOM_SETUP_ID CUSTOM_SETUP_ID
, EMAIL_CONTENT_TYPE EMAIL_CONTENT_TYPE
FROM "AMS"."AMS_DELIVERABLES_ALL_B"