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

Line 813: FROM dual;

809: IF l_Addl_Country_Name IS NOT NULL THEN
810: l_rec_count := 2;
811: SELECT wsh_itm_request_set_s.NEXTVAL
812: INTO l_request_set_id
813: FROM dual;
814: IF l_debug_level > 0 THEN
815: oe_debug_pub.add('Addl country name:'||l_addl_country_name);
816: END IF;
817: ELSE

Line 827: FROM dual;

823: FOR I in 1..l_rec_count LOOP
824:
825: SELECT wsh_itm_request_control_s.NEXTVAL
826: INTO l_request_control_id
827: FROM dual;
828:
829:
830: -- Retrieve the Header Information
831:

Line 1121: FROM dual;

1117: IF Address_table(J).add_source_orgid IS NOT NULL THEN
1118:
1119: SELECT wsh_itm_parties_s.NEXTVAL
1120: INTO l_party_id
1121: FROM dual;
1122:
1123: INSERT INTO WSH_ITM_PARTIES (
1124: PARTY_ID,
1125: REQUEST_CONTROL_ID,

Line 1376: -- individual Line.

1372: mo_global.set_policy_context('S',l_org_id);
1373:
1374: -- This select statement is used to lock the Top Model Line.
1375: -- After the Top Model Line is Locked we go ahead the Lock the
1376: -- individual Line.
1377:
1378: SELECT top_model_line_id
1379: INTO l_top_model_line_id
1380: FROM oe_order_lines