APPS.ICX_ITEM_DIAG_PVT dependencies on ICX_CAT_CONTENT_ZONES_B

Line 503: ICX_CAT_CONTENT_ZONES_B zoneb,

499: select rownum,SQE_OWNER#,SQE_NAME,SQE_QUERY from ctxsys.dr$sqe
500: where SQE_NAME in (
501: SELECT UPPER(decode( fnd_profile.value('REQUISITION_TYPE'),'INTERNAL','icxzi','PURCHASE','icxzp','icxzb') || SQE_SEQUENCE)
502: FROM
503: ICX_CAT_CONTENT_ZONES_B zoneb,
504: ICX_CAT_STORE_CONTENTS_V contentv
505: WHERE
506: zoneb.ZONE_ID = contentv.CONTENT_ID AND
507: zoneb.TYPE ='LOCAL' );