VIEW: PO.PO_ASL_ATTRIBUTES#

Source

View Text - Preformatted

select ASL_ID ASL_ID, USING_ORGANIZATION_ID USING_ORGANIZATION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, DOCUMENT_SOURCING_METHOD DOCUMENT_SOURCING_METHOD, RELEASE_GENERATION_METHOD RELEASE_GENERATION_METHOD, PURCHASING_UNIT_OF_MEASURE PURCHASING_UNIT_OF_MEASURE, ENABLE_PLAN_SCHEDULE_FLAG ENABLE_PLAN_SCHEDULE_FLAG, ENABLE_SHIP_SCHEDULE_FLAG ENABLE_SHIP_SCHEDULE_FLAG, PLAN_SCHEDULE_TYPE PLAN_SCHEDULE_TYPE, SHIP_SCHEDULE_TYPE SHIP_SCHEDULE_TYPE, PLAN_BUCKET_PATTERN_ID PLAN_BUCKET_PATTERN_ID, SHIP_BUCKET_PATTERN_ID SHIP_BUCKET_PATTERN_ID, ENABLE_AUTOSCHEDULE_FLAG ENABLE_AUTOSCHEDULE_FLAG, SCHEDULER_ID SCHEDULER_ID, ENABLE_AUTHORIZATIONS_FLAG ENABLE_AUTHORIZATIONS_FLAG, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, ITEM_ID ITEM_ID, CATEGORY_ID CATEGORY_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, 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, PRICE_UPDATE_TOLERANCE PRICE_UPDATE_TOLERANCE, PROCESSING_LEAD_TIME PROCESSING_LEAD_TIME, MIN_ORDER_QTY MIN_ORDER_QTY, FIXED_LOT_MULTIPLE FIXED_LOT_MULTIPLE, DELIVERY_CALENDAR DELIVERY_CALENDAR, COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE, ENABLE_VMI_FLAG ENABLE_VMI_FLAG, VMI_MIN_QTY VMI_MIN_QTY, VMI_MAX_QTY VMI_MAX_QTY, ENABLE_VMI_AUTO_REPLENISH_FLAG ENABLE_VMI_AUTO_REPLENISH_FLAG, VMI_REPLENISHMENT_APPROVAL VMI_REPLENISHMENT_APPROVAL, CONSIGNED_FROM_SUPPLIER_FLAG CONSIGNED_FROM_SUPPLIER_FLAG, LAST_BILLING_DATE LAST_BILLING_DATE, CONSIGNED_BILLING_CYCLE CONSIGNED_BILLING_CYCLE, CONSUME_ON_AGING_FLAG CONSUME_ON_AGING_FLAG, AGING_PERIOD AGING_PERIOD, REPLENISHMENT_METHOD REPLENISHMENT_METHOD, VMI_MIN_DAYS VMI_MIN_DAYS, VMI_MAX_DAYS VMI_MAX_DAYS, FIXED_ORDER_QUANTITY FIXED_ORDER_QUANTITY, FORECAST_HORIZON FORECAST_HORIZON from "PO"."PO_ASL_ATTRIBUTES"

View Text - HTML Formatted

SELECT ASL_ID ASL_ID
, USING_ORGANIZATION_ID USING_ORGANIZATION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, DOCUMENT_SOURCING_METHOD DOCUMENT_SOURCING_METHOD
, RELEASE_GENERATION_METHOD RELEASE_GENERATION_METHOD
, PURCHASING_UNIT_OF_MEASURE PURCHASING_UNIT_OF_MEASURE
, ENABLE_PLAN_SCHEDULE_FLAG ENABLE_PLAN_SCHEDULE_FLAG
, ENABLE_SHIP_SCHEDULE_FLAG ENABLE_SHIP_SCHEDULE_FLAG
, PLAN_SCHEDULE_TYPE PLAN_SCHEDULE_TYPE
, SHIP_SCHEDULE_TYPE SHIP_SCHEDULE_TYPE
, PLAN_BUCKET_PATTERN_ID PLAN_BUCKET_PATTERN_ID
, SHIP_BUCKET_PATTERN_ID SHIP_BUCKET_PATTERN_ID
, ENABLE_AUTOSCHEDULE_FLAG ENABLE_AUTOSCHEDULE_FLAG
, SCHEDULER_ID SCHEDULER_ID
, ENABLE_AUTHORIZATIONS_FLAG ENABLE_AUTHORIZATIONS_FLAG
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, ITEM_ID ITEM_ID
, CATEGORY_ID CATEGORY_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
, 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
, PRICE_UPDATE_TOLERANCE PRICE_UPDATE_TOLERANCE
, PROCESSING_LEAD_TIME PROCESSING_LEAD_TIME
, MIN_ORDER_QTY MIN_ORDER_QTY
, FIXED_LOT_MULTIPLE FIXED_LOT_MULTIPLE
, DELIVERY_CALENDAR DELIVERY_CALENDAR
, COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE
, ENABLE_VMI_FLAG ENABLE_VMI_FLAG
, VMI_MIN_QTY VMI_MIN_QTY
, VMI_MAX_QTY VMI_MAX_QTY
, ENABLE_VMI_AUTO_REPLENISH_FLAG ENABLE_VMI_AUTO_REPLENISH_FLAG
, VMI_REPLENISHMENT_APPROVAL VMI_REPLENISHMENT_APPROVAL
, CONSIGNED_FROM_SUPPLIER_FLAG CONSIGNED_FROM_SUPPLIER_FLAG
, LAST_BILLING_DATE LAST_BILLING_DATE
, CONSIGNED_BILLING_CYCLE CONSIGNED_BILLING_CYCLE
, CONSUME_ON_AGING_FLAG CONSUME_ON_AGING_FLAG
, AGING_PERIOD AGING_PERIOD
, REPLENISHMENT_METHOD REPLENISHMENT_METHOD
, VMI_MIN_DAYS VMI_MIN_DAYS
, VMI_MAX_DAYS VMI_MAX_DAYS
, FIXED_ORDER_QUANTITY FIXED_ORDER_QUANTITY
, FORECAST_HORIZON FORECAST_HORIZON
FROM "PO"."PO_ASL_ATTRIBUTES"