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.

APPS.CZ_UTILS dependencies on CZ_XFR_TABLES

Line 168: FROM CZ_XFR_TABLES WHERE DST_TABLE=TABLE_NAME AND XFR_GROUP=inXFR_GROUP

164: DECLARE
165: PK_USEEXPANSION_FLAG NUMBER;
166: BEGIN
167: SELECT DECODE(PK_USEEXPANSION,NULL,0,'0',0,1) INTO PK_USEEXPANSION_FLAG
168: FROM CZ_XFR_TABLES WHERE DST_TABLE=TABLE_NAME AND XFR_GROUP=inXFR_GROUP
169: AND ROWNUM=1;
170:
171: RETURN PK_USEEXPANSION_FLAG;
172: EXCEPTION

Line 189: FROM CZ_XFR_FIELDS,CZ_XFR_TABLES

185: DECLARE
186: NOUPDATE_FLAG CZ_XFR_FIELDS.NOUPDATE%TYPE;
187: BEGIN
188: SELECT NOUPDATE INTO NOUPDATE_FLAG
189: FROM CZ_XFR_FIELDS,CZ_XFR_TABLES
190: WHERE CZ_XFR_TABLES.DST_TABLE=TABLE_NAME AND CZ_XFR_FIELDS.DST_FIELD=COLUMN_NAME
191: AND CZ_XFR_TABLES.ORDER_SEQ=CZ_XFR_FIELDS.ORDER_SEQ
192: AND CZ_XFR_TABLES.XFR_GROUP=CZ_XFR_FIELDS.XFR_GROUP
193: AND CZ_XFR_FIELDS.XFR_GROUP=inXFR_GROUP AND ROWNUM=1;

Line 190: WHERE CZ_XFR_TABLES.DST_TABLE=TABLE_NAME AND CZ_XFR_FIELDS.DST_FIELD=COLUMN_NAME

186: NOUPDATE_FLAG CZ_XFR_FIELDS.NOUPDATE%TYPE;
187: BEGIN
188: SELECT NOUPDATE INTO NOUPDATE_FLAG
189: FROM CZ_XFR_FIELDS,CZ_XFR_TABLES
190: WHERE CZ_XFR_TABLES.DST_TABLE=TABLE_NAME AND CZ_XFR_FIELDS.DST_FIELD=COLUMN_NAME
191: AND CZ_XFR_TABLES.ORDER_SEQ=CZ_XFR_FIELDS.ORDER_SEQ
192: AND CZ_XFR_TABLES.XFR_GROUP=CZ_XFR_FIELDS.XFR_GROUP
193: AND CZ_XFR_FIELDS.XFR_GROUP=inXFR_GROUP AND ROWNUM=1;
194:

Line 191: AND CZ_XFR_TABLES.ORDER_SEQ=CZ_XFR_FIELDS.ORDER_SEQ

187: BEGIN
188: SELECT NOUPDATE INTO NOUPDATE_FLAG
189: FROM CZ_XFR_FIELDS,CZ_XFR_TABLES
190: WHERE CZ_XFR_TABLES.DST_TABLE=TABLE_NAME AND CZ_XFR_FIELDS.DST_FIELD=COLUMN_NAME
191: AND CZ_XFR_TABLES.ORDER_SEQ=CZ_XFR_FIELDS.ORDER_SEQ
192: AND CZ_XFR_TABLES.XFR_GROUP=CZ_XFR_FIELDS.XFR_GROUP
193: AND CZ_XFR_FIELDS.XFR_GROUP=inXFR_GROUP AND ROWNUM=1;
194:
195: RETURN TO_NUMBER(NVL(NOUPDATE_FLAG,'0'));

Line 192: AND CZ_XFR_TABLES.XFR_GROUP=CZ_XFR_FIELDS.XFR_GROUP

188: SELECT NOUPDATE INTO NOUPDATE_FLAG
189: FROM CZ_XFR_FIELDS,CZ_XFR_TABLES
190: WHERE CZ_XFR_TABLES.DST_TABLE=TABLE_NAME AND CZ_XFR_FIELDS.DST_FIELD=COLUMN_NAME
191: AND CZ_XFR_TABLES.ORDER_SEQ=CZ_XFR_FIELDS.ORDER_SEQ
192: AND CZ_XFR_TABLES.XFR_GROUP=CZ_XFR_FIELDS.XFR_GROUP
193: AND CZ_XFR_FIELDS.XFR_GROUP=inXFR_GROUP AND ROWNUM=1;
194:
195: RETURN TO_NUMBER(NVL(NOUPDATE_FLAG,'0'));
196: