PO_ASL_ATTRIBUTES_VAL_V

Details

• Schema: FUSION

• Object owner: PO

• Object type: VIEW

Columns

Name

ASL_ID USING_ORGANIZATION_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY DOCUMENT_SOURCING_METHOD RELEASE_GENERATION_METHOD PURCHASING_UNIT_OF_MEASURE ENABLE_PLAN_SCHEDULE_FLAG ENABLE_SHIP_SCHEDULE_FLAG PLAN_SCHEDULE_TYPE SHIP_SCHEDULE_TYPE PLAN_BUCKET_PATTERN_ID SHIP_BUCKET_PATTERN_ID ENABLE_AUTOSCHEDULE_FLAG SCHEDULER_ID ENABLE_AUTHORIZATIONS_FLAG VENDOR_ID VENDOR_SITE_ID ITEM_ID CATEGORY_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 LAST_UPDATE_LOGIN REQUEST_ID PRICE_UPDATE_TOLERANCE MIN_ORDER_QTY FIXED_LOT_MULTIPLE COUNTRY_OF_ORIGIN_CODE ENABLE_VMI_FLAG VMI_MIN_QTY VMI_MAX_QTY ENABLE_VMI_AUTO_REPLENISH_FLAG VMI_REPLENISHMENT_APPROVAL CONSIGNED_FROM_SUPPLIER_FLAG LAST_BILLING_DATE CONSIGNED_BILLING_CYCLE CONSUME_ON_AGING_FLAG AGING_PERIOD REPLENISHMENT_METHOD VMI_MIN_DAYS VMI_MAX_DAYS FIXED_ORDER_QUANTITY FORECAST_HORIZON

Query

SQL_Statement

SELECT PAA.ASL_ID, PAA.USING_ORGANIZATION_ID, PAA.LAST_UPDATE_DATE, PAA.LAST_UPDATED_BY, PAA.CREATION_DATE, PAA.CREATED_BY, PAA.DOCUMENT_SOURCING_METHOD, PAA.RELEASE_GENERATION_METHOD, PAA.PURCHASING_UNIT_OF_MEASURE, PAA.ENABLE_PLAN_SCHEDULE_FLAG, PAA.ENABLE_SHIP_SCHEDULE_FLAG, PAA.PLAN_SCHEDULE_TYPE, PAA.SHIP_SCHEDULE_TYPE, PAA.PLAN_BUCKET_PATTERN_ID, PAA.SHIP_BUCKET_PATTERN_ID, PAA.ENABLE_AUTOSCHEDULE_FLAG, PAA.SCHEDULER_ID, PAA.ENABLE_AUTHORIZATIONS_FLAG, PAA.VENDOR_ID, PAA.VENDOR_SITE_ID, PAA.ITEM_ID, PAA.CATEGORY_ID, PAA.ATTRIBUTE_CATEGORY, PAA.ATTRIBUTE1, PAA.ATTRIBUTE2, PAA.ATTRIBUTE3, PAA.ATTRIBUTE4, PAA.ATTRIBUTE5, PAA.ATTRIBUTE6, PAA.ATTRIBUTE7, PAA.ATTRIBUTE8, PAA.ATTRIBUTE9, PAA.ATTRIBUTE10, PAA.ATTRIBUTE11, PAA.ATTRIBUTE12, PAA.ATTRIBUTE13, PAA.ATTRIBUTE14, PAA.ATTRIBUTE15, PAA.LAST_UPDATE_LOGIN, PAA.REQUEST_ID, PAA.PRICE_UPDATE_TOLERANCE, PAA.MIN_ORDER_QTY, PAA.FIXED_LOT_MULTIPLE, PAA.COUNTRY_OF_ORIGIN_CODE, PAA.ENABLE_VMI_FLAG, PAA.VMI_MIN_QTY, PAA.VMI_MAX_QTY, PAA.ENABLE_VMI_AUTO_REPLENISH_FLAG, PAA.VMI_REPLENISHMENT_APPROVAL, PAA.CONSIGNED_FROM_SUPPLIER_FLAG, PAA.LAST_BILLING_DATE, PAA.CONSIGNED_BILLING_CYCLE, PAA.CONSUME_ON_AGING_FLAG, PAA.AGING_PERIOD, PAA.REPLENISHMENT_METHOD, PAA.VMI_MIN_DAYS, PAA.VMI_MAX_DAYS, PAA.FIXED_ORDER_QUANTITY, PAA.FORECAST_HORIZON FROM PO_ASL_ATTRIBUTES PAA, PO_APPROVED_SUPPLIER_LIST PASL WHERE PAA.ASL_ID = PASL.ASL_ID AND NVL(PASL.DISABLE_FLAG, 'N') = 'N'