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

TABLE: ASL.ASL_INVENTORY_PRICING

Object Details
Object Name: ASL_INVENTORY_PRICING
Object Type: TABLE
Owner: ASL
Subobject Name:
Status: VALID


ASL_INVENTORY_PRICING table contains all the price list header and price list line details pertaining to the given Inventory Organization id, category set and category id.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ASL_INVENTORY_PRICING_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnORGANIZATION_ID
ColumnINVENTORY_ITEM_ID
ColumnCURRENCY_CODE
ColumnLAST_UPDATE_DATE
Columns
Name Datatype Length Mandatory Comments
LIST_HEADER_ID NUMBER (15) Yes List Header Id
LIST_LINE_ID NUMBER (15) Yes List Header Id
LIST_LINE_TYPE_CODE VARCHAR2 (30) Yes List Line Type Code
INVENTORY_ITEM_ID NUMBER (15) Yes Inv Item Id
ORGANIZATION_ID NUMBER (15) Yes Org Id
AUTOMATIC_FLAG VARCHAR2 (1) Yes Automatic flag
LIST_PRICE NUMBER

List Price
LIST_PRICE_UOM_CODE VARCHAR2 (240)
List price uom code
PRIMARY_UOM_FLAG VARCHAR2 (1)
Primary uom flag
LIST_LINE_NO VARCHAR2 (30)
List line no
LAST_UPDATE_DATE DATE
Yes Last Update date
CREATION_DATE DATE
Yes Creation Date
LANGUAGE_CODE VARCHAR2 (4) Yes Language Code
CURRENCY_CODE VARCHAR2 (4) Yes Currency Code
Query Text

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


SELECT LIST_HEADER_ID
,      LIST_LINE_ID
,      LIST_LINE_TYPE_CODE
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      AUTOMATIC_FLAG
,      LIST_PRICE
,      LIST_PRICE_UOM_CODE
,      PRIMARY_UOM_FLAG
,      LIST_LINE_NO
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      LANGUAGE_CODE
,      CURRENCY_CODE
FROM ASL.ASL_INVENTORY_PRICING;

Dependencies

[top of page]

ASL.ASL_INVENTORY_PRICING does not reference any database object

ASL.ASL_INVENTORY_PRICING is referenced by following:

SchemaASL
ViewASL_INVENTORY_PRICING#