DBA Data[Home] [Help]

VIEW: APPS.BIS_PROCESS_MFG_ORGS_V

Source

View Text - Preformatted

SELECT Orgn_code ID , orgn_name Value , co_code Co_code , Orgn_code Orgn_code , orgn_name orgn_name , Plant_Ind Plant_Ind , TO_NUMBER(NULL) FROM sy_orgn_mst WHERE pmi_security_pkg.show_record(orgn_code) = 'TRUE'
View Text - HTML Formatted

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