VIEW: APPS.BIS_PROCESS_MFG_COMPANIES_V

Source

View Text - Preformatted

SELECT co_code ID , orgn_name Value , co_code co_code , orgn_name orgn_name , to_NUMBER(NULL) FROM sy_orgn_mst WHERE orgn_code = co_code and pmi_security_pkg.show_record(orgn_code,1) = 'TRUE'

View Text - HTML Formatted

SELECT CO_CODE ID
, ORGN_NAME VALUE
, CO_CODE CO_CODE
, ORGN_NAME ORGN_NAME
, TO_NUMBER(NULL)
FROM SY_ORGN_MST
WHERE ORGN_CODE = CO_CODE
AND PMI_SECURITY_PKG.SHOW_RECORD(ORGN_CODE
, 1) = 'TRUE'