VIEW: APPS.GMI_AAC_CUST_NUM_V

Source

View Text - Preformatted

SELECT C.CUST_NO ,C.CUST_NAME ,C.OF_SHIP_TO_SITE_USE_ID ,C.CO_CODE ,I.WHSE_CODE ,C.SHIP_IND FROM OP_CUST_MST C, IC_WHSE_MST I, SY_ORGN_MST S WHERE S.ORGN_CODE = i.ORGN_CODE AND S.CO_CODE = C.CO_CODE

View Text - HTML Formatted

SELECT C.CUST_NO
, C.CUST_NAME
, C.OF_SHIP_TO_SITE_USE_ID
, C.CO_CODE
, I.WHSE_CODE
, C.SHIP_IND
FROM OP_CUST_MST C
, IC_WHSE_MST I
, SY_ORGN_MST S
WHERE S.ORGN_CODE = I.ORGN_CODE
AND S.CO_CODE = C.CO_CODE