eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ICX_CAT_STORE_CONTENTS_V

Source

View Text - Preformatted


SELECT STORECONTENT.STORE_ID AS STORE_ID, STORECONTENT.CONTENT_ID AS CONTENT_ID, STORECONTENT.SEQUENCE AS SEQUENCE, STORECONTENT.DISPLAY_ALWAYS_FLAG AS DISPLAY_ALWAYS_FLAG, STORECONTENT.CONTENT_TYPE AS TYPE FROM POR_NONCAT_TEMPLATES_ALL_B TEMPLATES,ICX_CAT_STORE_CONTENTS STORECONTENT WHERE STORECONTENT.CONTENT_TYPE = 'SMART_FORM' AND STORECONTENT.CONTENT_ID = TEMPLATES.TEMPLATE_ID AND (TEMPLATES.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID() OR TEMPLATES.ORG_ID = -2) UNION ALL SELECT STORECONTENT.STORE_ID AS STORE_ID, STORECONTENT.CONTENT_ID AS CONTENT_ID , STORECONTENT.SEQUENCE AS SEQUENCE, STORECONTENT.DISPLAY_ALWAYS_FLAG AS DISPLAY_ALWAYS_FLAG, ZONES.TYPE AS TYPE FROM ICX_CAT_STORE_CONTENTS STORECONTENT, ICX_CAT_CONTENT_ZONES_B ZONES WHERE STORECONTENT.CONTENT_TYPE = 'CONTENT_ZONE' AND STORECONTENT.CONTENT_ID = ZONES.ZONE_ID AND ( ZONES.SECURITY_ASSIGNMENT_FLAG = 'ALL_USERS' OR (ZONES.SECURITY_ASSIGNMENT_FLAG = 'OU_SECURED' AND EXISTS ( SELECT 'Assigned to the OU' FROM ICX_CAT_SECURE_CONTENTS OUAssignments WHERE OUAssignments.SECURE_BY = 'OPERATING_UNIT' AND STORECONTENT.CONTENT_ID = OUAssignments.CONTENT_ID AND OUAssignments.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID())) OR (ZONES.SECURITY_ASSIGNMENT_FLAG = 'RESP_SECURED' AND EXISTS ( SELECT 'Assigned to the Responsibility' FROM ICX_CAT_SECURE_CONTENTS RespAssignments WHERE RespAssignments.SECURE_BY = 'RESPONSIBILITY' AND STORECONTENT.CONTENT_ID = RespAssignments.CONTENT_ID AND RespAssignments.RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID)))

View Text - HTML Formatted

SELECT STORECONTENT.STORE_ID AS STORE_ID
, STORECONTENT.CONTENT_ID AS CONTENT_ID
, STORECONTENT.SEQUENCE AS SEQUENCE
, STORECONTENT.DISPLAY_ALWAYS_FLAG AS DISPLAY_ALWAYS_FLAG
, STORECONTENT.CONTENT_TYPE AS TYPE
FROM POR_NONCAT_TEMPLATES_ALL_B TEMPLATES
, ICX_CAT_STORE_CONTENTS STORECONTENT
WHERE STORECONTENT.CONTENT_TYPE = 'SMART_FORM'
AND STORECONTENT.CONTENT_ID = TEMPLATES.TEMPLATE_ID
AND (TEMPLATES.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID() OR TEMPLATES.ORG_ID = -2) UNION ALL SELECT STORECONTENT.STORE_ID AS STORE_ID
, STORECONTENT.CONTENT_ID AS CONTENT_ID
, STORECONTENT.SEQUENCE AS SEQUENCE
, STORECONTENT.DISPLAY_ALWAYS_FLAG AS DISPLAY_ALWAYS_FLAG
, ZONES.TYPE AS TYPE
FROM ICX_CAT_STORE_CONTENTS STORECONTENT
, ICX_CAT_CONTENT_ZONES_B ZONES
WHERE STORECONTENT.CONTENT_TYPE = 'CONTENT_ZONE'
AND STORECONTENT.CONTENT_ID = ZONES.ZONE_ID
AND ( ZONES.SECURITY_ASSIGNMENT_FLAG = 'ALL_USERS' OR (ZONES.SECURITY_ASSIGNMENT_FLAG = 'OU_SECURED'
AND EXISTS ( SELECT 'ASSIGNED TO THE OU'
FROM ICX_CAT_SECURE_CONTENTS OUASSIGNMENTS
WHERE OUASSIGNMENTS.SECURE_BY = 'OPERATING_UNIT'
AND STORECONTENT.CONTENT_ID = OUASSIGNMENTS.CONTENT_ID
AND OUASSIGNMENTS.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID())) OR (ZONES.SECURITY_ASSIGNMENT_FLAG = 'RESP_SECURED'
AND EXISTS ( SELECT 'ASSIGNED TO THE RESPONSIBILITY'
FROM ICX_CAT_SECURE_CONTENTS RESPASSIGNMENTS
WHERE RESPASSIGNMENTS.SECURE_BY = 'RESPONSIBILITY'
AND STORECONTENT.CONTENT_ID = RESPASSIGNMENTS.CONTENT_ID
AND RESPASSIGNMENTS.RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID)))