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.QP_LIST_HEADERS_PVT dependencies on QP_LIST_HEADERS_B

Line 103: FROM qp_list_headers_b

99: --Start of code added for Bug 2444971. Added for Patchset H
100: BEGIN
101: SELECT pte_code, source_system_code
102: INTO l_saved_pte_code, l_saved_source_system_code
103: FROM qp_list_headers_b
104: WHERE list_header_id = l_PRICE_LIST_rec.list_header_id;
105:
106: EXCEPTION
107: WHEN OTHERS THEN

Line 440: FROM qp_list_headers_b

436: --Start of code added for Bug 2444971. Added for Patchset H
437: BEGIN
438: SELECT pte_code, source_system_code
439: INTO l_saved_pte_code, l_saved_source_system_code
440: FROM qp_list_headers_b
441: WHERE list_header_id = l_PRICE_LIST_LINE_rec.list_header_id;
442:
443: EXCEPTION
444: WHEN OTHERS THEN

Line 523: FROM qp_list_headers_b

519: IF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
520: BEGIN
521: SELECT pte_code, source_system_code
522: INTO l_saved_pte_code, l_saved_source_system_code
523: FROM qp_list_headers_b
524: WHERE list_header_id = l_PRICE_LIST_LINE_rec.list_header_id;
525:
526: EXCEPTION
527: WHEN OTHERS THEN

Line 830: l_list_type_code QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE;

826: l_p_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
827: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
828: l_old_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
829: l_old_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
830: l_list_type_code QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE;
831: l_pte_code VARCHAR2(30);
832: l_source_system_code VARCHAR2(30);
833: l_saved_pte_code VARCHAR2(30);
834: l_saved_source_system_code VARCHAR2(30);

Line 921: FROM qp_list_headers_b h, qp_qualifiers q

917: BEGIN
918: SELECT h.pte_code, h.source_system_code, h.list_type_code
919: INTO l_saved_pte_code, l_saved_source_system_code,
920: l_list_type_code
921: FROM qp_list_headers_b h, qp_qualifiers q
922: WHERE h.list_header_id = q.list_header_id
923: AND q.qualifier_id = l_QUALIFIERS_rec.qualifier_id;
924:
925: EXCEPTION

Line 1008: FROM qp_list_headers_b

1004:
1005: SELECT pte_code, source_system_code, list_type_code
1006: INTO l_saved_pte_code, l_saved_source_system_code,
1007: l_list_type_code
1008: FROM qp_list_headers_b
1009: WHERE list_header_id = l_QUALIFIERS_rec.list_header_id;
1010:
1011: EXCEPTION
1012: WHEN OTHERS THEN

Line 1084: FROM QP_LIST_HEADERS_B WHERE

1080:
1081: BEGIN
1082:
1083: SELECT LIST_TYPE_CODE INTO l_list_type_code
1084: FROM QP_LIST_HEADERS_B WHERE
1085: LIST_HEADER_ID = l_QUALIFIERS_rec.LIST_HEADER_ID;
1086: EXCEPTION
1087: When NO_DATA_FOUND Then Null;
1088: END;

Line 1489: FROM qp_list_headers_b h, qp_list_lines l

1485: --Start of code added for Bug 2444971. Added for Patchset H
1486: BEGIN
1487: SELECT h.pte_code, h.source_system_code
1488: INTO l_saved_pte_code, l_saved_source_system_code
1489: FROM qp_list_headers_b h, qp_list_lines l
1490: WHERE h.list_header_id = l.list_header_id
1491: AND l.list_line_id = l_PRICING_ATTR_rec.list_line_id;
1492:
1493: EXCEPTION

Line 1579: FROM qp_list_headers_b h, qp_list_lines l

1575: THEN
1576: BEGIN
1577: SELECT h.pte_code, h.source_system_code
1578: INTO l_saved_pte_code, l_saved_source_system_code
1579: FROM qp_list_headers_b h, qp_list_lines l
1580: WHERE h.list_header_id = l.list_header_id
1581: AND l.list_line_id = l_PRICING_ATTR_rec.list_line_id;
1582:
1583: EXCEPTION