DBA Data[Home] [Help]

VIEW: GMP.MR_UBKT_DTL#

Source

View Text - Preformatted

select MATL_REP_ID MATL_REP_ID, ITEM_ID ITEM_ID, DOC_TYPE DOC_TYPE, ORGN_CODE ORGN_CODE, DOC_ID DOC_ID, DOC_NO DOC_NO, PLANNING_CLASS PLANNING_CLASS, WHSE_CODE WHSE_CODE, START_BALANCE START_BALANCE, PAST_DUE PAST_DUE, TRANS_DATE TRANS_DATE, TRANS_QTY TRANS_QTY, BALANCE BALANCE, CRITICAL_IND CRITICAL_IND, CUST_VEND CUST_VEND, PLANNING_CATEGORY_ID PLANNING_CATEGORY_ID from "GMP"."MR_UBKT_DTL"
View Text - HTML Formatted

SELECT MATL_REP_ID MATL_REP_ID
, ITEM_ID ITEM_ID
, DOC_TYPE DOC_TYPE
, ORGN_CODE ORGN_CODE
, DOC_ID DOC_ID
, DOC_NO DOC_NO
, PLANNING_CLASS PLANNING_CLASS
, WHSE_CODE WHSE_CODE
, START_BALANCE START_BALANCE
, PAST_DUE PAST_DUE
, TRANS_DATE TRANS_DATE
, TRANS_QTY TRANS_QTY
, BALANCE BALANCE
, CRITICAL_IND CRITICAL_IND
, CUST_VEND CUST_VEND
, PLANNING_CATEGORY_ID PLANNING_CATEGORY_ID
FROM "GMP"."MR_UBKT_DTL"