eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ASO_OA_PRICE_ATTR_HDR_V

Source

View Text - Preformatted


SELECT PRICE_ATTRIBUTE_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID, QUOTE_HEADER_ID, QUOTE_LINE_ID, FLEX_TITLE, PRICING_CONTEXT, PRICING_ATTRIBUTE1, PRICING_ATTRIBUTE2, PRICING_ATTRIBUTE3, PRICING_ATTRIBUTE4, PRICING_ATTRIBUTE5, PRICING_ATTRIBUTE6, PRICING_ATTRIBUTE7, PRICING_ATTRIBUTE8, PRICING_ATTRIBUTE9, PRICING_ATTRIBUTE10, PRICING_ATTRIBUTE11, PRICING_ATTRIBUTE12, PRICING_ATTRIBUTE13, PRICING_ATTRIBUTE14, PRICING_ATTRIBUTE15, PRICING_ATTRIBUTE16, PRICING_ATTRIBUTE17, PRICING_ATTRIBUTE18, PRICING_ATTRIBUTE19, PRICING_ATTRIBUTE20, PRICING_ATTRIBUTE21, PRICING_ATTRIBUTE22, PRICING_ATTRIBUTE23, PRICING_ATTRIBUTE24, PRICING_ATTRIBUTE25, PRICING_ATTRIBUTE26, PRICING_ATTRIBUTE27, PRICING_ATTRIBUTE28, PRICING_ATTRIBUTE29, PRICING_ATTRIBUTE30, PRICING_ATTRIBUTE31, PRICING_ATTRIBUTE32, PRICING_ATTRIBUTE33, PRICING_ATTRIBUTE34, PRICING_ATTRIBUTE35, PRICING_ATTRIBUTE36, PRICING_ATTRIBUTE37, PRICING_ATTRIBUTE38, PRICING_ATTRIBUTE39, PRICING_ATTRIBUTE40, PRICING_ATTRIBUTE41, PRICING_ATTRIBUTE42, PRICING_ATTRIBUTE43, PRICING_ATTRIBUTE44, PRICING_ATTRIBUTE45, PRICING_ATTRIBUTE46, PRICING_ATTRIBUTE47, PRICING_ATTRIBUTE48, PRICING_ATTRIBUTE49, PRICING_ATTRIBUTE50, PRICING_ATTRIBUTE51, PRICING_ATTRIBUTE52, PRICING_ATTRIBUTE53, PRICING_ATTRIBUTE54, PRICING_ATTRIBUTE55, PRICING_ATTRIBUTE56, PRICING_ATTRIBUTE57, PRICING_ATTRIBUTE58, PRICING_ATTRIBUTE59, PRICING_ATTRIBUTE60, PRICING_ATTRIBUTE61, PRICING_ATTRIBUTE62, PRICING_ATTRIBUTE63, PRICING_ATTRIBUTE64, PRICING_ATTRIBUTE65, PRICING_ATTRIBUTE66, PRICING_ATTRIBUTE67, PRICING_ATTRIBUTE68, PRICING_ATTRIBUTE69, PRICING_ATTRIBUTE70, PRICING_ATTRIBUTE71, PRICING_ATTRIBUTE72, PRICING_ATTRIBUTE73, PRICING_ATTRIBUTE74, PRICING_ATTRIBUTE75, PRICING_ATTRIBUTE76, PRICING_ATTRIBUTE77, PRICING_ATTRIBUTE78, PRICING_ATTRIBUTE79, PRICING_ATTRIBUTE80, PRICING_ATTRIBUTE81, PRICING_ATTRIBUTE82, PRICING_ATTRIBUTE83, PRICING_ATTRIBUTE84, PRICING_ATTRIBUTE85, PRICING_ATTRIBUTE86, PRICING_ATTRIBUTE87, PRICING_ATTRIBUTE88, PRICING_ATTRIBUTE89, PRICING_ATTRIBUTE90, PRICING_ATTRIBUTE91, PRICING_ATTRIBUTE92, PRICING_ATTRIBUTE93, PRICING_ATTRIBUTE94, PRICING_ATTRIBUTE95, PRICING_ATTRIBUTE96, PRICING_ATTRIBUTE97, PRICING_ATTRIBUTE98, PRICING_ATTRIBUTE99, PRICING_ATTRIBUTE100, CONTEXT, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER, OVERRIDE_FLAG, 'S' FROM ASO_PRICE_ATTRIBUTES WHERE quote_line_id is null

View Text - HTML Formatted

