DBA Data[Home] [Help]

VIEW: APPS.BIS_PROCESS_MFG_WAREHOUSES_V

Source

View Text - Preformatted

SELECT whse_code ID , whse_name Value , Orgn_code Orgn_code , Whse_code Whse_code , Whse_name Whse_name , TO_NUMBER(NULL) FROM ic_whse_mst WHERE pmi_security_pkg.show_record( orgn_code) = 'TRUE'
View Text - HTML Formatted

SELECT WHSE_CODE ID
, WHSE_NAME VALUE
, ORGN_CODE ORGN_CODE
, WHSE_CODE WHSE_CODE
, WHSE_NAME WHSE_NAME
, TO_NUMBER(NULL)
FROM IC_WHSE_MST
WHERE PMI_SECURITY_PKG.SHOW_RECORD( ORGN_CODE) = 'TRUE'