DBA Data[Home] [Help] [Dependency Information]

VIEW: GMP.PS_MATL_DTL#

Object Details
Object Name: PS_MATL_DTL#
Object Type: VIEW
Owner: GMP
Subobject Name:
Status: VALID

[View Source]

Columns
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

Query Text

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#;

Dependencies

[top of page]

GMP.PS_MATL_DTL# references the following:

SchemaGMP
TablePS_MATL_DTL
GMP.PS_MATL_DTL# is referenced by following:

SchemaAPPS
SynonymPS_MATL_DTL