SELECT PRICE_ATTRIBUTE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, QUOTE_HEADER_ID
, QUOTE_LINE_ID
, FLEX_TITLE
, PRICING_CONTEXT
, PRICING_ATTRIBUTE1
, PRICING_ATTRIBUTE2
, PRICING_ATTRIBUTE3
, PRICING_ATTRIBUTE4
, PRICING_ATTRIBUTE5
, PRICING_ATTRIBUTE6
, PRICING_ATTRIBUTE7
, PRICING_ATTRIBUTE8
, PRICING_ATTRIBUTE9
, PRICING_ATTRIBUTE10
, PRICING_ATTRIBUTE11
, PRICING_ATTRIBUTE12
, PRICING_ATTRIBUTE13
, PRICING_ATTRIBUTE14
, PRICING_ATTRIBUTE15
, PRICING_ATTRIBUTE16
, PRICING_ATTRIBUTE17
, PRICING_ATTRIBUTE18
, PRICING_ATTRIBUTE19
, PRICING_ATTRIBUTE20
, PRICING_ATTRIBUTE21
, PRICING_ATTRIBUTE22
, PRICING_ATTRIBUTE23
, PRICING_ATTRIBUTE24
, PRICING_ATTRIBUTE25
, PRICING_ATTRIBUTE26
, PRICING_ATTRIBUTE27
, PRICING_ATTRIBUTE28
, PRICING_ATTRIBUTE29
, PRICING_ATTRIBUTE30
, PRICING_ATTRIBUTE31
, PRICING_ATTRIBUTE32
, PRICING_ATTRIBUTE33
, PRICING_ATTRIBUTE34
, PRICING_ATTRIBUTE35
, PRICING_ATTRIBUTE36
, PRICING_ATTRIBUTE37
, PRICING_ATTRIBUTE38
, PRICING_ATTRIBUTE39
, PRICING_ATTRIBUTE40
, PRICING_ATTRIBUTE41
, PRICING_ATTRIBUTE42
, PRICING_ATTRIBUTE43
, PRICING_ATTRIBUTE44
, PRICING_ATTRIBUTE45
, PRICING_ATTRIBUTE46
, PRICING_ATTRIBUTE47
, PRICING_ATTRIBUTE48
, PRICING_ATTRIBUTE49
, PRICING_ATTRIBUTE50
, PRICING_ATTRIBUTE51
, PRICING_ATTRIBUTE52
, PRICING_ATTRIBUTE53
, PRICING_ATTRIBUTE54
, PRICING_ATTRIBUTE55
, PRICING_ATTRIBUTE56
, PRICING_ATTRIBUTE57
, PRICING_ATTRIBUTE58
, PRICING_ATTRIBUTE59
, PRICING_ATTRIBUTE60
, PRICING_ATTRIBUTE61
, PRICING_ATTRIBUTE62
, PRICING_ATTRIBUTE63
, PRICING_ATTRIBUTE64
, PRICING_ATTRIBUTE65
, PRICING_ATTRIBUTE66
, PRICING_ATTRIBUTE67
, PRICING_ATTRIBUTE68
, PRICING_ATTRIBUTE69
, PRICING_ATTRIBUTE70
, PRICING_ATTRIBUTE71
, PRICING_ATTRIBUTE72
, PRICING_ATTRIBUTE73
, PRICING_ATTRIBUTE74
, PRICING_ATTRIBUTE75
, PRICING_ATTRIBUTE76
, PRICING_ATTRIBUTE77
, PRICING_ATTRIBUTE78
, PRICING_ATTRIBUTE79
, PRICING_ATTRIBUTE80
, PRICING_ATTRIBUTE81
, PRICING_ATTRIBUTE82
, PRICING_ATTRIBUTE83
, PRICING_ATTRIBUTE84
, PRICING_ATTRIBUTE85
, PRICING_ATTRIBUTE86
, PRICING_ATTRIBUTE87
, PRICING_ATTRIBUTE88
, PRICING_ATTRIBUTE89
, PRICING_ATTRIBUTE90
, PRICING_ATTRIBUTE91
, PRICING_ATTRIBUTE92
, PRICING_ATTRIBUTE93
, PRICING_ATTRIBUTE94
, PRICING_ATTRIBUTE95
, PRICING_ATTRIBUTE96
, PRICING_ATTRIBUTE97
, PRICING_ATTRIBUTE98
, PRICING_ATTRIBUTE99
, PRICING_ATTRIBUTE100
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
, OVERRIDE_FLAG
, 'S'
FROM ASO_PRICE_ATTRIBUTES
WHERE QUOTE_LINE_ID IS NULL