[Home] [Help]
[Dependency Information]
Object Name: | GMF_XLA_ITEM_CATEGORIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View for SLA ADR sources from item categories.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Inventory Item identifier | ||
ORGANIZATION_ID | NUMBER | Inventory Organization identifier | ||
ALLOC_CAT_CATEGORY_ID | NUMBER | Allocation class category identifier | ||
ALLOC_CAT_CATEGORY_SET_ID | NUMBER | Allocation class category set identifier | ||
ALLOC_CAT_CONCAT_SEGMENTS | VARCHAR2 | (0) | Allocation class category concatenated segment value | |
ALLOC_CAT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Allocation class flexfield attribute category | |
ALLOC_CAT_ATTRIBUTE1 | VARCHAR2 | (150) | Allocation class flexfield attribute | |
ALLOC_CAT_ATTRIBUTE2 | VARCHAR2 | (150) | Allocation class flexfield attribute | |
ALLOC_CAT_ATTRIBUTE3 | VARCHAR2 | (150) | Allocation class flexfield attribute | |
ALLOC_CAT_ATTRIBUTE4 | VARCHAR2 | (150) | Allocation class flexfield attribute | |
ALLOC_CAT_ATTRIBUTE5 | VARCHAR2 | (150) | Allocation class flexfield attribute | |
ALLOC_CAT_ATTRIBUTE6 | VARCHAR2 | (150) | Allocation class flexfield attribute | |
ALLOC_CAT_ATTRIBUTE7 | VARCHAR2 | (150) | Allocation class flexfield attribute | |
ALLOC_CAT_ATTRIBUTE8 | VARCHAR2 | (150) | Allocation class flexfield attribute | |
ALLOC_CAT_ATTRIBUTE9 | VARCHAR2 | (150) | Allocation class flexfield attribute | |
ALLOC_CAT_ATTRIBUTE10 | VARCHAR2 | (150) | Allocation class flexfield attribute | |
ALLOC_CAT_ATTRIBUTE11 | VARCHAR2 | (150) | Allocation class flexfield attribute | |
ALLOC_CAT_ATTRIBUTE12 | VARCHAR2 | (150) | Allocation class flexfield attribute | |
ALLOC_CAT_ATTRIBUTE13 | VARCHAR2 | (150) | Allocation class flexfield attribute | |
ALLOC_CAT_ATTRIBUTE14 | VARCHAR2 | (150) | Allocation class flexfield attribute | |
ALLOC_CAT_ATTRIBUTE15 | VARCHAR2 | (150) | Allocation class flexfield attribute | |
ALLOC_CAT_SEGMENT1 | VARCHAR2 | (40) | Allocation class segment | |
ALLOC_CAT_SEGMENT2 | VARCHAR2 | (40) | Allocation class segment | |
ALLOC_CAT_SEGMENT3 | VARCHAR2 | (40) | Allocation class segment | |
ALLOC_CAT_SEGMENT4 | VARCHAR2 | (40) | Allocation class segment | |
ALLOC_CAT_SEGMENT5 | VARCHAR2 | (40) | Allocation class segment | |
ALLOC_CAT_SEGMENT6 | VARCHAR2 | (40) | Allocation class segment | |
ALLOC_CAT_SEGMENT7 | VARCHAR2 | (40) | Allocation class segment | |
ALLOC_CAT_SEGMENT8 | VARCHAR2 | (40) | Allocation class segment | |
ALLOC_CAT_SEGMENT9 | VARCHAR2 | (40) | Allocation class segment | |
ALLOC_CAT_SEGMENT10 | VARCHAR2 | (40) | Allocation class segment | |
ALLOC_CAT_SEGMENT11 | VARCHAR2 | (40) | Allocation class segment | |
ALLOC_CAT_SEGMENT12 | VARCHAR2 | (40) | Allocation class segment | |
ALLOC_CAT_SEGMENT13 | VARCHAR2 | (40) | Allocation class segment | |
ALLOC_CAT_SEGMENT14 | VARCHAR2 | (40) | Allocation class segment | |
ALLOC_CAT_SEGMENT15 | VARCHAR2 | (40) | Allocation class segment | |
ALLOC_CAT_SEGMENT16 | VARCHAR2 | (40) | Allocation class segment | |
ALLOC_CAT_SEGMENT17 | VARCHAR2 | (40) | Allocation class segment | |
ALLOC_CAT_SEGMENT18 | VARCHAR2 | (40) | Allocation class segment | |
ALLOC_CAT_SEGMENT19 | VARCHAR2 | (40) | Allocation class segment | |
ALLOC_CAT_SEGMENT20 | VARCHAR2 | (40) | Allocation class segment | |
SSIC_CAT_CATEGORY_ID | NUMBER | Sub-standard Item class category identifier | ||
SSIC_CAT_CATEGORY_SET_ID | NUMBER | Sub-standard item class category set identifier | ||
SSIC_CAT_CONCAT_SEGMENTS | VARCHAR2 | (0) | Sub-standard item class category concatenated segment value | |
SSIC_CAT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Sub-standard item class flexfield attribute category | |
SSIC_CAT_ATTRIBUTE1 | VARCHAR2 | (150) | Sub-standard item class flexfield attribute | |
SSIC_CAT_ATTRIBUTE2 | VARCHAR2 | (150) | Sub-standard item class flexfield attribute | |
SSIC_CAT_ATTRIBUTE3 | VARCHAR2 | (150) | Sub-standard item class flexfield attribute | |
SSIC_CAT_ATTRIBUTE4 | VARCHAR2 | (150) | Sub-standard item class flexfield attribute | |
SSIC_CAT_ATTRIBUTE5 | VARCHAR2 | (150) | Sub-standard item class flexfield attribute | |
SSIC_CAT_ATTRIBUTE6 | VARCHAR2 | (150) | Sub-standard item class flexfield attribute | |
SSIC_CAT_ATTRIBUTE7 | VARCHAR2 | (150) | Sub-standard item class flexfield attribute | |
SSIC_CAT_ATTRIBUTE8 | VARCHAR2 | (150) | Sub-standard item class flexfield attribute | |
SSIC_CAT_ATTRIBUTE9 | VARCHAR2 | (150) | Sub-standard item class flexfield attribute | |
SSIC_CAT_ATTRIBUTE10 | VARCHAR2 | (150) | Sub-standard item class flexfield attribute | |
SSIC_CAT_ATTRIBUTE11 | VARCHAR2 | (150) | Sub-standard item class flexfield attribute | |
SSIC_CAT_ATTRIBUTE12 | VARCHAR2 | (150) | Sub-standard item class flexfield attribute | |
SSIC_CAT_ATTRIBUTE13 | VARCHAR2 | (150) | Sub-standard item class flexfield attribute | |
SSIC_CAT_ATTRIBUTE14 | VARCHAR2 | (150) | Sub-standard item class flexfield attribute | |
SSIC_CAT_ATTRIBUTE15 | VARCHAR2 | (150) | Sub-standard item class flexfield attribute | |
SSIC_CAT_SEGMENT1 | VARCHAR2 | (40) | Sub-standard item class segment | |
SSIC_CAT_SEGMENT2 | VARCHAR2 | (40) | Sub-standard item class segment | |
SSIC_CAT_SEGMENT3 | VARCHAR2 | (40) | Sub-standard item class segment | |
SSIC_CAT_SEGMENT4 | VARCHAR2 | (40) | Sub-standard item class segment | |
SSIC_CAT_SEGMENT5 | VARCHAR2 | (40) | Sub-standard item class segment | |
SSIC_CAT_SEGMENT6 | VARCHAR2 | (40) | Sub-standard item class segment | |
SSIC_CAT_SEGMENT7 | VARCHAR2 | (40) | Sub-standard item class segment | |
SSIC_CAT_SEGMENT8 | VARCHAR2 | (40) | Sub-standard item class segment | |
SSIC_CAT_SEGMENT9 | VARCHAR2 | (40) | Sub-standard item class segment | |
SSIC_CAT_SEGMENT10 | VARCHAR2 | (40) | Sub-standard item class segment | |
SSIC_CAT_SEGMENT11 | VARCHAR2 | (40) | Sub-standard item class segment | |
SSIC_CAT_SEGMENT12 | VARCHAR2 | (40) | Sub-standard item class segment | |
SSIC_CAT_SEGMENT13 | VARCHAR2 | (40) | Sub-standard item class segment | |
SSIC_CAT_SEGMENT14 | VARCHAR2 | (40) | Sub-standard item class segment | |
SSIC_CAT_SEGMENT15 | VARCHAR2 | (40) | Sub-standard item class segment | |
SSIC_CAT_SEGMENT16 | VARCHAR2 | (40) | Sub-standard item class segment | |
SSIC_CAT_SEGMENT17 | VARCHAR2 | (40) | Sub-standard item class segment | |
SSIC_CAT_SEGMENT18 | VARCHAR2 | (40) | Sub-standard item class segment | |
SSIC_CAT_SEGMENT19 | VARCHAR2 | (40) | Sub-standard item class segment | |
SSIC_CAT_SEGMENT20 | VARCHAR2 | (40) | Sub-standard item class segment | |
GL_CAT_CATEGORY_ID | NUMBER | Item GL Class category identifier | ||
GL_CAT_CATEGORY_SET_ID | NUMBER | Item GL Class category set identifier | ||
GL_CAT_CONCAT_SEGMENTS | VARCHAR2 | (0) | Item GL Class category concatenated segment value | |
GL_CAT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Item GL Class flexfield attribute category | |
GL_CAT_ATTRIBUTE1 | VARCHAR2 | (150) | Item GL Class flexfield attribute | |
GL_CAT_ATTRIBUTE2 | VARCHAR2 | (150) | Item GL Class flexfield attribute | |
GL_CAT_ATTRIBUTE3 | VARCHAR2 | (150) | Item GL Class flexfield attribute | |
GL_CAT_ATTRIBUTE4 | VARCHAR2 | (150) | Item GL Class flexfield attribute | |
GL_CAT_ATTRIBUTE5 | VARCHAR2 | (150) | Item GL Class flexfield attribute | |
GL_CAT_ATTRIBUTE6 | VARCHAR2 | (150) | Item GL Class flexfield attribute | |
GL_CAT_ATTRIBUTE7 | VARCHAR2 | (150) | Item GL Class flexfield attribute | |
GL_CAT_ATTRIBUTE8 | VARCHAR2 | (150) | Item GL Class flexfield attribute | |
GL_CAT_ATTRIBUTE9 | VARCHAR2 | (150) | Item GL Class flexfield attribute | |
GL_CAT_ATTRIBUTE10 | VARCHAR2 | (150) | Item GL Class flexfield attribute | |
GL_CAT_ATTRIBUTE11 | VARCHAR2 | (150) | Item GL Class flexfield attribute | |
GL_CAT_ATTRIBUTE12 | VARCHAR2 | (150) | Item GL Class flexfield attribute | |
GL_CAT_ATTRIBUTE13 | VARCHAR2 | (150) | Item GL Class flexfield attribute | |
GL_CAT_ATTRIBUTE14 | VARCHAR2 | (150) | Item GL Class flexfield attribute | |
GL_CAT_ATTRIBUTE15 | VARCHAR2 | (150) | Item GL Class flexfield attribute | |
GL_CAT_SEGMENT1 | VARCHAR2 | (40) | Item GL Class segment | |
GL_CAT_SEGMENT2 | VARCHAR2 | (40) | Item GL Class segment | |
GL_CAT_SEGMENT3 | VARCHAR2 | (40) | Item GL Class segment | |
GL_CAT_SEGMENT4 | VARCHAR2 | (40) | Item GL Class segment | |
GL_CAT_SEGMENT5 | VARCHAR2 | (40) | Item GL Class segment | |
GL_CAT_SEGMENT6 | VARCHAR2 | (40) | Item GL Class segment | |
GL_CAT_SEGMENT7 | VARCHAR2 | (40) | Item GL Class segment | |
GL_CAT_SEGMENT8 | VARCHAR2 | (40) | Item GL Class segment | |
GL_CAT_SEGMENT9 | VARCHAR2 | (40) | Item GL Class segment | |
GL_CAT_SEGMENT10 | VARCHAR2 | (40) | Item GL Class segment | |
GL_CAT_SEGMENT11 | VARCHAR2 | (40) | Item GL Class segment | |
GL_CAT_SEGMENT12 | VARCHAR2 | (40) | Item GL Class segment | |
GL_CAT_SEGMENT13 | VARCHAR2 | (40) | Item GL Class segment | |
GL_CAT_SEGMENT14 | VARCHAR2 | (40) | Item GL Class segment | |
GL_CAT_SEGMENT15 | VARCHAR2 | (40) | Item GL Class segment | |
GL_CAT_SEGMENT16 | VARCHAR2 | (40) | Item GL Class segment | |
GL_CAT_SEGMENT17 | VARCHAR2 | (40) | Item GL Class segment | |
GL_CAT_SEGMENT18 | VARCHAR2 | (40) | Item GL Class segment | |
GL_CAT_SEGMENT19 | VARCHAR2 | (40) | Item GL Class segment | |
GL_CAT_SEGMENT20 | VARCHAR2 | (40) | Item GL Class segment | |
BC_CAT_CATEGORY_ID | NUMBER | Item Business Class category identifier | ||
BC_CAT_CATEGORY_SET_ID | NUMBER | Item Business Class category set identifier | ||
BC_CAT_CONCAT_SEGMENTS | VARCHAR2 | (0) | Item Business Class Category concatenated segment value | |
BC_CAT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Item Business class flexfield attribute category | |
BC_CAT_ATTRIBUTE1 | VARCHAR2 | (150) | Item Business class flexfield attribute | |
BC_CAT_ATTRIBUTE2 | VARCHAR2 | (150) | Item Business class flexfield attribute | |
BC_CAT_ATTRIBUTE3 | VARCHAR2 | (150) | Item Business class flexfield attribute | |
BC_CAT_ATTRIBUTE4 | VARCHAR2 | (150) | Item Business class flexfield attribute | |
BC_CAT_ATTRIBUTE5 | VARCHAR2 | (150) | Item Business class flexfield attribute | |
BC_CAT_ATTRIBUTE6 | VARCHAR2 | (150) | Item Business class flexfield attribute | |
BC_CAT_ATTRIBUTE7 | VARCHAR2 | (150) | Item Business class flexfield attribute | |
BC_CAT_ATTRIBUTE8 | VARCHAR2 | (150) | Item Business class flexfield attribute | |
BC_CAT_ATTRIBUTE9 | VARCHAR2 | (150) | Item Business class flexfield attribute | |
BC_CAT_ATTRIBUTE10 | VARCHAR2 | (150) | Item Business class flexfield attribute | |
BC_CAT_ATTRIBUTE11 | VARCHAR2 | (150) | Item Business class flexfield attribute | |
BC_CAT_ATTRIBUTE12 | VARCHAR2 | (150) | Item Business class flexfield attribute | |
BC_CAT_ATTRIBUTE13 | VARCHAR2 | (150) | Item Business class flexfield attribute | |
BC_CAT_ATTRIBUTE14 | VARCHAR2 | (150) | Item Business class flexfield attribute | |
BC_CAT_ATTRIBUTE15 | VARCHAR2 | (150) | Item Business class flexfield attribute | |
BC_CAT_SEGMENT1 | VARCHAR2 | (40) | Item Business class segment | |
BC_CAT_SEGMENT2 | VARCHAR2 | (40) | Item Business class segment | |
BC_CAT_SEGMENT3 | VARCHAR2 | (40) | Item Business class segment | |
BC_CAT_SEGMENT4 | VARCHAR2 | (40) | Item Business class segment | |
BC_CAT_SEGMENT5 | VARCHAR2 | (40) | Item Business class segment | |
BC_CAT_SEGMENT6 | VARCHAR2 | (40) | Item Business class segment | |
BC_CAT_SEGMENT7 | VARCHAR2 | (40) | Item Business class segment | |
BC_CAT_SEGMENT8 | VARCHAR2 | (40) | Item Business class segment | |
BC_CAT_SEGMENT9 | VARCHAR2 | (40) | Item Business class segment | |
BC_CAT_SEGMENT10 | VARCHAR2 | (40) | Item Business class segment | |
BC_CAT_SEGMENT11 | VARCHAR2 | (40) | Item Business class segment | |
BC_CAT_SEGMENT12 | VARCHAR2 | (40) | Item Business class segment | |
BC_CAT_SEGMENT13 | VARCHAR2 | (40) | Item Business class segment | |
BC_CAT_SEGMENT14 | VARCHAR2 | (40) | Item Business class segment | |
BC_CAT_SEGMENT15 | VARCHAR2 | (40) | Item Business class segment | |
BC_CAT_SEGMENT16 | VARCHAR2 | (40) | Item Business class segment | |
BC_CAT_SEGMENT17 | VARCHAR2 | (40) | Item Business class segment | |
BC_CAT_SEGMENT18 | VARCHAR2 | (40) | Item Business class segment | |
BC_CAT_SEGMENT19 | VARCHAR2 | (40) | Item Business class segment | |
BC_CAT_SEGMENT20 | VARCHAR2 | (40) | Item Business class segment | |
COST_CAT_CATEGORY_ID | NUMBER | Item Cost Category identifier | ||
COST_CAT_CATEGORY_SET_ID | NUMBER | Item Cost Category Set identifier | ||
COST_CAT_CONCAT_SEGMENTS | VARCHAR2 | (0) | Item Cost Category concatenated segment value | |
COST_CAT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Item Cost Category descriptive flexfield attribute category | |
COST_CAT_ATTRIBUTE1 | VARCHAR2 | (150) | Item Cost category flexfield attribute | |
COST_CAT_ATTRIBUTE2 | VARCHAR2 | (150) | Item Cost category flexfield attribute | |
COST_CAT_ATTRIBUTE3 | VARCHAR2 | (150) | Item Cost category flexfield attribute | |
COST_CAT_ATTRIBUTE4 | VARCHAR2 | (150) | Item Cost category flexfield attribute | |
COST_CAT_ATTRIBUTE5 | VARCHAR2 | (150) | Item Cost category flexfield attribute | |
COST_CAT_ATTRIBUTE6 | VARCHAR2 | (150) | Item Cost category flexfield attribute | |
COST_CAT_ATTRIBUTE7 | VARCHAR2 | (150) | Item Cost category flexfield attribute | |
COST_CAT_ATTRIBUTE8 | VARCHAR2 | (150) | Item Cost category flexfield attribute | |
COST_CAT_ATTRIBUTE9 | VARCHAR2 | (150) | Item Cost category flexfield attribute | |
COST_CAT_ATTRIBUTE10 | VARCHAR2 | (150) | Item Cost category flexfield attribute | |
COST_CAT_ATTRIBUTE11 | VARCHAR2 | (150) | Item Cost category flexfield attribute | |
COST_CAT_ATTRIBUTE12 | VARCHAR2 | (150) | Item Cost category flexfield attribute | |
COST_CAT_ATTRIBUTE13 | VARCHAR2 | (150) | Item Cost category flexfield attribute | |
COST_CAT_ATTRIBUTE14 | VARCHAR2 | (150) | Item Cost category flexfield attribute | |
COST_CAT_ATTRIBUTE15 | VARCHAR2 | (150) | Item Cost category flexfield attribute | |
COST_CAT_SEGMENT1 | VARCHAR2 | (40) | Item Cost category segment | |
COST_CAT_SEGMENT2 | VARCHAR2 | (40) | Item Cost category segment | |
COST_CAT_SEGMENT3 | VARCHAR2 | (40) | Item Cost category segment | |
COST_CAT_SEGMENT4 | VARCHAR2 | (40) | Item Cost category segment | |
COST_CAT_SEGMENT5 | VARCHAR2 | (40) | Item Cost category segment | |
COST_CAT_SEGMENT6 | VARCHAR2 | (40) | Item Cost category segment | |
COST_CAT_SEGMENT7 | VARCHAR2 | (40) | Item Cost category segment | |
COST_CAT_SEGMENT8 | VARCHAR2 | (40) | Item Cost category segment | |
COST_CAT_SEGMENT9 | VARCHAR2 | (40) | Item Cost category segment | |
COST_CAT_SEGMENT10 | VARCHAR2 | (40) | Item Cost category segment | |
COST_CAT_SEGMENT11 | VARCHAR2 | (40) | Item Cost category segment | |
COST_CAT_SEGMENT12 | VARCHAR2 | (40) | Item Cost category segment | |
COST_CAT_SEGMENT13 | VARCHAR2 | (40) | Item Cost category segment | |
COST_CAT_SEGMENT14 | VARCHAR2 | (40) | Item Cost category segment | |
COST_CAT_SEGMENT15 | VARCHAR2 | (40) | Item Cost category segment | |
COST_CAT_SEGMENT16 | VARCHAR2 | (40) | Item Cost category segment | |
COST_CAT_SEGMENT17 | VARCHAR2 | (40) | Item Cost category segment | |
COST_CAT_SEGMENT18 | VARCHAR2 | (40) | Item Cost category segment | |
COST_CAT_SEGMENT19 | VARCHAR2 | (40) | Item Cost category segment | |
COST_CAT_SEGMENT20 | VARCHAR2 | (40) | Item Cost category segment | |
PL_CAT_CATEGORY_ID | NUMBER | Item Product Line category identifier | ||
PL_CAT_CATEGORY_SET_ID | NUMBER | Item Product Line category set identifier | ||
PL_CAT_CONCAT_SEGMENTS | VARCHAR2 | (0) | Item Product Line category concatenated segment value | |
PL_CAT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Item Product Line category flexfield attribute category | |
PL_CAT_ATTRIBUTE1 | VARCHAR2 | (150) | Item Product Line category flexfield attribute | |
PL_CAT_ATTRIBUTE2 | VARCHAR2 | (150) | Item Product Line category flexfield attribute | |
PL_CAT_ATTRIBUTE3 | VARCHAR2 | (150) | Item Product Line category flexfield attribute | |
PL_CAT_ATTRIBUTE4 | VARCHAR2 | (150) | Item Product Line category flexfield attribute | |
PL_CAT_ATTRIBUTE5 | VARCHAR2 | (150) | Item Product Line category flexfield attribute | |
PL_CAT_ATTRIBUTE6 | VARCHAR2 | (150) | Item Product Line category flexfield attribute | |
PL_CAT_ATTRIBUTE7 | VARCHAR2 | (150) | Item Product Line category flexfield attribute | |
PL_CAT_ATTRIBUTE8 | VARCHAR2 | (150) | Item Product Line category flexfield attribute | |
PL_CAT_ATTRIBUTE9 | VARCHAR2 | (150) | Item Product Line category flexfield attribute | |
PL_CAT_ATTRIBUTE10 | VARCHAR2 | (150) | Item Product Line category flexfield attribute | |
PL_CAT_ATTRIBUTE11 | VARCHAR2 | (150) | Item Product Line category flexfield attribute | |
PL_CAT_ATTRIBUTE12 | VARCHAR2 | (150) | Item Product Line category flexfield attribute | |
PL_CAT_ATTRIBUTE13 | VARCHAR2 | (150) | Item Product Line category flexfield attribute | |
PL_CAT_ATTRIBUTE14 | VARCHAR2 | (150) | Item Product Line category flexfield attribute | |
PL_CAT_ATTRIBUTE15 | VARCHAR2 | (150) | Item Product Line category flexfield attribute | |
PL_CAT_SEGMENT1 | VARCHAR2 | (40) | Item Product Line category segment | |
PL_CAT_SEGMENT2 | VARCHAR2 | (40) | Item Product Line category segment | |
PL_CAT_SEGMENT3 | VARCHAR2 | (40) | Item Product Line category segment | |
PL_CAT_SEGMENT4 | VARCHAR2 | (40) | Item Product Line category segment | |
PL_CAT_SEGMENT5 | VARCHAR2 | (40) | Item Product Line category segment | |
PL_CAT_SEGMENT6 | VARCHAR2 | (40) | Item Product Line category segment | |
PL_CAT_SEGMENT7 | VARCHAR2 | (40) | Item Product Line category segment | |
PL_CAT_SEGMENT8 | VARCHAR2 | (40) | Item Product Line category segment | |
PL_CAT_SEGMENT9 | VARCHAR2 | (40) | Item Product Line category segment | |
PL_CAT_SEGMENT10 | VARCHAR2 | (40) | Item Product Line category segment | |
PL_CAT_SEGMENT11 | VARCHAR2 | (40) | Item Product Line category segment | |
PL_CAT_SEGMENT12 | VARCHAR2 | (40) | Item Product Line category segment | |
PL_CAT_SEGMENT13 | VARCHAR2 | (40) | Item Product Line category segment | |
PL_CAT_SEGMENT14 | VARCHAR2 | (40) | Item Product Line category segment | |
PL_CAT_SEGMENT15 | VARCHAR2 | (40) | Item Product Line category segment | |
PL_CAT_SEGMENT16 | VARCHAR2 | (40) | Item Product Line category segment | |
PL_CAT_SEGMENT17 | VARCHAR2 | (40) | Item Product Line category segment | |
PL_CAT_SEGMENT18 | VARCHAR2 | (40) | Item Product Line category segment | |
PL_CAT_SEGMENT19 | VARCHAR2 | (40) | Item Product Line category segment | |
PL_CAT_SEGMENT20 | VARCHAR2 | (40) | Item Product Line category segment |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, ALLOC_CAT_CATEGORY_ID
, ALLOC_CAT_CATEGORY_SET_ID
, ALLOC_CAT_CONCAT_SEGMENTS
, ALLOC_CAT_ATTRIBUTE_CATEGORY
, ALLOC_CAT_ATTRIBUTE1
, ALLOC_CAT_ATTRIBUTE2
, ALLOC_CAT_ATTRIBUTE3
, ALLOC_CAT_ATTRIBUTE4
, ALLOC_CAT_ATTRIBUTE5
, ALLOC_CAT_ATTRIBUTE6
, ALLOC_CAT_ATTRIBUTE7
, ALLOC_CAT_ATTRIBUTE8
, ALLOC_CAT_ATTRIBUTE9
, ALLOC_CAT_ATTRIBUTE10
, ALLOC_CAT_ATTRIBUTE11
, ALLOC_CAT_ATTRIBUTE12
, ALLOC_CAT_ATTRIBUTE13
, ALLOC_CAT_ATTRIBUTE14
, ALLOC_CAT_ATTRIBUTE15
, ALLOC_CAT_SEGMENT1
, ALLOC_CAT_SEGMENT2
, ALLOC_CAT_SEGMENT3
, ALLOC_CAT_SEGMENT4
, ALLOC_CAT_SEGMENT5
, ALLOC_CAT_SEGMENT6
, ALLOC_CAT_SEGMENT7
, ALLOC_CAT_SEGMENT8
, ALLOC_CAT_SEGMENT9
, ALLOC_CAT_SEGMENT10
, ALLOC_CAT_SEGMENT11
, ALLOC_CAT_SEGMENT12
, ALLOC_CAT_SEGMENT13
, ALLOC_CAT_SEGMENT14
, ALLOC_CAT_SEGMENT15
, ALLOC_CAT_SEGMENT16
, ALLOC_CAT_SEGMENT17
, ALLOC_CAT_SEGMENT18
, ALLOC_CAT_SEGMENT19
, ALLOC_CAT_SEGMENT20
, SSIC_CAT_CATEGORY_ID
, SSIC_CAT_CATEGORY_SET_ID
, SSIC_CAT_CONCAT_SEGMENTS
, SSIC_CAT_ATTRIBUTE_CATEGORY
, SSIC_CAT_ATTRIBUTE1
, SSIC_CAT_ATTRIBUTE2
, SSIC_CAT_ATTRIBUTE3
, SSIC_CAT_ATTRIBUTE4
, SSIC_CAT_ATTRIBUTE5
, SSIC_CAT_ATTRIBUTE6
, SSIC_CAT_ATTRIBUTE7
, SSIC_CAT_ATTRIBUTE8
, SSIC_CAT_ATTRIBUTE9
, SSIC_CAT_ATTRIBUTE10
, SSIC_CAT_ATTRIBUTE11
, SSIC_CAT_ATTRIBUTE12
, SSIC_CAT_ATTRIBUTE13
, SSIC_CAT_ATTRIBUTE14
, SSIC_CAT_ATTRIBUTE15
, SSIC_CAT_SEGMENT1
, SSIC_CAT_SEGMENT2
, SSIC_CAT_SEGMENT3
, SSIC_CAT_SEGMENT4
, SSIC_CAT_SEGMENT5
, SSIC_CAT_SEGMENT6
, SSIC_CAT_SEGMENT7
, SSIC_CAT_SEGMENT8
, SSIC_CAT_SEGMENT9
, SSIC_CAT_SEGMENT10
, SSIC_CAT_SEGMENT11
, SSIC_CAT_SEGMENT12
, SSIC_CAT_SEGMENT13
, SSIC_CAT_SEGMENT14
, SSIC_CAT_SEGMENT15
, SSIC_CAT_SEGMENT16
, SSIC_CAT_SEGMENT17
, SSIC_CAT_SEGMENT18
, SSIC_CAT_SEGMENT19
, SSIC_CAT_SEGMENT20
, GL_CAT_CATEGORY_ID
, GL_CAT_CATEGORY_SET_ID
, GL_CAT_CONCAT_SEGMENTS
, GL_CAT_ATTRIBUTE_CATEGORY
, GL_CAT_ATTRIBUTE1
, GL_CAT_ATTRIBUTE2
, GL_CAT_ATTRIBUTE3
, GL_CAT_ATTRIBUTE4
, GL_CAT_ATTRIBUTE5
, GL_CAT_ATTRIBUTE6
, GL_CAT_ATTRIBUTE7
, GL_CAT_ATTRIBUTE8
, GL_CAT_ATTRIBUTE9
, GL_CAT_ATTRIBUTE10
, GL_CAT_ATTRIBUTE11
, GL_CAT_ATTRIBUTE12
, GL_CAT_ATTRIBUTE13
, GL_CAT_ATTRIBUTE14
, GL_CAT_ATTRIBUTE15
, GL_CAT_SEGMENT1
, GL_CAT_SEGMENT2
, GL_CAT_SEGMENT3
, GL_CAT_SEGMENT4
, GL_CAT_SEGMENT5
, GL_CAT_SEGMENT6
, GL_CAT_SEGMENT7
, GL_CAT_SEGMENT8
, GL_CAT_SEGMENT9
, GL_CAT_SEGMENT10
, GL_CAT_SEGMENT11
, GL_CAT_SEGMENT12
, GL_CAT_SEGMENT13
, GL_CAT_SEGMENT14
, GL_CAT_SEGMENT15
, GL_CAT_SEGMENT16
, GL_CAT_SEGMENT17
, GL_CAT_SEGMENT18
, GL_CAT_SEGMENT19
, GL_CAT_SEGMENT20
, BC_CAT_CATEGORY_ID
, BC_CAT_CATEGORY_SET_ID
, BC_CAT_CONCAT_SEGMENTS
, BC_CAT_ATTRIBUTE_CATEGORY
, BC_CAT_ATTRIBUTE1
, BC_CAT_ATTRIBUTE2
, BC_CAT_ATTRIBUTE3
, BC_CAT_ATTRIBUTE4
, BC_CAT_ATTRIBUTE5
, BC_CAT_ATTRIBUTE6
, BC_CAT_ATTRIBUTE7
, BC_CAT_ATTRIBUTE8
, BC_CAT_ATTRIBUTE9
, BC_CAT_ATTRIBUTE10
, BC_CAT_ATTRIBUTE11
, BC_CAT_ATTRIBUTE12
, BC_CAT_ATTRIBUTE13
, BC_CAT_ATTRIBUTE14
, BC_CAT_ATTRIBUTE15
, BC_CAT_SEGMENT1
, BC_CAT_SEGMENT2
, BC_CAT_SEGMENT3
, BC_CAT_SEGMENT4
, BC_CAT_SEGMENT5
, BC_CAT_SEGMENT6
, BC_CAT_SEGMENT7
, BC_CAT_SEGMENT8
, BC_CAT_SEGMENT9
, BC_CAT_SEGMENT10
, BC_CAT_SEGMENT11
, BC_CAT_SEGMENT12
, BC_CAT_SEGMENT13
, BC_CAT_SEGMENT14
, BC_CAT_SEGMENT15
, BC_CAT_SEGMENT16
, BC_CAT_SEGMENT17
, BC_CAT_SEGMENT18
, BC_CAT_SEGMENT19
, BC_CAT_SEGMENT20
, COST_CAT_CATEGORY_ID
, COST_CAT_CATEGORY_SET_ID
, COST_CAT_CONCAT_SEGMENTS
, COST_CAT_ATTRIBUTE_CATEGORY
, COST_CAT_ATTRIBUTE1
, COST_CAT_ATTRIBUTE2
, COST_CAT_ATTRIBUTE3
, COST_CAT_ATTRIBUTE4
, COST_CAT_ATTRIBUTE5
, COST_CAT_ATTRIBUTE6
, COST_CAT_ATTRIBUTE7
, COST_CAT_ATTRIBUTE8
, COST_CAT_ATTRIBUTE9
, COST_CAT_ATTRIBUTE10
, COST_CAT_ATTRIBUTE11
, COST_CAT_ATTRIBUTE12
, COST_CAT_ATTRIBUTE13
, COST_CAT_ATTRIBUTE14
, COST_CAT_ATTRIBUTE15
, COST_CAT_SEGMENT1
, COST_CAT_SEGMENT2
, COST_CAT_SEGMENT3
, COST_CAT_SEGMENT4
, COST_CAT_SEGMENT5
, COST_CAT_SEGMENT6
, COST_CAT_SEGMENT7
, COST_CAT_SEGMENT8
, COST_CAT_SEGMENT9
, COST_CAT_SEGMENT10
, COST_CAT_SEGMENT11
, COST_CAT_SEGMENT12
, COST_CAT_SEGMENT13
, COST_CAT_SEGMENT14
, COST_CAT_SEGMENT15
, COST_CAT_SEGMENT16
, COST_CAT_SEGMENT17
, COST_CAT_SEGMENT18
, COST_CAT_SEGMENT19
, COST_CAT_SEGMENT20
, PL_CAT_CATEGORY_ID
, PL_CAT_CATEGORY_SET_ID
, PL_CAT_CONCAT_SEGMENTS
, PL_CAT_ATTRIBUTE_CATEGORY
, PL_CAT_ATTRIBUTE1
, PL_CAT_ATTRIBUTE2
, PL_CAT_ATTRIBUTE3
, PL_CAT_ATTRIBUTE4
, PL_CAT_ATTRIBUTE5
, PL_CAT_ATTRIBUTE6
, PL_CAT_ATTRIBUTE7
, PL_CAT_ATTRIBUTE8
, PL_CAT_ATTRIBUTE9
, PL_CAT_ATTRIBUTE10
, PL_CAT_ATTRIBUTE11
, PL_CAT_ATTRIBUTE12
, PL_CAT_ATTRIBUTE13
, PL_CAT_ATTRIBUTE14
, PL_CAT_ATTRIBUTE15
, PL_CAT_SEGMENT1
, PL_CAT_SEGMENT2
, PL_CAT_SEGMENT3
, PL_CAT_SEGMENT4
, PL_CAT_SEGMENT5
, PL_CAT_SEGMENT6
, PL_CAT_SEGMENT7
, PL_CAT_SEGMENT8
, PL_CAT_SEGMENT9
, PL_CAT_SEGMENT10
, PL_CAT_SEGMENT11
, PL_CAT_SEGMENT12
, PL_CAT_SEGMENT13
, PL_CAT_SEGMENT14
, PL_CAT_SEGMENT15
, PL_CAT_SEGMENT16
, PL_CAT_SEGMENT17
, PL_CAT_SEGMENT18
, PL_CAT_SEGMENT19
, PL_CAT_SEGMENT20
FROM APPS.GMF_XLA_ITEM_CATEGORIES_V;
APPS.GMF_XLA_ITEM_CATEGORIES_V is not referenced by any database object
|
|
|