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.FTE_LTL_LOADER dependencies on FTE_LANE_RATE_CHARTS

Line 284: fte_lane_rate_charts lrc

280: SELECT distinct
281: lrc.list_header_id
282: FROM
283: fte_lanes l,
284: fte_lane_rate_charts lrc
285: WHERE
286: l.lane_id = lrc.lane_id AND
287: l.tariff_name = p_tariff_name AND
288: l.lane_type = 'LTL_' || p_tariff_name || '_' || p_load_number AND

Line 473: INSERT INTO fte_lane_rate_charts(lane_id,

469:
470: FTE_UTIL_PKG.Enter_Debug(l_module_name);
471:
472: FORALL i IN 1..LRC_LANE_ID.COUNT
473: INSERT INTO fte_lane_rate_charts(lane_id,
474: list_header_id,
475: start_date_active,
476: end_date_active,
477: created_by,

Line 663: fte_lane_rate_charts flrc,

659: hz_parties hzp,
660: qp_list_headers_tl qlht,
661: wsh_regions_tl oz,
662: wsh_regions_tl dz,
663: fte_lane_rate_charts flrc,
664: fte_prc_parameters prc
665: WHERE
666: l.tariff_name = p_tariff_name AND
667: l.lane_type = 'LTL_' || p_tariff_name || '_' || p_load_number AND

Line 684: fte_lane_rate_charts flrc,

680: SELECT DISTINCT
681: qlht.name rate_chart_name
682: FROM
683: fte_lanes l,
684: fte_lane_rate_charts flrc,
685: qp_list_headers_tl qlht
686: WHERE
687: l.tariff_name = p_tariff_name AND
688: l.lane_type = 'LTL_' || p_tariff_name || '_' || p_load_number AND

Line 992: FTE_LANE_RATE_CHARTS

988: END IF;
989:
990: FORALL i in 1..l_lane_ids.COUNT
991: UPDATE
992: FTE_LANE_RATE_CHARTS
993: SET
994: START_DATE_ACTIVE = l_effective_dates(i),
995: END_DATE_ACTIVE = l_expiry_dates(i),
996: last_updated_by = G_USER_ID,

Line 1001: from fte_lane_rate_charts

997: last_update_date = SYSDATE,
998: last_update_login = G_USER_ID
999: WHERE
1000: list_header_id = (select list_header_id
1001: from fte_lane_rate_charts
1002: where lane_id = l_lane_ids(i));
1003:
1004: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
1005: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Obsolete Lane Rate Charts');

Line 1019: FROM fte_lane_rate_charts

1015: last_update_date = SYSDATE,
1016: last_update_login = G_USER_ID
1017: WHERE
1018: LIST_HEADER_ID = (SELECT list_header_id
1019: FROM fte_lane_rate_charts
1020: WHERE lane_id = l_lane_ids(i));
1021:
1022: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1023: EXCEPTION

Line 1097: fte_lane_rate_charts lrc,

1093: FROM
1094: qp_list_headers_tl lh,
1095: qp_list_headers_b b,
1096: qp_qualifiers ql,
1097: fte_lane_rate_charts lrc,
1098: fte_lanes l
1099: WHERE
1100: l.tariff_name = p_tariff_name AND
1101: l.lane_type = 'LTL_' || p_tariff_name || '_' || p_load_number AND

Line 1482: FTE_LANE_RATE_CHARTS

1478:
1479: l_num_at := l_num_at + SQL%ROWCOUNT;
1480:
1481: DELETE FROM
1482: FTE_LANE_RATE_CHARTS
1483: WHERE
1484: list_header_id IN (SELECT list_header_id
1485: FROM qp_list_headers_tl
1486: WHERE name = l_chart_name);

Line 2087: -- FTE_LANE_RATE_CHARTS

2083: LN_COMM_FC_CLASS_CODE(ln_comm_fc_class_code.COUNT+1) := 'FC';
2084: LN_LANE_TYPE(ln_lane_type.COUNT+1) := p_lane_type;
2085: LN_TARIFF_NAME(ln_tariff_name.COUNT+1) := p_tariff_name;
2086:
2087: -- FTE_LANE_RATE_CHARTS
2088: LRC_LANE_ID(lrc_lane_id.COUNT+1) := l_lane_id;
2089: LRC_LIST_HEADER_ID(lrc_list_header_id.COUNT+1) := p_list_header_id;
2090: LRC_START_DATE(lrc_start_date.COUNT+1) := G_VALID_DATE;
2091: LRC_END_DATE(lrc_end_date.COUNT+1) := NULL;

Line 4646: fte_lane_rate_charts lrc,

4642: lrc.start_date_active,
4643: prc.value_from
4644: FROM
4645: fte_lanes l,
4646: fte_lane_rate_charts lrc,
4647: fte_prc_parameters prc
4648: WHERE
4649: l.tariff_name = p_tariff_name AND
4650: l.LANE_ID = lrc.LANE_ID AND

Line 4836: -- the dates passed into here should be from fte_lane_rate_charts --nii

4832: FETCH Get_Lane_Commodities
4833: BULK COLLECT INTO l_catg_ids;
4834: CLOSE Get_Lane_Commodities;
4835:
4836: -- the dates passed into here should be from fte_lane_rate_charts --nii
4837: Create_Lane_Data (p_origin_id => l_origin_ids(k),
4838: p_destination_id => l_destination_ids(k),
4839: p_carrier_ids => l_add_carriers,
4840: p_effective_dates => l_add_start_dates,

Line 4998: -- update fte_lane_rate_charts:

4994: action_code = 'M' AND
4995: carrier_id = l_modified_carriers(n);
4996:
4997: -- FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Update Lane Rate Charts');
4998: -- update fte_lane_rate_charts:
4999: -- FORALL n IN 1..l_modified_carriers.COUNT
5000: -- UPDATE fte_lane_rate_charts
5001: -- SET start_date_active = l_mod_start_dates(n),
5002: -- end_date_active = l_mod_end_dates(n),

Line 5000: -- UPDATE fte_lane_rate_charts

4996:
4997: -- FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Update Lane Rate Charts');
4998: -- update fte_lane_rate_charts:
4999: -- FORALL n IN 1..l_modified_carriers.COUNT
5000: -- UPDATE fte_lane_rate_charts
5001: -- SET start_date_active = l_mod_start_dates(n),
5002: -- end_date_active = l_mod_end_dates(n),
5003: -- last_update_date = sysdate
5004: -- WHERE lane_id IN