[Home] [Help] [Dependency Information]
Object Name: | PS_MATL_DTL# |
---|---|
Object Type: | VIEW |
Owner: | GMP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MATL_REP_ID | NUMBER | (10) | Yes | |
ITEM_ID | NUMBER | (10) | ||
PLANNING_CLASS | VARCHAR2 | (8) | ||
WHSE_CODE | VARCHAR2 | (4) | ||
QTY_ON_HAND | NUMBER | |||
PERD_NAME | VARCHAR2 | (20) | ||
PERD_END_DATE | DATE | Yes | ||
SALES_ORDERS | NUMBER | |||
FORE_CAST | NUMBER | |||
SCHED_INGRED | NUMBER | |||
FIRM_INGRED | NUMBER | |||
PLND_INGRED | NUMBER | |||
TOTAL_DEMAND | NUMBER | |||
PO_RECEIPTS | NUMBER | |||
REQ_RECEIPTS | NUMBER | |||
SCHED_PROD | NUMBER | |||
FIRM_PROD | NUMBER | |||
PLND_PROD | NUMBER | |||
ENDING_BAL | NUMBER | |||
NET_SS_REQMT | NUMBER | |||
PLND_TRANSFER_OUT | NUMBER | |||
PLND_TRANSFER_IN | NUMBER | |||
PLANNING_CATEGORY_ID | NUMBER | |||
SCHED_TRANSFER_IN | NUMBER | |||
SCHED_TRANSFER_OUT | NUMBER | |||
PREQ_SUPPLY | NUMBER | |||
PRCV_SUPPLY | NUMBER | |||
SHMT_SUPPLY | NUMBER | |||
PLND_PURCHASE | NUMBER | |||
OTHER_DEMAND | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER |
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#;
|
|
|