View: GMD_CUST_VEND_MST_V1

Product:	GMD - Process Manufacturing Product Development
Description:	Displays customer number and vendor number depednig on the report type selected by the user
Implementation/DBA Data:	APPS.GMD_CUST_VEND_MST_V1

View Text

SELECT CUST_NO "CUST_VEND_NO"
, CO_CODE
, '0' "REPORT_TYPE"
FROM OP_CUST_MST
WHERE DELETE_MARK = 0 UNION SELECT VENDOR_NO "CUST_VEND_NO"
, CO_CODE
, '1' "REPORT_TYPE"
FROM PO_VEND_MST
WHERE DELETE_MARK = 0

Columns