Search Results xxccsc918xx 2019 price




Here's a description of the ICX.ICX_POR_PRICE_LIST_LINES table in Oracle E-Business Suite (EBS):

Table Name: ICX_POR_PRICE_LIST_LINES
Schema: ICX (Internet Commerce Exchange)

Purpose:
This table typically stores price list line details for pricing and procurement processes in Oracle EBS, specifically related to internet commerce or purchasing price lists.

Key Columns:
1. PRICE_LIST_LINE_ID (Primary Key)
- Unique identifier for each price list line
- Usually a number or sequence

2. PRICE_LIST_HEADER_ID (Foreign Key)
- Links to the corresponding price list header
- Connects this line to its parent price list

3. INVENTORY_ITEM_ID
- Identifies the specific item or product
- Links to inventory items in MTL_SYSTEM_ITEMS table

4. UNIT_PRICE
- Actual price for the item
- Stores the pricing information

5. EFFECTIVE_FROM_DATE
- Start date when this price becomes valid

6. EFFECTIVE_TO_DATE
- End date when this price expires

7. CURRENCY_CODE
- Currency in which the price is defined

8. UOM_CODE
- Unit of measure for the pricing

Typical Use Cases:
- Maintain pricing information for procurement
- Track item-specific pricing
- Support price list management in purchasing

Note: Exact column details may vary based on specific Oracle EBS implementation and customizations.