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.GCS_LEX_MAP_API_PKG dependencies on GCS_LEX_MAP_COLUMNS

Line 416: gcs_lex_map_columns mc

412: col_name
413: FROM gcs_lex_map_rule_sets rst,
414: gcs_lex_map_rule_stages rstg,
415: gcs_lex_map_rules r,
416: gcs_lex_map_columns mc
417: WHERE rst.rule_set_id = rstg.rule_set_id
418: AND rstg.rule_stage_id = r.rule_stage_id
419: AND r.target_column_id = mc.column_id
420: AND r.rule_id = add_deriv_proc_failed_msg.rule_id;

Line 472: gcs_lex_map_columns mc

468: FROM gcs_lex_map_rule_sets rst,
469: gcs_lex_map_rule_stages rstg,
470: gcs_lex_map_rules r,
471: gcs_lex_map_derivations d,
472: gcs_lex_map_columns mc
473: WHERE rst.rule_set_id = rstg.rule_set_id
474: AND rstg.rule_stage_id = r.rule_stage_id
475: AND r.rule_id = d.rule_id
476: AND r.target_column_id = mc.column_id

Line 530: gcs_lex_map_columns mc

526: FROM gcs_lex_map_rule_sets rst,
527: gcs_lex_map_rule_stages rstg,
528: gcs_lex_map_rules r,
529: gcs_lex_map_derivations d,
530: gcs_lex_map_columns mc
531: WHERE rst.rule_set_id = rstg.rule_set_id
532: AND rstg.rule_stage_id = r.rule_stage_id
533: AND r.rule_id = d.rule_id
534: AND r.target_column_id = mc.column_id

Line 582: gcs_lex_map_columns mc

578: col_name
579: FROM gcs_lex_map_rule_sets rst,
580: gcs_lex_map_rule_stages rstg,
581: gcs_lex_map_rules r,
582: gcs_lex_map_columns mc
583: WHERE rst.rule_set_id = rstg.rule_set_id
584: AND rstg.rule_stage_id = r.rule_stage_id
585: AND r.target_column_id = mc.column_id
586: AND r.rule_id = add_rule_failed_msg.rule_id;

Line 818: gcs_lex_map_columns mc,

814: vs_name
815: FROM gcs_lex_map_rule_sets rst,
816: gcs_lex_map_rule_stages rstg,
817: gcs_lex_map_rules r,
818: gcs_lex_map_columns mc,
819: fnd_flex_value_sets ffvs
820: WHERE rst.rule_set_id = rstg.rule_set_id
821: AND rstg.rule_stage_id = r.rule_stage_id
822: AND r.target_column_id = mc.column_id

Line 873: gcs_lex_map_columns mc,

869: lut_name
870: FROM gcs_lex_map_rule_sets rst,
871: gcs_lex_map_rule_stages rstg,
872: gcs_lex_map_rules r,
873: gcs_lex_map_columns mc,
874: gcs_lex_map_structs lutms
875: WHERE rst.rule_set_id = rstg.rule_set_id
876: AND rstg.rule_stage_id = r.rule_stage_id
877: AND r.target_column_id = mc.column_id

Line 933: gcs_lex_map_columns mc,

929: FROM gcs_lex_map_rule_sets rst,
930: gcs_lex_map_rule_stages rstg,
931: gcs_lex_map_rules r,
932: gcs_lex_map_derivations d,
933: gcs_lex_map_columns mc,
934: gcs_lex_map_columns lutmc,
935: gcs_lex_map_structs lutms
936: WHERE rst.rule_set_id = rstg.rule_set_id
937: AND rstg.rule_stage_id = r.rule_stage_id

Line 934: gcs_lex_map_columns lutmc,

930: gcs_lex_map_rule_stages rstg,
931: gcs_lex_map_rules r,
932: gcs_lex_map_derivations d,
933: gcs_lex_map_columns mc,
934: gcs_lex_map_columns lutmc,
935: gcs_lex_map_structs lutms
936: WHERE rst.rule_set_id = rstg.rule_set_id
937: AND rstg.rule_stage_id = r.rule_stage_id
938: AND r.rule_id = d.rule_id

Line 1117: gcs_lex_map_columns mc

1113: BEGIN
1114: SELECT mc.column_name
1115: INTO error_code_col_name
1116: FROM gcs_lex_map_rule_sets rst,
1117: gcs_lex_map_columns mc
1118: WHERE rst.structure_id = mc.structure_id
1119: AND mc.error_code_column_flag = 'Y'
1120: AND rst.rule_set_id = add_error_code_failed_msg.rule_set_id;
1121:

Line 1203: gcs_lex_map_columns mc

1199:
1200: CURSOR error_column_check IS
1201: SELECT mc.column_name, mc.write_flag
1202: FROM gcs_lex_map_rule_sets rst,
1203: gcs_lex_map_columns mc
1204: WHERE rst.structure_id = mc.structure_id
1205: AND mc.error_code_column_flag = 'Y'
1206: AND rst.rule_set_id = initial_rule_set_check.rule_set_id;
1207:

