Search Results carrying value




Here's a detailed description of the TABLE CZ.CZ_ATP_REQUESTS:

TABLE NAME: CZ.CZ_ATP_REQUESTS

This table is typically used in Oracle E-Business Suite (EBS) for tracking Available to Promise (ATP) requests, which are critical for inventory and order management processes.

PROBABLE COLUMNS:
1. REQUEST_ID (Primary Key)
- Unique identifier for each ATP request
- Likely a NUMBER or VARCHAR2 datatype

2. ORGANIZATION_ID
- Identifies the specific inventory organization
- Typically a NUMBER referencing HR_ORGANIZATION_UNITS

3. INVENTORY_ITEM_ID
- Links to specific inventory item
- References MTL_SYSTEM_ITEMS table

4. QUANTITY_REQUESTED
- Total quantity requested in the ATP check
- NUMBER datatype

5. REQUEST_DATE
- Date when ATP request was created
- DATE datatype

6. STATUS
- Current status of ATP request
- Examples: PENDING, PROCESSED, FAILED
- VARCHAR2 datatype

7. REQUESTED_BY
- User who initiated the ATP request
- Links to FND_USER table

8. LAST_UPDATE_DATE
- Timestamp of last modification
- DATE datatype

TYPICAL USE CASES:
- Inventory availability checks
- Order promising
- Supply chain planning

RECOMMENDED INDEXES:
- Primary key on REQUEST_ID
- Composite index on (ORGANIZATION_ID, INVENTORY_ITEM_ID)

Note: Actual column composition may vary based on specific implementation.