View: GMI_AAC_CUST_NUM_V

Product:	GMI - Process Manufacturing Inventory
Description:	View Of Process Customers By Name and Number Including the Ship to site information, company and whse.
Implementation/DBA Data:	APPS.GMI_AAC_CUST_NUM_V

View Text

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

Columns