VIEW: APPS.POS_ORD_MODIFIERS_V

Source

View Text - Preformatted

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.PROGRAM_APPLICATION_ID , paa.PROGRAM_ID , paa.PROGRAM_UPDATE_DATE , paa.PRICE_UPDATE_TOLERANCE , paa.PROCESSING_LEAD_TIME , paa.MIN_ORDER_QTY , paa.FIXED_LOT_MULTIPLE , paa.DELIVERY_CALENDAR , paa.COUNTRY_OF_ORIGIN_CODE, pas.PRIMARY_VENDOR_ITEM, msi.segment1, msi.description, MSI.BUYER_ID, MTP.EMPLOYEE_ID, PAA.PURCHASING_UNIT_OF_MEASURE, PAS.PRIMARY_VENDOR_ITEM, MSI.CONCATENATED_SEGMENTS, MSI.ORGANIZATION_ID, HOU.NAME ORG_NAME, POV.VENDOR_NAME, POV.SEGMENT1 VENDOR_NUMBER FROM PO_ASL_ATTRIBUTES PAA, PO_VENDORS POV, PO_APPROVED_SUPPLIER_LIST PAS, MTL_SYSTEM_ITEMS_KFV MSI, MTL_PLANNERS MTP, HR_ALL_ORGANIZATION_UNITS_TL HOU WHERE PAA.USING_ORGANIZATION_ID = -1 AND PAS.ASL_ID = PAA.ASL_ID AND PAA.VENDOR_ID = POV.VENDOR_ID (+) AND MSI.INVENTORY_ITEM_ID = PAA.ITEM_ID AND MSI.ORGANIZATION_ID = PAS.OWNING_ORGANIZATION_ID AND MSI.ORGANIZATION_ID = MTP.ORGANIZATION_ID(+) AND MSI.PLANNER_CODE=MTP.PLANNER_CODE(+) AND HOU.ORGANIZATION_ID (+) = MSI.ORGANIZATION_ID AND HOU.LANGUAGE (+)= USERENV('LANG') AND NVL(PAS.DISABLE_FLAG, 'N') = 'N'

View Text - HTML Formatted

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.PROGRAM_APPLICATION_ID
, PAA.PROGRAM_ID
, PAA.PROGRAM_UPDATE_DATE
, PAA.PRICE_UPDATE_TOLERANCE
, PAA.PROCESSING_LEAD_TIME
, PAA.MIN_ORDER_QTY
, PAA.FIXED_LOT_MULTIPLE
, PAA.DELIVERY_CALENDAR
, PAA.COUNTRY_OF_ORIGIN_CODE
, PAS.PRIMARY_VENDOR_ITEM
, MSI.SEGMENT1
, MSI.DESCRIPTION
, MSI.BUYER_ID
, MTP.EMPLOYEE_ID
, PAA.PURCHASING_UNIT_OF_MEASURE
, PAS.PRIMARY_VENDOR_ITEM
, MSI.CONCATENATED_SEGMENTS
, MSI.ORGANIZATION_ID
, HOU.NAME ORG_NAME
, POV.VENDOR_NAME
, POV.SEGMENT1 VENDOR_NUMBER
FROM PO_ASL_ATTRIBUTES PAA
, PO_VENDORS POV
, PO_APPROVED_SUPPLIER_LIST PAS
, MTL_SYSTEM_ITEMS_KFV MSI
, MTL_PLANNERS MTP
, HR_ALL_ORGANIZATION_UNITS_TL HOU
WHERE PAA.USING_ORGANIZATION_ID = -1
AND PAS.ASL_ID = PAA.ASL_ID
AND PAA.VENDOR_ID = POV.VENDOR_ID (+)
AND MSI.INVENTORY_ITEM_ID = PAA.ITEM_ID
AND MSI.ORGANIZATION_ID = PAS.OWNING_ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = MTP.ORGANIZATION_ID(+)
AND MSI.PLANNER_CODE=MTP.PLANNER_CODE(+)
AND HOU.ORGANIZATION_ID (+) = MSI.ORGANIZATION_ID
AND HOU.LANGUAGE (+)= USERENV('LANG')
AND NVL(PAS.DISABLE_FLAG
, 'N') = 'N'