[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PS_MATL_DTL |
|---|---|
| Object Type: | TABLE |
| Owner: | GMP |
| FND Design Data: |  GMP.PS_MATL_DTL
|
| Subobject Name: | |
| Status: | VALID |
Temporary data about the report
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PS_MATL_DTL_PK | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 MATL_REP_ID
ITEM_ID
PERD_END_DATE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| MATL_REP_ID | NUMBER | (10) | Yes | Surrogate id for the report |
| ITEM_ID | NUMBER | (10) | Surrogate id of the item in the report | |
| PLANNING_CLASS | VARCHAR2 | (8) | Planning class of the item | |
| WHSE_CODE | VARCHAR2 | (4) | Warehouse in which the transaction occurs | |
| QTY_ON_HAND | NUMBER | Quantity of the item on hand as of now. | ||
| PERD_NAME | VARCHAR2 | (20) | Name of the period - depending of the buckets defined. | |
| PERD_END_DATE | DATE | Yes | End date of the period ( bucket ) | |
| SALES_ORDERS | NUMBER | Sum quantities of all sales orders in the period | ||
| FORE_CAST | NUMBER | Sum all forecasted quantities in the period | ||
| SCHED_INGRED | NUMBER | Quantities to be consumed in the scheduled batches as ingredient | ||
| FIRM_INGRED | NUMBER | Quantities to be consumed in the Firm Planned Orders as ingredient | ||
| PLND_INGRED | NUMBER | Quantities to be consumed in the Planned batches as ingredient | ||
| TOTAL_DEMAND | NUMBER | Total of all the demand quantities | ||
| PO_RECEIPTS | NUMBER | Quantity for the item to be received from the Purchase Order | ||
| REQ_RECEIPTS | NUMBER | Receipt quantity | ||
| SCHED_PROD | NUMBER | Quantity from the scheduled batches | ||
| FIRM_PROD | NUMBER | Quantity coming from the Firm Planned Orders | ||
| PLND_PROD | NUMBER | Quantity coming from the Planned Batches | ||
| ENDING_BAL | NUMBER | Net ending balance for that preiod EB=Starting qty + Total replenishment - Total demand | ||
| NET_SS_REQMT | NUMBER | Net Safety Stock requirement | ||
| PLND_TRANSFER_OUT | NUMBER | Schedule transfer quantity outgoing | ||
| PLND_TRANSFER_IN | NUMBER | Schedule transfer quantity incoming | ||
| PLANNING_CATEGORY_ID | NUMBER | Category Id for PLANNING_CLASS | ||
| SCHED_TRANSFER_IN | NUMBER | schedule transfer in | ||
| SCHED_TRANSFER_OUT | NUMBER | schedule transfer out | ||
| PREQ_SUPPLY | NUMBER | preq supply | ||
| PRCV_SUPPLY | NUMBER | prcv supply | ||
| SHMT_SUPPLY | NUMBER | MRP shortage suppoy | ||
| PLND_PURCHASE | NUMBER | Planned Purchase | ||
| OTHER_DEMAND | NUMBER | Stores demands not covered under the other specific columns - currently it stores the demand caused by expired lot | ||
| INVENTORY_ITEM_ID | NUMBER | Inventory Item ID | ||
| ORGANIZATION_ID | NUMBER | Organization ID |
Cut, paste (and edit) the following text to query this object:
SELECT MATL_REP_ID
, ITEM_ID
, PLANNING_CLASS
, WHSE_CODE
, QTY_ON_HAND
, PERD_NAME
, PERD_END_DATE
, SALES_ORDERS
, FORE_CAST
, SCHED_INGRED
, FIRM_INGRED
, PLND_INGRED
, TOTAL_DEMAND
, PO_RECEIPTS
, REQ_RECEIPTS
, SCHED_PROD
, FIRM_PROD
, PLND_PROD
, ENDING_BAL
, NET_SS_REQMT
, PLND_TRANSFER_OUT
, PLND_TRANSFER_IN
, PLANNING_CATEGORY_ID
, SCHED_TRANSFER_IN
, SCHED_TRANSFER_OUT
, PREQ_SUPPLY
, PRCV_SUPPLY
, SHMT_SUPPLY
, PLND_PURCHASE
, OTHER_DEMAND
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
FROM GMP.PS_MATL_DTL;
GMP.PS_MATL_DTL does not reference any database object
GMP.PS_MATL_DTL is referenced by following:
GMP
PS_MATL_DTL#
|
|
|
|