Search Results po_line_locations_all




Here's a detailed description of the PO_LINE_LOCATIONS_ALL table in Oracle E-Business Suite (EBS):

Table Name: PO_LINE_LOCATIONS_ALL

Purpose:
- Stores detailed information about line locations for purchase order (PO) lines
- Represents specific delivery details, quantities, and scheduling information for purchase order lines

Key Columns:
1. LINE_LOCATION_ID (Primary Key)
- Unique identifier for each line location record
- Used to link specific delivery details to PO lines

2. PO_LINE_ID
- Foreign key linking to PO_LINES_ALL table
- Identifies the specific purchase order line associated with this location

3. QUANTITY
- Total quantity of items for this specific line location
- Represents the number of items to be delivered

4. QUANTITY_RECEIVED
- Tracks the quantity of items already received
- Used for tracking procurement progress

5. QUANTITY_CANCELLED
- Tracks the quantity of items cancelled for this line location

6. DELIVER_TO_LOCATION_ID
- Identifies the specific delivery destination
- Links to HR_LOCATIONS table

7. PROMISED_DATE
- Expected date of delivery from the supplier

8. NEED_BY_DATE
- Date by which the items are required

9. EXPECTED_RECEIPT_DATE
- Projected date for receiving the items

10. CLOSED_CODE
- Indicates the status of the line location (open, closed, etc.)

11. SHIP_TO_ORGANIZATION_ID
- Identifies the inventory organization receiving the items

12. ACCRUE_ON_RECEIPT_FLAG
- Determines whether costs are accrued when items are received

13. CONSIGNED_FLAG
- Indicates if the items are consigned inventory

14. CREATED_BY
- User who created the record

15. CREATION_DATE
- Date and time the record was created

16. LAST_UPDATED_BY
- User who last modified the record

17. LAST_UPDATE_DATE
- Date and time of the last modification

Relationships:
- Links to PO_LINES_ALL via PO_LINE_ID
- Links to HR_LOCATIONS via DELIVER_TO_LOCATION_ID
- Links to HR_ORGANIZATION_UNITS via SHIP_TO_ORGANIZATION_ID

Typical Usage:
- Tracking purchase order delivery details
- Managing procurement schedules
- Monitoring item receipt status
- Supporting inventory management processes

Performance Considerations:
- Indexed on LINE_LOCATION_ID, PO_LINE_ID
- Large volume of records in high-transaction environments
- Crucial for procurement and inventory management reporting

Important Notes:
- Part of Oracle Purchasing module
- Used extensively in procure-to-pay processes
- Contains critical information for tracking purchase order fulfillment

This comprehensive description provides insights into the structure and significance of the PO_LINE_LOCATIONS_ALL table in Oracle EBS.