VIEW: APPS.GMD_CUST_VEND_MST_V1

Source

View Text - Preformatted

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

View Text - HTML Formatted

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