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.HZ_PARTY_STAGE dependencies on DUAL

Line 1227: from DUAL;

1223: 'PARTY_SITES','HZ_STAGED_PARTIES',
1224: 'CONTACTS','HZ_STAGED_CONTACTS',
1225: 'CONTACT_POINTS','HZ_STAGED_CONTACT_POINTS','DUMMY')
1226: INTO l_table_name
1227: from DUAL;
1228:
1229: -- See if the intermedia index on the corresponding staging table for the entity
1230: -- has the placeholders for these sections.
1231: -- The check that is done here is to see if the dummy string CHECK exists with in the section

Line 2538: SELECT SYSDATE INTO l_startdate FROM DUAL;

2534: FND_MSG_PUB.initialize;
2535: HZ_TRANS_PKG.set_staging_context('Y');
2536: IF p_command='STAGE_ALL_DATA' THEN
2537:
2538: SELECT SYSDATE INTO l_startdate FROM DUAL;
2539:
2540: log('Staging Organization Party Records');
2541:
2542: OPEN l_log_cur(p_command, l_worker_number, 'STEP1');

Line 4418: FROM DUAL;

4414:
4415: BEGIN
4416:
4417: SELECT SYS_CONTEXT ('USERENV', 'SESSION_USER') INTO uname
4418: FROM DUAL;
4419:
4420: get_datastore_cols('PARTY', pref_cols, proc_cols, fetch_cols);
4421:
4422: l(' FUNCTION miscp (rid IN ROWID) RETURN CLOB IS');

Line 5316: l(' FROM dual ) T ');

5312: l(' MERGE INTO hz_dqm_sh_sync_interface S ');
5313: l(' USING ( ');
5314: l(' SELECT ');
5315: l(' H_P_PARTY_ID(I) AS party_id ');
5316: l(' FROM dual ) T ');
5317: l(' ON (S.entity = ''PARTY'' AND ');
5318: l(' S.party_id = T.party_id AND ');
5319: l(' S.staged_flag <> ''E'') ');
5320: l(' WHEN NOT MATCHED THEN ');

Line 6725: l(' FROM dual ) T ');

6721: l(' SELECT ');
6722: l(' H_PS_PARTY_ID(I) AS party_id ');
6723: l(' ,H_PARTY_SITE_ID(I) AS record_id ');
6724: l(' ,H_PS_ORG_CONTACT_ID(I) AS org_contact_id ');
6725: l(' FROM dual ) T ');
6726: l(' ON (S.entity = ''PARTY_SITES'' AND ');
6727: l(' S.party_id = T.party_id AND ');
6728: l(' S.record_id = T.record_id AND ');
6729: l(' NVL(S.org_contact_id, -99) = NVL(T.org_contact_id, -99) AND ');

Line 8033: l(' FROM dual ) T ');

8029: l(' USING ( ');
8030: l(' SELECT ');
8031: l(' H_C_PARTY_ID(I) AS party_id ');
8032: l(' ,H_ORG_CONTACT_ID(I) AS record_id ');
8033: l(' FROM dual ) T ');
8034: l(' ON (S.entity = ''CONTACTS'' AND ');
8035: l(' S.party_id = T.party_id AND ');
8036: l(' S.record_id = T.record_id AND ');
8037: l(' S.staged_flag <> ''E'') ');

Line 8393: l(' FROM DUAL WHERE H_R_PARTY_ID(I) IS NOT NULL;');

8389: l(' END LOOP; ');
8390: l(' FORALL I in H_C_PARTY_ID.FIRST..H_C_PARTY_ID.LAST ');
8391: l(' INSERT INTO HZ_DQM_STAGE_GT(PARTY_ID,OWNER_ID,ORG_CONTACT_ID,PARTY_INDEX) ');
8392: l(' SELECT H_C_PARTY_ID(I), H_R_PARTY_ID(I), H_ORG_CONTACT_ID(I), H_PARTY_INDEX(I)');
8393: l(' FROM DUAL WHERE H_R_PARTY_ID(I) IS NOT NULL;');
8394: l(' IF l_last_fetch THEN');
8395: l(' EXIT;');
8396: l(' END IF;');
8397: l(' END LOOP;');

Line 9308: l(' FROM dual ) T ');

9304: l(' H_CPT_PARTY_ID(I) AS party_id ');
9305: l(' ,H_CONTACT_POINT_ID(I) AS record_id ');
9306: l(' ,H_CPT_PARTY_SITE_ID(I) AS party_site_id ');
9307: l(' ,H_CPT_ORG_CONTACT_ID(I) AS org_contact_id ');
9308: l(' FROM dual ) T ');
9309: l(' ON (S.entity = ''CONTACT_POINTS'' AND ');
9310: l(' S.party_id = T.party_id AND ');
9311: l(' S.record_id = T.record_id AND ');
9312: l(' NVL(S.party_site_id, -99) = NVL(T.party_site_id, -99) AND ');

Line 11399: '(:attrval,:lang,:attr,:entity,:ctx) from dual';

11395:
11396: BEGIN
11397: c := dbms_sql.open_cursor;
11398: l_sql := 'select ' || proc ||
11399: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
11400: dbms_sql.parse(c,l_sql,2);
11401: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
11402: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
11403: DBMS_SQL.BIND_VARIABLE(c,':attr','x');

Line 11428: '(:record_id,:entity,:attr,:ctx) from dual';

11424:
11425: BEGIN
11426: c := dbms_sql.open_cursor;
11427: l_sql := 'select ' || proc ||
11428: '(:record_id,:entity,:attr,:ctx) from dual';
11429: dbms_sql.parse(c,l_sql,2);
11430: DBMS_SQL.BIND_VARIABLE(c,':record_id','x');
11431: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11432: DBMS_SQL.BIND_VARIABLE(c,':attr','x');

Line 11467: '(:attrval,:lang,:attr,:entity) from dual';

11463: l_procedure := FUNCS.PROCEDURE_NAME;
11464: l_trans_name := FUNCS.TRANSFORMATION_NAME;
11465: c := dbms_sql.open_cursor;
11466: l_sql := 'select ' || FUNCS.PROCEDURE_NAME ||
11467: '(:attrval,:lang,:attr,:entity) from dual';
11468: dbms_sql.parse(c,l_sql,2);
11469: dbms_sql.close_cursor(c);
11470: EXCEPTION WHEN OTHERS THEN
11471: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');

Line 11494: '(:record_id,:entity,:attr) from dual';

11490: l_attribute := FUNCS.ATTRIBUTE_NAME;
11491: l_procedure := FUNCS.custom_attribute_procedure;
11492: c := dbms_sql.open_cursor;
11493: l_sql := 'select ' || FUNCS.custom_attribute_procedure ||
11494: '(:record_id,:entity,:attr) from dual';
11495: dbms_sql.parse(c,l_sql,2);
11496: dbms_sql.close_cursor(c);
11497: EXCEPTION WHEN OTHERS THEN
11498: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR1');