DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CST_XLA_PLA_CATEGORY_REF_V

Object Details
Object Name: CST_XLA_PLA_CATEGORY_REF_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.CST_XLA_PLA_CATEGORY_REF_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
PLA_CATEGORY_ID NUMBER
Yes Product Line Category ID
PLA_CAT_ITEM_ID NUMBER
Yes Inventory Item ID
PLA_CAT_ORGANIZATION_ID NUMBER
Yes Organization ID
PLA_ITEM_CAT_ATTR_CATEGORY VARCHAR2 (30)
Item Category attribute Category
PLA_ITEM_CAT_ATTRIBUTE1 VARCHAR2 (150)
Item Category attribute1
PLA_ITEM_CAT_ATTRIBUTE2 VARCHAR2 (150)
Item Category attribute2
PLA_ITEM_CAT_ATTRIBUTE3 VARCHAR2 (150)
Item Category attribute3
PLA_ITEM_CAT_ATTRIBUTE4 VARCHAR2 (150)
Item Category attribute4
PLA_ITEM_CAT_ATTRIBUTE5 VARCHAR2 (150)
Item Category attribute5
PLA_ITEM_CAT_ATTRIBUTE6 VARCHAR2 (150)
Item Category attribute6
PLA_ITEM_CAT_ATTRIBUTE7 VARCHAR2 (150)
Item Category attribute7
PLA_ITEM_CAT_ATTRIBUTE8 VARCHAR2 (150)
Item Category attribute8
PLA_ITEM_CAT_ATTRIBUTE9 VARCHAR2 (150)
Item Category attribute9
PLA_ITEM_CAT_ATTRIBUTE10 VARCHAR2 (150)
Item Category attribute10
PLA_ITEM_CAT_ATTRIBUTE11 VARCHAR2 (150)
Item Category attribute11
PLA_ITEM_CAT_ATTRIBUTE12 VARCHAR2 (150)
Item Category attribute12
PLA_ITEM_CAT_ATTRIBUTE13 VARCHAR2 (150)
Item Category attribute13
PLA_ITEM_CAT_ATTRIBUTE14 VARCHAR2 (150)
Item Category attribute14
PLA_ITEM_CAT_ATTRIBUTE15 VARCHAR2 (150)
Item Category attribute15
PLA_ITEM_CAT_SEGMENT1 VARCHAR2 (40)
Item Category segment1
PLA_ITEM_CAT_SEGMENT2 VARCHAR2 (40)
Item Category segment2
PLA_ITEM_CAT_SEGMENT3 VARCHAR2 (40)
Item Category segment3
PLA_ITEM_CAT_SEGMENT4 VARCHAR2 (40)
Item Category segment4
PLA_ITEM_CAT_SEGMENT5 VARCHAR2 (40)
Item Category segment5
PLA_ITEM_CAT_SEGMENT6 VARCHAR2 (40)
Item Category segment6
PLA_ITEM_CAT_SEGMENT7 VARCHAR2 (40)
Item Category segment7
PLA_ITEM_CAT_SEGMENT8 VARCHAR2 (40)
Item Category segment8
PLA_ITEM_CAT_SEGMENT9 VARCHAR2 (40)
Item Category segment9
PLA_ITEM_CAT_SEGMENT10 VARCHAR2 (40)
Item Category segment10
PLA_ITEM_CAT_SEGMENT11 VARCHAR2 (40)
Item Category segment11
PLA_ITEM_CAT_SEGMENT12 VARCHAR2 (40)
Item Category segment12
PLA_ITEM_CAT_SEGMENT13 VARCHAR2 (40)
Item Category segment13
PLA_ITEM_CAT_SEGMENT14 VARCHAR2 (40)
Item Category segment14
PLA_ITEM_CAT_SEGMENT15 VARCHAR2 (40)
Item Category segment15
PLA_ITEM_CAT_SEGMENT16 VARCHAR2 (40)
Item Category segment16
PLA_ITEM_CAT_SEGMENT17 VARCHAR2 (40)
Item Category segment17
PLA_ITEM_CAT_SEGMENT18 VARCHAR2 (40)
Item Category segment18
PLA_ITEM_CAT_SEGMENT19 VARCHAR2 (40)
Item Category segment19
PLA_ITEM_CAT_SEGMENT20 VARCHAR2 (40)
Item Category segment20
PLA_BRIDGING_ACCOUNT NUMBER

Product Line Category Bridging Account
PLA_EXPENSE_ACCOUNT NUMBER

Product Line Category Expense Account
PLA_MATERIAL_ACCOUNT NUMBER

Product Line Category Material Account
PLA_MATERIAL_OVERHEAD_ACCOUNT NUMBER

Product Line Category Material Overhead Account
PLA_OUTSIDE_PROCESSING_ACCOUNT NUMBER

Product Line Category Outside Processing Account
PLA_OVERHEAD_ACCOUNT NUMBER

Product Line Category Overhead Account
PLA_RESOURCE_ACCOUNT NUMBER

