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.JTY_TAE_CONTROL_PVT dependencies on JTY_DEA_VALUES_IDX_DETAILS

Line 1190: INSERT INTO jty_dea_values_idx_details (

1186: END IF; /* end IF l_exist_qual_detail_count = 0 */
1187:
1188: IF (l_no_of_records = 0) THEN
1189: IF (q_detail.comparison_operator IS NOT NULL) THEN
1190: INSERT INTO jty_dea_values_idx_details (
1191: dea_values_idx_details_id
1192: ,dea_values_idx_header_id
1193: ,last_update_date
1194: ,last_updated_by

Line 1202: jty_dea_values_idx_details_s.nextval

1198: ,values_col_map
1199: ,input_selectivity
1200: ,input_ordinal_selectivity )
1201: VALUES (
1202: jty_dea_values_idx_details_s.nextval
1203: ,l_header_seq
1204: ,G_SYSDATE
1205: ,G_USER_ID
1206: ,G_SYSDATE

Line 1215: INSERT INTO jty_dea_values_idx_details (

1211: ,null);
1212: END IF;
1213:
1214: IF (q_detail.low_value_char_id IS NOT NULL) THEN
1215: INSERT INTO jty_dea_values_idx_details (
1216: dea_values_idx_details_id
1217: ,dea_values_idx_header_id
1218: ,last_update_date
1219: ,last_updated_by

Line 1227: jty_dea_values_idx_details_s.nextval

1223: ,values_col_map
1224: ,input_selectivity
1225: ,input_ordinal_selectivity )
1226: VALUES (
1227: jty_dea_values_idx_details_s.nextval
1228: ,l_header_seq
1229: ,G_SYSDATE
1230: ,G_USER_ID
1231: ,G_SYSDATE

Line 1240: INSERT INTO jty_dea_values_idx_details (

1236: ,null);
1237: END IF;
1238:
1239: IF (q_detail.low_value_char IS NOT NULL) THEN
1240: INSERT INTO jty_dea_values_idx_details (
1241: dea_values_idx_details_id
1242: ,dea_values_idx_header_id
1243: ,last_update_date
1244: ,last_updated_by

Line 1252: jty_dea_values_idx_details_s.nextval

1248: ,values_col_map
1249: ,input_selectivity
1250: ,input_ordinal_selectivity )
1251: VALUES (
1252: jty_dea_values_idx_details_s.nextval
1253: ,l_header_seq
1254: ,G_SYSDATE
1255: ,G_USER_ID
1256: ,G_SYSDATE

Line 1265: INSERT INTO jty_dea_values_idx_details (

1261: ,null);
1262: END IF;
1263:
1264: IF (q_detail.high_value_char IS NOT NULL) THEN
1265: INSERT INTO jty_dea_values_idx_details (
1266: dea_values_idx_details_id
1267: ,dea_values_idx_header_id
1268: ,last_update_date
1269: ,last_updated_by

Line 1277: jty_dea_values_idx_details_s.nextval

1273: ,values_col_map
1274: ,input_selectivity
1275: ,input_ordinal_selectivity )
1276: VALUES (
1277: jty_dea_values_idx_details_s.nextval
1278: ,l_header_seq
1279: ,G_SYSDATE
1280: ,G_USER_ID
1281: ,G_SYSDATE

Line 1290: INSERT INTO jty_dea_values_idx_details (

1286: ,null);
1287: END IF;
1288:
1289: IF (q_detail.low_value_number IS NOT NULL) THEN
1290: INSERT INTO jty_dea_values_idx_details (
1291: dea_values_idx_details_id
1292: ,dea_values_idx_header_id
1293: ,last_update_date
1294: ,last_updated_by

Line 1302: jty_dea_values_idx_details_s.nextval

1298: ,values_col_map
1299: ,input_selectivity
1300: ,input_ordinal_selectivity )
1301: VALUES (
1302: jty_dea_values_idx_details_s.nextval
1303: ,l_header_seq
1304: ,G_SYSDATE
1305: ,G_USER_ID
1306: ,G_SYSDATE

Line 1315: INSERT INTO jty_dea_values_idx_details (

1311: ,null);
1312: END IF;
1313:
1314: IF (q_detail.high_value_number IS NOT NULL) THEN
1315: INSERT INTO jty_dea_values_idx_details (
1316: dea_values_idx_details_id
1317: ,dea_values_idx_header_id
1318: ,last_update_date
1319: ,last_updated_by

Line 1327: jty_dea_values_idx_details_s.nextval

1323: ,values_col_map
1324: ,input_selectivity
1325: ,input_ordinal_selectivity )
1326: VALUES (
1327: jty_dea_values_idx_details_s.nextval
1328: ,l_header_seq
1329: ,G_SYSDATE
1330: ,G_USER_ID
1331: ,G_SYSDATE

Line 1340: INSERT INTO jty_dea_values_idx_details (

1336: ,null);
1337: END IF;
1338:
1339: IF (q_detail.interest_type_id IS NOT NULL) THEN
1340: INSERT INTO jty_dea_values_idx_details (
1341: dea_values_idx_details_id
1342: ,dea_values_idx_header_id
1343: ,last_update_date
1344: ,last_updated_by

Line 1352: jty_dea_values_idx_details_s.nextval

1348: ,values_col_map
1349: ,input_selectivity
1350: ,input_ordinal_selectivity )
1351: VALUES (
1352: jty_dea_values_idx_details_s.nextval
1353: ,l_header_seq
1354: ,G_SYSDATE
1355: ,G_USER_ID
1356: ,G_SYSDATE

Line 1365: INSERT INTO jty_dea_values_idx_details (

1361: ,null);
1362: END IF;
1363:
1364: IF (q_detail.primary_interest_code_id IS NOT NULL) THEN
1365: INSERT INTO jty_dea_values_idx_details (
1366: dea_values_idx_details_id
1367: ,dea_values_idx_header_id
1368: ,last_update_date
1369: ,last_updated_by

Line 1377: jty_dea_values_idx_details_s.nextval

1373: ,values_col_map
1374: ,input_selectivity
1375: ,input_ordinal_selectivity )
1376: VALUES (
1377: jty_dea_values_idx_details_s.nextval
1378: ,l_header_seq
1379: ,G_SYSDATE
1380: ,G_USER_ID
1381: ,G_SYSDATE

Line 1390: INSERT INTO jty_dea_values_idx_details (

1386: ,null);
1387: END IF;
1388:
1389: IF (q_detail.secondary_interest_code_id IS NOT NULL) THEN
1390: INSERT INTO jty_dea_values_idx_details (
1391: dea_values_idx_details_id
1392: ,dea_values_idx_header_id
1393: ,last_update_date
1394: ,last_updated_by

Line 1402: jty_dea_values_idx_details_s.nextval

1398: ,values_col_map
1399: ,input_selectivity
1400: ,input_ordinal_selectivity )
1401: VALUES (
1402: jty_dea_values_idx_details_s.nextval
1403: ,l_header_seq
1404: ,G_SYSDATE
1405: ,G_USER_ID
1406: ,G_SYSDATE

Line 1415: INSERT INTO jty_dea_values_idx_details (

1411: ,null);
1412: END IF;
1413:
1414: IF (q_detail.currency_code IS NOT NULL) THEN
1415: INSERT INTO jty_dea_values_idx_details (
1416: dea_values_idx_details_id
1417: ,dea_values_idx_header_id
1418: ,last_update_date
1419: ,last_updated_by

Line 1427: jty_dea_values_idx_details_s.nextval

1423: ,values_col_map
1424: ,input_selectivity
1425: ,input_ordinal_selectivity )
1426: VALUES (
1427: jty_dea_values_idx_details_s.nextval
1428: ,l_header_seq
1429: ,G_SYSDATE
1430: ,G_USER_ID
1431: ,G_SYSDATE

Line 1440: INSERT INTO jty_dea_values_idx_details (

1436: ,null);
1437: END IF;
1438:
1439: IF (q_detail.value1_id IS NOT NULL) THEN
1440: INSERT INTO jty_dea_values_idx_details (
1441: dea_values_idx_details_id
1442: ,dea_values_idx_header_id
1443: ,last_update_date
1444: ,last_updated_by

Line 1452: jty_dea_values_idx_details_s.nextval

1448: ,values_col_map
1449: ,input_selectivity
1450: ,input_ordinal_selectivity )
1451: VALUES (
1452: jty_dea_values_idx_details_s.nextval
1453: ,l_header_seq
1454: ,G_SYSDATE
1455: ,G_USER_ID
1456: ,G_SYSDATE

Line 1465: INSERT INTO jty_dea_values_idx_details (

1461: ,null);
1462: END IF;
1463:
1464: IF (q_detail.value2_id IS NOT NULL) THEN
1465: INSERT INTO jty_dea_values_idx_details (
1466: dea_values_idx_details_id
1467: ,dea_values_idx_header_id
1468: ,last_update_date
1469: ,last_updated_by

Line 1477: jty_dea_values_idx_details_s.nextval

1473: ,values_col_map
1474: ,input_selectivity
1475: ,input_ordinal_selectivity )
1476: VALUES (
1477: jty_dea_values_idx_details_s.nextval
1478: ,l_header_seq
1479: ,G_SYSDATE
1480: ,G_USER_ID
1481: ,G_SYSDATE

Line 1490: INSERT INTO jty_dea_values_idx_details (

1486: ,null);
1487: END IF;
1488:
1489: IF (q_detail.value3_id IS NOT NULL) THEN
1490: INSERT INTO jty_dea_values_idx_details (
1491: dea_values_idx_details_id
1492: ,dea_values_idx_header_id
1493: ,last_update_date
1494: ,last_updated_by

Line 1502: jty_dea_values_idx_details_s.nextval

1498: ,values_col_map
1499: ,input_selectivity
1500: ,input_ordinal_selectivity )
1501: VALUES (
1502: jty_dea_values_idx_details_s.nextval
1503: ,l_header_seq
1504: ,G_SYSDATE
1505: ,G_USER_ID
1506: ,G_SYSDATE

Line 1515: INSERT INTO jty_dea_values_idx_details (

1511: ,null);
1512: END IF;
1513:
1514: IF (q_detail.value4_id IS NOT NULL) THEN
1515: INSERT INTO jty_dea_values_idx_details (
1516: dea_values_idx_details_id
1517: ,dea_values_idx_header_id
1518: ,last_update_date
1519: ,last_updated_by

Line 1527: jty_dea_values_idx_details_s.nextval

1523: ,values_col_map
1524: ,input_selectivity
1525: ,input_ordinal_selectivity )
1526: VALUES (
1527: jty_dea_values_idx_details_s.nextval
1528: ,l_header_seq
1529: ,G_SYSDATE
1530: ,G_USER_ID
1531: ,G_SYSDATE

Line 1540: INSERT INTO jty_dea_values_idx_details (

1536: ,null);
1537: END IF;
1538:
1539: IF (q_detail.first_char IS NOT NULL) THEN
1540: INSERT INTO jty_dea_values_idx_details (
1541: dea_values_idx_details_id
1542: ,dea_values_idx_header_id
1543: ,last_update_date
1544: ,last_updated_by

Line 1552: jty_dea_values_idx_details_s.nextval

1548: ,values_col_map
1549: ,input_selectivity
1550: ,input_ordinal_selectivity )
1551: VALUES (
1552: jty_dea_values_idx_details_s.nextval
1553: ,l_header_seq
1554: ,G_SYSDATE
1555: ,G_USER_ID
1556: ,G_SYSDATE

Line 1685: jty_dea_values_idx_details B

1681:
1682: CURSOR all_sets(cl_source_id number) is
1683: SELECT A.dea_values_idx_header_id, count(*) num_components
1684: FROM jty_dea_values_idx_header A,
1685: jty_dea_values_idx_details B
1686: WHERE A.source_id = cl_source_id
1687: AND A.dea_values_idx_header_id = B.dea_values_idx_header_id
1688: AND B.values_col_map is not null
1689: GROUP BY A.dea_values_idx_header_id

Line 1698: jty_dea_values_idx_details B

1694: , cl_dea_values_idx_header_id IN NUMBER) is
1695: SELECT * FROM (
1696: SELECT A.dea_values_idx_header_id, count(*) num_components
1697: FROM jty_dea_values_idx_header A,
1698: jty_dea_values_idx_details B
1699: WHERE A.source_id = cl_source_id
1700: AND A.dea_values_idx_header_id <> cl_dea_values_idx_header_id
1701: AND A.dea_values_idx_header_id = B.dea_values_idx_header_id
1702: AND B.values_col_map is not null

Line 1741: FROM jty_dea_values_idx_details B

1737: FROM (
1738: SELECT rownum row_count, values_col_map, input_selectivity
1739: FROM (
1740: SELECT B.values_col_map, B.input_selectivity
1741: FROM jty_dea_values_idx_details B
1742: WHERE B.dea_values_idx_header_id = cl_set_S.dea_values_idx_header_id
1743: AND B.values_col_map IS NOT NULL
1744: ORDER BY B.input_selectivity )) S,
1745: (

Line 1749: FROM jty_dea_values_idx_details B

1745: (
1746: SELECT rownum row_count, values_col_map, input_selectivity
1747: FROM (
1748: SELECT B.values_col_map, B.input_selectivity
1749: FROM jty_dea_values_idx_details B
1750: WHERE B.dea_values_idx_header_id = cl_set_L.dea_values_idx_header_id
1751: AND B.values_col_map IS NOT NULL
1752: ORDER BY B.input_selectivity )) L
1753: WHERE S.values_col_map = L.values_col_map