Line 1392: FROM gcs_lex_map_columns mc,

1388: Rule_Set_Id NUMBER)
1389: IS
1390: CURSOR all_columns IS
1391: SELECT mc.column_name
1392: FROM gcs_lex_map_columns mc,
1393: gcs_lex_map_rule_sets rst
1394: WHERE rst.structure_id = mc.structure_id
1395: AND rst.rule_set_id = staging_table_check.rule_set_id;
1396:

Line 1483: gcs_lex_map_columns mc

1479: SELECT decode( usage,
1480: 'TRANSFORMATION', write_flag,
1481: error_code_column_flag)
1482: FROM gcs_lex_map_rule_sets rst,
1483: gcs_lex_map_columns mc
1484: WHERE mc.structure_id = rst.structure_id
1485: AND rst.rule_set_id = get_filter_text.rule_set_id
1486: AND UPPER(mc.column_name) = UPPER(col_name);
1487:

Line 1596: FROM gcs_lex_map_columns mc,

1592: File_Write VARCHAR2)
1593: IS
1594: CURSOR all_columns IS
1595: SELECT mc.column_name
1596: FROM gcs_lex_map_columns mc,
1597: gcs_lex_map_rules r
1598: WHERE r.lookup_table_id = mc.structure_id
1599: AND r.rule_id = validation_check.rule_id;
1600:

Line 1772: FROM gcs_lex_map_columns mc,

1768: decode(mc.column_type_code, 'N', 'NUMBER',
1769: 'D', 'DATE',
1770: 'V', 'VARCHAR2',
1771: '') column_type_code
1772: FROM gcs_lex_map_columns mc,
1773: gcs_lex_map_rules r
1774: WHERE mc.column_id = r.target_column_id
1775: AND r.rule_id = create_param_list.rule_id)
1776: UNION

Line 1782: FROM gcs_lex_map_columns mc,

1778: decode(mc.column_type_code, 'N', 'NUMBER',
1779: 'D', 'DATE',
1780: 'V', 'VARCHAR2',
1781: '') column_type_code
1782: FROM gcs_lex_map_columns mc,
1783: gcs_lex_map_drv_details dvd,
1784: gcs_lex_map_derivations d
1785: WHERE d.rule_id = create_param_list.rule_id
1786: AND dvd.derivation_id = d.derivation_id

Line 1794: FROM gcs_lex_map_columns mc,

1790: decode(mc.column_type_code, 'N', 'NUMBER',
1791: 'D', 'DATE',
1792: 'V', 'VARCHAR2',
1793: '') column_type_code
1794: FROM gcs_lex_map_columns mc,
1795: gcs_lex_map_conditions c,
1796: gcs_lex_map_derivations d
1797: WHERE d.rule_id = create_param_list.rule_id
1798: AND c.derivation_id = d.derivation_id

Line 1873: FROM gcs_lex_map_columns mc,

