View: SO_ITEM_GROUP_LINES_ALL_V

Product:	OE - Order Entry
Description:
Implementation/DBA Data:	APPS.SO_ITEM_GROUP_LINES_ALL_V

View Text

SELECT SIGL.ROWID ROW_ID
, SIGL.GROUP_LINE_ID
, SIGL.CREATION_DATE
, SIGL.CREATED_BY
, SIGL.LAST_UPDATE_DATE
, SIGL.LAST_UPDATED_BY
, SIGL.LAST_UPDATE_LOGIN
, SIGL.GROUP_ID
, SIGL.INVENTORY_ITEM_ID
, SIGL.UNIT_CODE
, SIGL.METHOD_CODE
, SIGL.PRICING_RULE_ID
, SIGL.LIST_PRICE
, SIGL.CURRENCY_CODE
, SIGL.CONTEXT
, SIGL.ATTRIBUTE1
, SIGL.ATTRIBUTE2
, SIGL.ATTRIBUTE3
, SIGL.ATTRIBUTE4
, SIGL.ATTRIBUTE5
, SIGL.ATTRIBUTE6
, SIGL.ATTRIBUTE7
, SIGL.ATTRIBUTE8
, SIGL.ATTRIBUTE9
, SIGL.ATTRIBUTE10
, SIGL.ATTRIBUTE11
, SIGL.ATTRIBUTE12
, SIGL.ATTRIBUTE13
, SIGL.ATTRIBUTE14
, SIGL.ATTRIBUTE15
, SIGL.PRICING_CONTEXT
, SIGL.PRICING_ATTRIBUTE1
, SIGL.PRICING_ATTRIBUTE2
, SIGL.PRICING_ATTRIBUTE3
, SIGL.PRICING_ATTRIBUTE4
, SIGL.PRICING_ATTRIBUTE5
, SIGL.PRICING_ATTRIBUTE6
, SIGL.PRICING_ATTRIBUTE7
, SIGL.PRICING_ATTRIBUTE8
, SIGL.PRICING_ATTRIBUTE9
, SIGL.PRICING_ATTRIBUTE10
, SIGL.PRICING_ATTRIBUTE11
, SIGL.PRICING_ATTRIBUTE12
, SIGL.PRICING_ATTRIBUTE13
, SIGL.PRICING_ATTRIBUTE14
, SIGL.PRICING_ATTRIBUTE15
, MSI.PADDED_CONCATENATED_SEGMENTS
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION ITEM_DESCRIPTION
, MSI.PRIMARY_UNIT_OF_MEASURE
, SPR.NAME
FROM MTL_SYSTEM_ITEMS_KFV MSI
, SO_PRICING_RULES SPR
, SO_ITEM_GROUP_LINES SIGL
WHERE MSI.INVENTORY_ITEM_ID = SIGL.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = TO_NUMBER(FND_PROFILE.VALUE( 'SO_ORGANIZATION_ID'))
AND SPR.PRICING_RULE_ID (+) = SIGL.PRICING_RULE_ID

Columns