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_RATE_CHART_PKG dependencies on QP_QUALIFIERS

Line 250: FROM qp_list_headers_tl l, qp_list_headers_b b, qp_qualifiers q

246: AND l.language = userenv('LANG');
247: ELSE
248: SELECT l.list_header_id, nvl(b.attribute1, 'FTE_RATE_CHART')
249: INTO l_list_header_id, l_attribute1
250: FROM qp_list_headers_tl l, qp_list_headers_b b, qp_qualifiers q
251: WHERE l.list_header_id = b.list_header_id
252: AND l.name = p_name
253: AND l.list_header_id = q.list_header_id
254: AND q.qualifier_context = 'PARTY'

Line 309: FROM qp_list_headers_b l, qp_qualifiers q, qp_list_headers_tl ltl

305: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.GET_RATE_CHART_INFO';
306:
307: CURSOR GET_CHART_INFO(p_name IN VARCHAR2, p_carrier_id IN NUMBER) IS
308: SELECT l.list_header_id, ltl.name, to_char(l.start_date_active,'YYYY-MM-DD'), to_char(l.end_date_active,'YYYY-MM-DD')
309: FROM qp_list_headers_b l, qp_qualifiers q, qp_list_headers_tl ltl
310: WHERE ltl.name = p_name
311: AND l.list_header_id=q.list_header_id
312: AND ltl.list_header_id = l.list_header_id
313: AND q.qualifier_context = 'PARTY'

Line 539: delete from qp_qualifiers

535: END IF;
536:
537: --Note: For TL Rate Charts and Modifiers, we keep all the qualifiers.
538: IF (p_action = 'UPDATE' AND g_chart_type IN ('FTE_MODIFIER') AND p_delete_qualifier) THEN
539: delete from qp_qualifiers
540: where list_header_id = l_list_header_id
541: and qualifier_context <> 'PARTY';
542:
543: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

Line 550: delete from qp_qualifiers

546: END IF;
547:
548: -- UPDATE doesn't delete from Headers and Qualifiers
549: IF (p_action = 'DELETE') THEN
550: delete from qp_qualifiers
551: where list_header_id = l_list_header_id;
552:
553: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
554: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Deleted ' || sql%rowcount || ' qualifiers.');

Line 1343: qp_qualifiers mod_qual

1339: CURSOR Get_Modifiers_With_Name IS
1340: SELECT modc.list_header_id
1341: FROM qp_list_headers_tl rc, qp_list_headers_b b,
1342: qp_list_headers_tl modc, qp_list_headers_b b2,
1343: qp_qualifiers mod_qual
1344: WHERE rc.list_header_id = b.list_header_id
1345: AND modc.list_header_id = b2.list_header_id
1346: AND mod_qual.qualifier_context = 'MODLIST'
1347: AND mod_qual.qualifier_attribute = 'QUALIFIER_ATTRIBUTE4'

Line 1359: qp_qualifiers mod_qual

1355: CURSOR Get_Modifiers_With_ID IS
1356: SELECT modc.list_header_id
1357: FROM qp_list_headers_tl rc, qp_list_headers_b b,
1358: qp_list_headers_tl modc, qp_list_headers_b b2,
1359: qp_qualifiers mod_qual
1360: WHERE rc.list_header_id = b.list_header_id
1361: AND modc.list_header_id = b2.list_header_id
1362: AND mod_qual.qualifier_context = 'MODLIST'
1363: AND mod_qual.qualifier_attribute = 'QUALIFIER_ATTRIBUTE4'

Line 1429: qp_qualifiers mod_qual

1425: CURSOR Get_Pricelists_With_Name IS
1426: SELECT rc.list_header_id
1427: FROM qp_list_headers_tl rc, qp_list_headers_b b,
1428: qp_list_headers_tl modc, qp_list_headers_b b2,
1429: qp_qualifiers mod_qual
1430: WHERE rc.list_header_id = b.list_header_id
1431: AND modc.list_header_id = b2.list_header_id
1432: AND mod_qual.qualifier_context = 'MODLIST'
1433: AND mod_qual.qualifier_attribute = 'QUALIFIER_ATTRIBUTE4'

Line 1445: qp_qualifiers mod_qual

1441: CURSOR Get_Pricelists_With_ID IS
1442: SELECT rc.list_header_id
1443: FROM qp_list_headers_tl rc, qp_list_headers_b b,
1444: qp_list_headers_tl modc, qp_list_headers_b b2,
1445: qp_qualifiers mod_qual
1446: WHERE rc.list_header_id = b.list_header_id
1447: AND modc.list_header_id = b2.list_header_id
1448: AND mod_qual.qualifier_context = 'MODLIST'
1449: AND mod_qual.qualifier_attribute = 'QUALIFIER_ATTRIBUTE4'

Line 1549: qp_qualifiers qc,

1545: CURSOR GET_MOD_PRICELIST(p_name IN VARCHAR2) IS
1546: SELECT to_char(b.list_header_id)
1547: FROM qp_list_headers_tl lh,
1548: qp_list_headers_b b,
1549: qp_qualifiers qc,
1550: qp_qualifiers qs,
1551: qp_qualifiers qm,
1552: qp_list_headers_tl modlh,
1553: qp_qualifiers modqs,

Line 1550: qp_qualifiers qs,

1546: SELECT to_char(b.list_header_id)
1547: FROM qp_list_headers_tl lh,
1548: qp_list_headers_b b,
1549: qp_qualifiers qc,
1550: qp_qualifiers qs,
1551: qp_qualifiers qm,
1552: qp_list_headers_tl modlh,
1553: qp_qualifiers modqs,
1554: qp_qualifiers modqc

Line 1551: qp_qualifiers qm,

1547: FROM qp_list_headers_tl lh,
1548: qp_list_headers_b b,
1549: qp_qualifiers qc,
1550: qp_qualifiers qs,
1551: qp_qualifiers qm,
1552: qp_list_headers_tl modlh,
1553: qp_qualifiers modqs,
1554: qp_qualifiers modqc
1555: WHERE modlh.name = p_name AND

Line 1553: qp_qualifiers modqs,

1549: qp_qualifiers qc,
1550: qp_qualifiers qs,
1551: qp_qualifiers qm,
1552: qp_list_headers_tl modlh,
1553: qp_qualifiers modqs,
1554: qp_qualifiers modqc
1555: WHERE modlh.name = p_name AND
1556: modlh.list_header_id = modqs.list_header_id AND
1557: modqc.list_header_id = modlh.list_header_id AND

Line 1554: qp_qualifiers modqc

1550: qp_qualifiers qs,
1551: qp_qualifiers qm,
1552: qp_list_headers_tl modlh,
1553: qp_qualifiers modqs,
1554: qp_qualifiers modqc
1555: WHERE modlh.name = p_name AND
1556: modlh.list_header_id = modqs.list_header_id AND
1557: modqc.list_header_id = modlh.list_header_id AND
1558: modqs.qualifier_attribute = 'QUALIFIER_ATTRIBUTE10' AND