VIEW: APPS.CS_CTR_ASSOCIATIONS_V

Source

View Text - Preformatted

SELECT A.ROWID ,A.CTR_ASSOCIATION_ID ,A.COUNTER_GROUP_ID ,A.SOURCE_OBJECT_ID ,B.CONCATENATED_SEGMENTS SOURCE_OBJECT_NAME ,B.DESCRIPTION SOURCE_OBJECT_DESCRIPTION ,A.LAST_UPDATE_DATE ,A.LAST_UPDATED_BY ,A.CREATION_DATE ,A.CREATED_BY ,A.LAST_UPDATE_LOGIN ,A.ATTRIBUTE1 ,A.ATTRIBUTE2 ,A.ATTRIBUTE3 ,A.ATTRIBUTE4 ,A.ATTRIBUTE5 ,A.ATTRIBUTE6 ,A.ATTRIBUTE7 ,A.ATTRIBUTE8 ,A.ATTRIBUTE9 ,A.ATTRIBUTE10 ,A.ATTRIBUTE11 ,A.ATTRIBUTE12 ,A.ATTRIBUTE13 ,A.ATTRIBUTE14 ,A.ATTRIBUTE15 ,A.CONTEXT ,A.OBJECT_VERSION_NUMBER FROM CS_CTR_ASSOCIATIONS A, MTL_SYSTEM_ITEMS_KFV B WHERE A.SOURCE_OBJECT_ID = B.INVENTORY_ITEM_ID (+) AND B.ORGANIZATION_ID(+) = cs_std.get_item_valdn_orgzn_id

View Text - HTML Formatted

SELECT A.ROWID
, A.CTR_ASSOCIATION_ID
, A.COUNTER_GROUP_ID
, A.SOURCE_OBJECT_ID
, B.CONCATENATED_SEGMENTS SOURCE_OBJECT_NAME
, B.DESCRIPTION SOURCE_OBJECT_DESCRIPTION
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.CONTEXT
, A.OBJECT_VERSION_NUMBER
FROM CS_CTR_ASSOCIATIONS A
, MTL_SYSTEM_ITEMS_KFV B
WHERE A.SOURCE_OBJECT_ID = B.INVENTORY_ITEM_ID (+)
AND B.ORGANIZATION_ID(+) = CS_STD.GET_ITEM_VALDN_ORGZN_ID