VIEW: GMP.PS_MATL_DTL#

Source

View Text - Preformatted

select MATL_REP_ID MATL_REP_ID, ITEM_ID ITEM_ID, PLANNING_CLASS PLANNING_CLASS, WHSE_CODE WHSE_CODE, QTY_ON_HAND QTY_ON_HAND, PERD_NAME PERD_NAME, PERD_END_DATE PERD_END_DATE, SALES_ORDERS SALES_ORDERS, FORE_CAST FORE_CAST, SCHED_INGRED SCHED_INGRED, FIRM_INGRED FIRM_INGRED, PLND_INGRED PLND_INGRED, TOTAL_DEMAND TOTAL_DEMAND, PO_RECEIPTS PO_RECEIPTS, REQ_RECEIPTS REQ_RECEIPTS, SCHED_PROD SCHED_PROD, FIRM_PROD FIRM_PROD, PLND_PROD PLND_PROD, ENDING_BAL ENDING_BAL, NET_SS_REQMT NET_SS_REQMT, PLND_TRANSFER_OUT PLND_TRANSFER_OUT, PLND_TRANSFER_IN PLND_TRANSFER_IN, PLANNING_CATEGORY_ID PLANNING_CATEGORY_ID, SCHED_TRANSFER_IN SCHED_TRANSFER_IN, SCHED_TRANSFER_OUT SCHED_TRANSFER_OUT, PREQ_SUPPLY PREQ_SUPPLY, PRCV_SUPPLY PRCV_SUPPLY, SHMT_SUPPLY SHMT_SUPPLY, PLND_PURCHASE PLND_PURCHASE, OTHER_DEMAND OTHER_DEMAND, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID from "GMP"."PS_MATL_DTL"

View Text - HTML Formatted

SELECT MATL_REP_ID MATL_REP_ID
, ITEM_ID ITEM_ID
, PLANNING_CLASS PLANNING_CLASS
, WHSE_CODE WHSE_CODE
, QTY_ON_HAND QTY_ON_HAND
, PERD_NAME PERD_NAME
, PERD_END_DATE PERD_END_DATE
, SALES_ORDERS SALES_ORDERS
, FORE_CAST FORE_CAST
, SCHED_INGRED SCHED_INGRED
, FIRM_INGRED FIRM_INGRED
, PLND_INGRED PLND_INGRED
, TOTAL_DEMAND TOTAL_DEMAND
, PO_RECEIPTS PO_RECEIPTS
, REQ_RECEIPTS REQ_RECEIPTS
, SCHED_PROD SCHED_PROD
, FIRM_PROD FIRM_PROD
, PLND_PROD PLND_PROD
, ENDING_BAL ENDING_BAL
, NET_SS_REQMT NET_SS_REQMT
, PLND_TRANSFER_OUT PLND_TRANSFER_OUT
, PLND_TRANSFER_IN PLND_TRANSFER_IN
, PLANNING_CATEGORY_ID PLANNING_CATEGORY_ID
, SCHED_TRANSFER_IN SCHED_TRANSFER_IN
, SCHED_TRANSFER_OUT SCHED_TRANSFER_OUT
, PREQ_SUPPLY PREQ_SUPPLY
, PRCV_SUPPLY PRCV_SUPPLY
, SHMT_SUPPLY SHMT_SUPPLY
, PLND_PURCHASE PLND_PURCHASE
, OTHER_DEMAND OTHER_DEMAND
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
FROM "GMP"."PS_MATL_DTL"