[Home] [Help]
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
Name |
CUST_VEND_NO |
CO_CODE |
REPORT_TYPE |