Product Line Category Resource Account
PLA_SUBINV_CG VARCHAR2 (40)
Product Line Category Subinventory code or Cost Group
PLA_ACV_ACCOUNT NUMBER

Product Line Category Average Cost Variance Account
PLA_ENCUMBRANCE_ACCOUNT NUMBER

Product Line Category Encumbrance Account
PLA_ANALYTICAL_IPV_ACCT NUMBER

Product Line Category Invoice Price Variance Account
PLA_ANALYTICAL_PO_MIRROR_ACCT NUMBER

Product Line Category PO Mirror Account
PLA_NON_INVOICED_SO_ACCT NUMBER

Product Line Category Non Invoiced SO Account
PLA_NON_INVOICED_REV_ACCT NUMBER

Product Line Category Non Invoiced Revenue Account
PLA_ANALYTICAL_REV_MIRROR_ACCT NUMBER

Product Line Category Non Invoiced Revenue Account
PLA_ANALYTICAL_MOGS_ACCT NUMBER

Product Line Category Margin of Good Sold Account
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PLA_CATEGORY_ID
,      PLA_CAT_ITEM_ID
,      PLA_CAT_ORGANIZATION_ID
,      PLA_ITEM_CAT_ATTR_CATEGORY
,      PLA_ITEM_CAT_ATTRIBUTE1
,      PLA_ITEM_CAT_ATTRIBUTE2
,      PLA_ITEM_CAT_ATTRIBUTE3
,      PLA_ITEM_CAT_ATTRIBUTE4
,      PLA_ITEM_CAT_ATTRIBUTE5
,      PLA_ITEM_CAT_ATTRIBUTE6
,      PLA_ITEM_CAT_ATTRIBUTE7
,      PLA_ITEM_CAT_ATTRIBUTE8
,      PLA_ITEM_CAT_ATTRIBUTE9
,      PLA_ITEM_CAT_ATTRIBUTE10
,      PLA_ITEM_CAT_ATTRIBUTE11
,      PLA_ITEM_CAT_ATTRIBUTE12
,      PLA_ITEM_CAT_ATTRIBUTE13
,      PLA_ITEM_CAT_ATTRIBUTE14
,      PLA_ITEM_CAT_ATTRIBUTE15
,      PLA_ITEM_CAT_SEGMENT1
,      PLA_ITEM_CAT_SEGMENT2
,      PLA_ITEM_CAT_SEGMENT3
,      PLA_ITEM_CAT_SEGMENT4
,      PLA_ITEM_CAT_SEGMENT5
,      PLA_ITEM_CAT_SEGMENT6
,      PLA_ITEM_CAT_SEGMENT7
,      PLA_ITEM_CAT_SEGMENT8
,      PLA_ITEM_CAT_SEGMENT9
,      PLA_ITEM_CAT_SEGMENT10
,      PLA_ITEM_CAT_SEGMENT11
,      PLA_ITEM_CAT_SEGMENT12
,      PLA_ITEM_CAT_SEGMENT13
,      PLA_ITEM_CAT_SEGMENT14
,      PLA_ITEM_CAT_SEGMENT15
,      PLA_ITEM_CAT_SEGMENT16
,      PLA_ITEM_CAT_SEGMENT17
,      PLA_ITEM_CAT_SEGMENT18
,      PLA_ITEM_CAT_SEGMENT19
,      PLA_ITEM_CAT_SEGMENT20
,      PLA_BRIDGING_ACCOUNT
,      PLA_EXPENSE_ACCOUNT
,      PLA_MATERIAL_ACCOUNT
,      PLA_MATERIAL_OVERHEAD_ACCOUNT
,      PLA_OUTSIDE_PROCESSING_ACCOUNT
,      PLA_OVERHEAD_ACCOUNT
,      PLA_RESOURCE_ACCOUNT
,      PLA_SUBINV_CG
,      PLA_ACV_ACCOUNT
,      PLA_ENCUMBRANCE_ACCOUNT
,      PLA_ANALYTICAL_IPV_ACCT
,      PLA_ANALYTICAL_PO_MIRROR_ACCT
,      PLA_NON_INVOICED_SO_ACCT
,      PLA_NON_INVOICED_REV_ACCT
,      PLA_ANALYTICAL_REV_MIRROR_ACCT
,      PLA_ANALYTICAL_MOGS_ACCT
FROM APPS.CST_XLA_PLA_CATEGORY_REF_V;

Dependencies

[top of page]

APPS.CST_XLA_PLA_CATEGORY_REF_V references the following:

SchemaAPPS
SynonymMTL_CATEGORIES
SynonymMTL_CATEGORY_ACCOUNTS
SynonymMTL_DEFAULT_CATEGORY_SETS
SynonymMTL_ITEM_CATEGORIES
SynonymMTL_PARAMETERS
APPS.CST_XLA_PLA_CATEGORY_REF_V is referenced by following:

SchemaAPPS
Package BodyXLA_00707_AAD_S_000019_PKG - show dependent code
Package BodyXLA_00707_AAD_S_000020_PKG - show dependent code