1869: decode(c.comparison_value,
1870: '', '',
1871: ' ''' || REPLACE(c.comparison_value, '''', '''''') || '''')
1872: simple_cond
1873: FROM gcs_lex_map_columns mc,
1874: gcs_lex_map_conditions c
1875: WHERE c.derivation_id = create_condition.derivation_id
1876: AND c.source_column_id = mc.column_id;
1877:

Line 1929: gcs_lex_map_columns lutmc,

1925: SELECT lutmc.column_name lut_col_name,
1926: stgmc.column_name stg_col_name,
1927: dvd.detail_constant detail_constant
1928: FROM gcs_lex_map_drv_details dvd,
1929: gcs_lex_map_columns lutmc,
1930: gcs_lex_map_columns stgmc
1931: WHERE dvd.derivation_id = create_lookup_derivation.derivation_id
1932: AND dvd.lookup_column_id = lutmc.column_id
1933: AND dvd.detail_column_id = stgmc.column_id (+);

Line 1930: gcs_lex_map_columns stgmc

1926: stgmc.column_name stg_col_name,
1927: dvd.detail_constant detail_constant
1928: FROM gcs_lex_map_drv_details dvd,
1929: gcs_lex_map_columns lutmc,
1930: gcs_lex_map_columns stgmc
1931: WHERE dvd.derivation_id = create_lookup_derivation.derivation_id
1932: AND dvd.lookup_column_id = lutmc.column_id
1933: AND dvd.detail_column_id = stgmc.column_id (+);
1934:

Line 1952: gcs_lex_map_columns mc,

1948: mc.column_name
1949: INTO lookup_table_name,
1950: result_col_name
1951: FROM gcs_lex_map_derivations d,
1952: gcs_lex_map_columns mc,
1953: gcs_lex_map_structs ms
1954: WHERE d.lookup_result_column_id = mc.column_id
1955: AND mc.structure_id = ms.structure_id
1956: AND d.derivation_id = create_lookup_derivation.derivation_id;

Line 2030: gcs_lex_map_columns mc

2026: REPLACE(dvd.detail_constant, '''', '''''') ||
2027: '''',
2028: '') string_action
2029: FROM gcs_lex_map_drv_details dvd,
2030: gcs_lex_map_columns mc
2031: WHERE dvd.derivation_id = create_string_derivation.derivation_id
2032: AND dvd.detail_column_id = mc.column_id (+)
2033: ORDER BY dvd.string_merge_order;
2034:

Line 2093: gcs_lex_map_columns mc

2089: 'S',''''||REPLACE(dvd.detail_constant, '''', '''''')||'''',
2090: 'N',dvd.detail_constant,
2091: '') plsql_parameter
2092: FROM gcs_lex_map_drv_details dvd,
2093: gcs_lex_map_columns mc
2094: WHERE dvd.derivation_id = create_plsql_derivation.derivation_id
2095: AND dvd.detail_column_id = mc.column_id (+);
2096:
2097: -- Don't add a ',' to the beginning for the first parameter passed in

Line 2333: gcs_lex_map_columns mc

2329:
2330: SELECT mc.column_name, mc.column_type_code, mc.write_flag
2331: INTO target_col_name, target_column_type, target_write_flag
2332: FROM gcs_lex_map_rules r,
2333: gcs_lex_map_columns mc
2334: WHERE r.target_column_id = mc.column_id
2335: AND r.rule_id = create_get_function.rule_id;
2336:
2337: IF target_write_flag <> 'Y' THEN

Line 2662: gcs_lex_map_columns tgtmc,

2658: r.validation_type_code validation_type_code,
2659: lutms.structure_name lookup_table_name,
2660: r.value_set_id value_set_id
2661: FROM gcs_lex_map_rules r,
2662: gcs_lex_map_columns tgtmc,
2663: gcs_lex_map_structs lutms
2664: WHERE r.rule_stage_id = validate_results.rule_stage_id
2665: AND r.target_column_id = tgtmc.column_id
2666: AND r.lookup_table_id = lutms.structure_id (+)

Line 2737: gcs_lex_map_columns mc

2733: SELECT r.rule_id rule_id,
2734: mc.column_name column_name,
2735: mc.write_flag write_flag
2736: FROM gcs_lex_map_rules r,
2737: gcs_lex_map_columns mc
2738: WHERE r.rule_stage_id = apply_stage.rule_stage_id
2739: AND r.target_column_id = mc.column_id;
2740:
2741: CURSOR check_func_c(c_func_name VARCHAR2) IS

Line 2888: FROM gcs_lex_map_columns mc,

2884: END IF;
2885:
2886: SELECT mc.column_name
2887: INTO error_col_name
2888: FROM gcs_lex_map_columns mc,
2889: gcs_lex_map_rule_sets rsts
2890: WHERE mc.structure_id = rsts.structure_id
2891: AND rsts.rule_set_id = init_error_column.rule_set_id
2892: AND mc.error_code_column_flag = 'Y';

Line 2941: FROM gcs_lex_map_columns mc,

2937: init_error_column(rule_set_id, staging_table_name, filter_text);
2938:
2939: SELECT mc.column_name
2940: INTO error_col
2941: FROM gcs_lex_map_columns mc,
2942: gcs_lex_map_rule_sets rsts
2943: WHERE mc.structure_id = rsts.structure_id
2944: AND mc.error_code_column_flag = 'Y'
2945: AND rsts.rule_set_id = fill_error_column.rule_set_id;

Line 3440: gcs_lex_map_columns mc,

3436: INTO col_name,
3437: stage_num,
3438: vs_name
3439: FROM gcs_lex_map_rules r,
3440: gcs_lex_map_columns mc,
3441: gcs_lex_map_rule_stages rstg,
3442: fnd_flex_value_sets ffv
3443: WHERE r.rule_stage_id = rstg.rule_stage_id
3444: AND r.value_set_id = ffv.flex_value_set_id

Line 3461: gcs_lex_map_columns mc,

3457: INTO col_name,
3458: stage_num,
3459: lut_name
3460: FROM gcs_lex_map_rules r,
3461: gcs_lex_map_columns mc,
3462: gcs_lex_map_rule_stages rstg,
3463: gcs_lex_map_structs lutms
3464: WHERE r.rule_stage_id = rstg.rule_stage_id
3465: AND r.lookup_table_id = lutms.structure_id

Line 3535: gcs_lex_map_columns mc

3531: INTO col_name,
3532: stage_num
3533: FROM gcs_lex_map_rules r,
3534: gcs_lex_map_rule_stages rstg,
3535: gcs_lex_map_columns mc
3536: WHERE r.rule_stage_id = rstg.rule_stage_id
3537: AND r.target_column_id = mc.column_id
3538: AND r.rule_id = error_table(i).rule_id;
3539:

Line 3833: gcs_lex_map_columns mc

3829: -- Now get the error column name and add to the filter text
3830: SELECT mc.column_name
3831: INTO error_col_name
3832: FROM gcs_lex_map_rule_sets rs,
3833: gcs_lex_map_columns mc
3834: WHERE rs.rule_set_id = p_rule_set_id
3835: AND mc.structure_id = rs.structure_id
3836: AND mc.error_code_column_flag = 'Y';
3837: