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 1239: from DUAL;

1235: 'PARTY_SITES','HZ_STAGED_PARTIES',
1236: 'CONTACTS','HZ_STAGED_CONTACTS',
1237: 'CONTACT_POINTS','HZ_STAGED_CONTACT_POINTS','DUMMY')
1238: INTO l_table_name
1239: from DUAL;
1240:
1241: -- See if the intermedia index on the corresponding staging table for the entity
1242: -- has the placeholders for these sections.
1243: -- The check that is done here is to see if the dummy string CHECK exists with in the section

Line 2569: SELECT SYSDATE INTO l_startdate FROM DUAL;

2565: FND_MSG_PUB.initialize;
2566: HZ_TRANS_PKG.set_staging_context('Y');
2567: IF p_command='STAGE_ALL_DATA' THEN
2568:
2569: SELECT SYSDATE INTO l_startdate FROM DUAL;
2570:
2571: log('Staging Organization Party Records');
2572:
2573: OPEN l_log_cur(p_command, l_worker_number, 'STEP1');

Line 4546: FROM DUAL;

4542:
4543: BEGIN
4544:
4545: SELECT SYS_CONTEXT ('USERENV', 'SESSION_USER') INTO uname
4546: FROM DUAL;
4547:
4548: get_datastore_cols('PARTY', pref_cols, proc_cols, fetch_cols);
4549:
4550: l(' FUNCTION miscp (rid IN ROWID) RETURN CLOB IS');

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

5464: l(' MERGE INTO hz_dqm_sh_sync_interface S ');
5465: l(' USING ( ');
5466: l(' SELECT ');
5467: l(' H_P_PARTY_ID(I) AS party_id ');
5468: l(' FROM dual ) T ');
5469: l(' ON (S.entity = ''PARTY'' AND ');
5470: l(' S.party_id = T.party_id AND ');
5471: l(' S.staged_flag <> ''E'') ');
5472: l(' WHEN NOT MATCHED THEN ');

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

6875: l(' SELECT ');
6876: l(' H_PS_PARTY_ID(I) AS party_id ');
6877: l(' ,H_PARTY_SITE_ID(I) AS record_id ');
6878: l(' ,H_PS_ORG_CONTACT_ID(I) AS org_contact_id ');
6879: l(' FROM dual ) T ');
6880: l(' ON (S.entity = ''PARTY_SITES'' AND ');
6881: l(' S.party_id = T.party_id AND ');
6882: l(' S.record_id = T.record_id AND ');
6883: l(' NVL(S.org_contact_id, -99) = NVL(T.org_contact_id, -99) AND ');

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

8183: l(' USING ( ');
8184: l(' SELECT ');
8185: l(' H_C_PARTY_ID(I) AS party_id ');
8186: l(' ,H_ORG_CONTACT_ID(I) AS record_id ');
8187: l(' FROM dual ) T ');
8188: l(' ON (S.entity = ''CONTACTS'' AND ');
8189: l(' S.party_id = T.party_id AND ');
8190: l(' S.record_id = T.record_id AND ');
8191: l(' S.staged_flag <> ''E'') ');

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

8543: l(' END LOOP; ');
8544: l(' FORALL I in H_C_PARTY_ID.FIRST..H_C_PARTY_ID.LAST ');
8545: l(' INSERT INTO HZ_DQM_STAGE_GT(PARTY_ID,OWNER_ID,ORG_CONTACT_ID,PARTY_INDEX) ');
8546: l(' SELECT H_C_PARTY_ID(I), H_R_PARTY_ID(I), H_ORG_CONTACT_ID(I), H_PARTY_INDEX(I)');
8547: l(' FROM DUAL WHERE H_R_PARTY_ID(I) IS NOT NULL;');
8548: l(' IF l_last_fetch THEN');
8549: l(' EXIT;');
8550: l(' END IF;');
8551: l(' END LOOP;');

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

9458: l(' H_CPT_PARTY_ID(I) AS party_id ');
9459: l(' ,H_CONTACT_POINT_ID(I) AS record_id ');
9460: l(' ,H_CPT_PARTY_SITE_ID(I) AS party_site_id ');
9461: l(' ,H_CPT_ORG_CONTACT_ID(I) AS org_contact_id ');
9462: l(' FROM dual ) T ');
9463: l(' ON (S.entity = ''CONTACT_POINTS'' AND ');
9464: l(' S.party_id = T.party_id AND ');
9465: l(' S.record_id = T.record_id AND ');
9466: l(' NVL(S.party_site_id, -99) = NVL(T.party_site_id, -99) AND ');

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

11549:
11550: BEGIN
11551: c := dbms_sql.open_cursor;
11552: l_sql := 'select ' || proc ||
11553: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
11554: dbms_sql.parse(c,l_sql,2);
11555: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
11556: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
11557: DBMS_SQL.BIND_VARIABLE(c,':attr','x');

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

11578:
11579: BEGIN
11580: c := dbms_sql.open_cursor;
11581: l_sql := 'select ' || proc ||
11582: '(:record_id,:entity,:attr,:ctx) from dual';
11583: dbms_sql.parse(c,l_sql,2);
11584: DBMS_SQL.BIND_VARIABLE(c,':record_id','x');
11585: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
11586: DBMS_SQL.BIND_VARIABLE(c,':attr','x');

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

11617: l_procedure := FUNCS.PROCEDURE_NAME;
11618: l_trans_name := FUNCS.TRANSFORMATION_NAME;
11619: c := dbms_sql.open_cursor;
11620: l_sql := 'select ' || FUNCS.PROCEDURE_NAME ||
11621: '(:attrval,:lang,:attr,:entity) from dual';
11622: dbms_sql.parse(c,l_sql,2);
11623: dbms_sql.close_cursor(c);
11624: EXCEPTION WHEN OTHERS THEN
11625: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');

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

11644: l_attribute := FUNCS.ATTRIBUTE_NAME;
11645: l_procedure := FUNCS.custom_attribute_procedure;
11646: c := dbms_sql.open_cursor;
11647: l_sql := 'select ' || FUNCS.custom_attribute_procedure ||
11648: '(:record_id,:entity,:attr) from dual';
11649: dbms_sql.parse(c,l_sql,2);
11650: dbms_sql.close_cursor(c);
11651: EXCEPTION WHEN OTHERS THEN
11652: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR1');