accasey

code --list-extensions | xargs -L 1 echo code --install-extensions

accasey

WITH MY_VIEW AS (
                SELECT FIELDNAME,LABEL18,ROWNUM AS ROWNUMBER
                FROM (
                    SELECT A.FIELDNAME,A.LABEL18
                    FROM PS_FS_SD_RECFLD A
                    ,PS_FS_SD_GRPFLD B
                    WHERE B.SD_GRP_NAME = 'VNDR_AUTH'
                    AND A.SD_RECNAME = 'VNDR_AUTH'
                    AND B.SD_RECNAME = A.SD_RECNAME
                    AND B.SD_FLDNAME = A.SD_FLDNAME

accasey

# If you use the IB connector param SSLProtocols , then this will appear in the info. section of IB msglog.html file.
# For the web server, you can add these parameters to the 'JAVA_OPIONS_os' parameter in setEnv.sh/cmd and then check the logs.
# -Dssl.debug=true -Dweblogic.StdoutDebugEnabled=true -Dweblogic.security.SSL.verbose=true -Djavax.net.debug=all

#Here is an example:
SET JAVA_OPTIONS_WIN=-jrockit -XnoOpt -XXnoJITInline -Xms512m -Xmx512m -Dtoplink.xml.platform=oracle.toplink.platform.xml.jaxp.JAXPPlatform -Dssl.debug=true -Dweblogic.StdoutDebugEnabled=true -Dweblogic.security.SSL.verbose=true -Djavax.net.debug=all 

accasey

SELECT B.PTCS_SERVICEID
,C.PORTAL_OBJNAME
,C.PORTAL_URI_SEG1 AS MENUNAME
,C.PORTAL_URI_SEG2 AS PNLGRPNAME
,C.PORTAL_URI_SEG3 AS MARKET
,B.PTCS_INSTANCELBL
,NVL((SELECT X.XLATLONGNAME
      FROM PSXLATITEM X
      WHERE X.FIELDNAME = 'PTCS_ISCOMPSERVICE'
      AND X.FIELDVALUE = B.PTCS_ISCOMPSERVICE

accasey

WHENEVER SQLERROR EXIT SQL.SQLCODE;
WHENEVER OSERROR EXIT;

accasey

SELECT DISTINCT Y.MENUNAME
,Y.COMPONENTNAME
,Y.MARKET
,Y.PORTAL_LABEL AS LABEL
,Y.PORTAL_OBJNAME
,Y.PORTAL_PRNTOBJNAME
,Y.PORTAL_CNTPRV_NAM
,Y.VERSION
,Y.PORTAL_URL_CHKSUM
,TO_CHAR(E.PORTAL_NAVPATH) AS PATHNAME

accasey

WITH MY_TILE_NAV_COLL AS 
(
   /* This query provides the list of all tiles (CREF objects, CREF paths) and their
      corresponding nav collection CREF object. */
   SELECT A.PTPPB_GROUPLET_ID AS TILE_NAME
   ,A.DESCR AS TILE_DESCRIPTION
   ,A.PTPPB_ORIG_DISP_ID AS TILE_CREF_OBJECT
   ,'Root > Fluid Structure and Content > Fluid Pages > ' || D.PORTAL_LABEL AS TILE_PATH
   ,C.PTPPB_VALUE AS NAV_COLL_CREF_OBJECT
   FROM PS_PTPPB_GROUPLET A

accasey

UPDATE PSVERSION SET VERSION = VERSION + 1 WHERE OBJECTTYPENAME IN ('UPM','SYS')
/
UPDATE PSLOCK SET VERSION = VERSION + 1 WHERE OBJECTTYPENAME = 'UPM'
/
DELETE FROM PSROLEUSER WHERE ROLEUSER = :1 AND ROLENAME LIKE '%%'
/
UPDATE PSOPRDEFN SET VERSION = (SELECT VERSION 
                                FROM PSVERSION 
                                WHERE OBJECTTYPENAME = 'UPM'
                               )

accasey

UPDATE PSLOCK SET VERSION = VERSION + 1 WHERE OBJECTTYPENAME = 'QDM'
/
UPDATE PSVERSION SET VERSION = VERSION + 1 WHERE OBJECTTYPENAME IN ('QDM','SYS')
/
UPDATE PSQRYDEFN SET VERSION = (SELECT VERSION FROM PSLOCK WHERE OBJECTTYPENAME = 'QDM')
WHERE OPRID = :1
AND QRYNAME = :2
/
COMMIT
/

accasey

javascript:lpSwipeToTabFromDD(%27ERP.EMPLOYEE.MY_DEVELOPER_HOME%27);