VIEW: APPS.PO_ASL_ATTRIBUTES_V

Source

View Text - Preformatted

SELECT PAA.ROWID , PAA.ASL_ID , PAA.USING_ORGANIZATION_ID , MP.ORGANIZATION_CODE , HOUT.NAME , PAA.DOCUMENT_SOURCING_METHOD , PLC3.DISPLAYED_FIELD , PAA.RELEASE_GENERATION_METHOD , PLC.DISPLAYED_FIELD , PAA.PURCHASING_UNIT_OF_MEASURE , PAA.ENABLE_PLAN_SCHEDULE_FLAG , PAA.ENABLE_SHIP_SCHEDULE_FLAG , PAA.PLAN_SCHEDULE_TYPE , PLC1.DISPLAYED_FIELD , PAA.SHIP_SCHEDULE_TYPE , PLC2.DISPLAYED_FIELD , PAA.PLAN_BUCKET_PATTERN_ID , CBP.BUCKET_PATTERN_NAME , PAA.SHIP_BUCKET_PATTERN_ID , CBP1.BUCKET_PATTERN_NAME , PAA.ENABLE_AUTOSCHEDULE_FLAG , PAA.SCHEDULER_ID , PPF.FULL_NAME , 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.PROGRAM_APPLICATION_ID , PAA.PROGRAM_ID , PAA.PROGRAM_UPDATE_DATE , PAA.LAST_UPDATE_DATE , PAA.LAST_UPDATED_BY , PAA.CREATION_DATE , PAA.CREATED_BY , PAA.PRICE_UPDATE_TOLERANCE , PAA.PROCESSING_LEAD_TIME , PAA.DELIVERY_CALENDAR , 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_LOOKUP_CODES PLC , PO_LOOKUP_CODES PLC1 , PO_LOOKUP_CODES PLC2 , PO_LOOKUP_CODES PLC3 , PER_PEOPLE_F PPF , MTL_PARAMETERS MP , HR_ORG_UNITS_NO_JOIN HOU , HR_ALL_ORGANIZATION_UNITS_TL HOUT , CHV_BUCKET_PATTERNS CBP , CHV_BUCKET_PATTERNS CBP1 , PO_ASL_ATTRIBUTES PAA WHERE PAA.USING_ORGANIZATION_ID = MP.ORGANIZATION_ID (+) AND PAA.USING_ORGANIZATION_ID = HOU.ORGANIZATION_ID (+) AND PAA.PLAN_BUCKET_PATTERN_ID = CBP.BUCKET_PATTERN_ID(+) AND PAA.SHIP_BUCKET_PATTERN_ID = CBP1.BUCKET_PATTERN_ID(+) AND PAA.SCHEDULER_ID = PPF.PERSON_ID(+) AND PAA.RELEASE_GENERATION_METHOD = PLC.LOOKUP_CODE(+) AND PLC.LOOKUP_TYPE(+) = 'DOC GENERATION METHOD' AND PAA.PLAN_SCHEDULE_TYPE = PLC1.LOOKUP_CODE(+) AND PLC1.LOOKUP_TYPE(+) = 'PLAN_SCHEDULE_SUBTYPE' AND PAA.SHIP_SCHEDULE_TYPE = PLC2.LOOKUP_CODE(+) AND PLC2.LOOKUP_TYPE(+) = 'SHIP_SCHEDULE_SUBTYPE' AND PLC3.LOOKUP_TYPE(+) = 'DOCUMENT_SOURCING_METHOD' AND PAA.DOCUMENT_SOURCING_METHOD = PLC3.LOOKUP_CODE (+) AND hou.organization_id = hout.organization_id (+) AND DECODE(hout.organization_id, null, '1', hout.language) = DECODE(hout.organization_id, null, '1', USERENV('LANG'))

View Text - HTML Formatted

SELECT PAA.ROWID
, PAA.ASL_ID
, PAA.USING_ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOUT.NAME
, PAA.DOCUMENT_SOURCING_METHOD
, PLC3.DISPLAYED_FIELD
, PAA.RELEASE_GENERATION_METHOD
, PLC.DISPLAYED_FIELD
, PAA.PURCHASING_UNIT_OF_MEASURE
, PAA.ENABLE_PLAN_SCHEDULE_FLAG
, PAA.ENABLE_SHIP_SCHEDULE_FLAG
, PAA.PLAN_SCHEDULE_TYPE
, PLC1.DISPLAYED_FIELD
, PAA.SHIP_SCHEDULE_TYPE
, PLC2.DISPLAYED_FIELD
, PAA.PLAN_BUCKET_PATTERN_ID
, CBP.BUCKET_PATTERN_NAME
, PAA.SHIP_BUCKET_PATTERN_ID
, CBP1.BUCKET_PATTERN_NAME
, PAA.ENABLE_AUTOSCHEDULE_FLAG
, PAA.SCHEDULER_ID
, PPF.FULL_NAME
, 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.PROGRAM_APPLICATION_ID
, PAA.PROGRAM_ID
, PAA.PROGRAM_UPDATE_DATE
, PAA.LAST_UPDATE_DATE
, PAA.LAST_UPDATED_BY
, PAA.CREATION_DATE
, PAA.CREATED_BY
, PAA.PRICE_UPDATE_TOLERANCE
, PAA.PROCESSING_LEAD_TIME
, PAA.DELIVERY_CALENDAR
, 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_LOOKUP_CODES PLC
, PO_LOOKUP_CODES PLC1
, PO_LOOKUP_CODES PLC2
, PO_LOOKUP_CODES PLC3
, PER_PEOPLE_F PPF
, MTL_PARAMETERS MP
, HR_ORG_UNITS_NO_JOIN HOU
, HR_ALL_ORGANIZATION_UNITS_TL HOUT
, CHV_BUCKET_PATTERNS CBP
, CHV_BUCKET_PATTERNS CBP1
, PO_ASL_ATTRIBUTES PAA
WHERE PAA.USING_ORGANIZATION_ID = MP.ORGANIZATION_ID (+)
AND PAA.USING_ORGANIZATION_ID = HOU.ORGANIZATION_ID (+)
AND PAA.PLAN_BUCKET_PATTERN_ID = CBP.BUCKET_PATTERN_ID(+)
AND PAA.SHIP_BUCKET_PATTERN_ID = CBP1.BUCKET_PATTERN_ID(+)
AND PAA.SCHEDULER_ID = PPF.PERSON_ID(+)
AND PAA.RELEASE_GENERATION_METHOD = PLC.LOOKUP_CODE(+)
AND PLC.LOOKUP_TYPE(+) = 'DOC GENERATION METHOD'
AND PAA.PLAN_SCHEDULE_TYPE = PLC1.LOOKUP_CODE(+)
AND PLC1.LOOKUP_TYPE(+) = 'PLAN_SCHEDULE_SUBTYPE'
AND PAA.SHIP_SCHEDULE_TYPE = PLC2.LOOKUP_CODE(+)
AND PLC2.LOOKUP_TYPE(+) = 'SHIP_SCHEDULE_SUBTYPE'
AND PLC3.LOOKUP_TYPE(+) = 'DOCUMENT_SOURCING_METHOD'
AND PAA.DOCUMENT_SOURCING_METHOD = PLC3.LOOKUP_CODE (+)
AND HOU.ORGANIZATION_ID = HOUT.ORGANIZATION_ID (+)
AND DECODE(HOUT.ORGANIZATION_ID
, NULL
, '1'
, HOUT.LANGUAGE) = DECODE(HOUT.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))