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_FIELDS

Line 186: NOUPDATE_FLAG CZ_XFR_FIELDS.NOUPDATE%TYPE;

182: inXFR_GROUP IN VARCHAR2)
183: RETURN NUMBER IS
184: BEGIN
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

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:

Line 193: AND CZ_XFR_FIELDS.XFR_GROUP=inXFR_GROUP AND ROWNUM=1;

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:
197: EXCEPTION