VIEW: OSM.AS_IMP_LINES_INTERFACE#

Source

View Text - Preformatted

select IMP_LINES_INTERFACE_ID IMP_LINES_INTERFACE_ID, IMPORT_INTERFACE_ID IMPORT_INTERFACE_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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, INTEREST_TYPE_ID INTEREST_TYPE_ID, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID, SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, UOM_CODE UOM_CODE, QUANTITY QUANTITY, BUDGET_AMOUNT BUDGET_AMOUNT, SOURCE_PROMOTION_ID SOURCE_PROMOTION_ID, OFFER_ID OFFER_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, CATEGORY_ID CATEGORY_ID from "OSM"."AS_IMP_LINES_INTERFACE"

View Text - HTML Formatted

SELECT IMP_LINES_INTERFACE_ID IMP_LINES_INTERFACE_ID
, IMPORT_INTERFACE_ID IMPORT_INTERFACE_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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, INTEREST_TYPE_ID INTEREST_TYPE_ID
, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID
, SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, UOM_CODE UOM_CODE
, QUANTITY QUANTITY
, BUDGET_AMOUNT BUDGET_AMOUNT
, SOURCE_PROMOTION_ID SOURCE_PROMOTION_ID
, OFFER_ID OFFER_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CATEGORY_ID CATEGORY_ID
FROM "OSM"."AS_IMP_LINES_INTERFACE"