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_QUALIFIERS_UTIL dependencies on QP_LIST_HEADERS_B

Line 1282: FROM QP_LIST_HEADERS_B

1278: BEGIN
1279:
1280: SELECT ACTIVE_FLAG, LIST_TYPE_CODE
1281: INTO l_active_flag, l_list_type_code
1282: FROM QP_LIST_HEADERS_B
1283: WHERE LIST_HEADER_ID = p_QUALIFIERS_rec.list_header_id;
1284:
1285: EXCEPTION
1286: WHEN OTHERS THEN

Line 1431: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_QUALIFIERS_rec.list_header_id)

1427: , p_QUALIFIERS_rec.qualify_hier_descendent_flag -- Added for TCA
1428: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1429: ,to_char(p_QUALIFIERS_rec.qualifier_id)
1430: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_QUALIFIERS_rec.list_line_id)
1431: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_QUALIFIERS_rec.list_header_id)
1432: );
1433:
1434: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1435: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN

Line 1609: ,nvl(ORIG_SYS_HEADER_REF,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_list_header_id))

1605: , QUALIFY_HIER_DESCENDENTS_FLAG -- Added for TCA
1606: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1607: ,to_char(qualifier_id)
1608: ,nvl(ORIG_SYS_LINE_REF,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_list_line_id))
1609: ,nvl(ORIG_SYS_HEADER_REF,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_list_header_id))
1610: from qp_qualifiers qual
1611: where list_header_id = p_list_header_id
1612: and list_line_id = p_list_line_id
1613: and ((p_qual_grp_no = -1

Line 1777: ,nvl(qual.ORIG_SYS_HEADER_REF,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=qual.list_header_id))

1773: , QUALIFY_HIER_DESCENDENTS_FLAG -- Added for TCA
1774: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1775: ,to_char(qual.qualifier_id)
1776: ,nvl(qual.ORIG_SYS_LINE_REF,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=qual.list_line_id))
1777: ,nvl(qual.ORIG_SYS_HEADER_REF,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=qual.list_header_id))
1778: from qp_qualifiers qual
1779: where qualifier_id = p_qual_id;
1780: END IF;--SQL%ROWCOUNT
1781: --AUTONOMOUS commit

Line 1922: ,nvl(ORIG_SYS_HEADER_REF,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_list_header_id))

1918: , QUALIFY_HIER_DESCENDENTS_FLAG -- Added for TCA
1919: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1920: ,to_char(qualifier_id)
1921: ,nvl(ORIG_SYS_LINE_REF,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_list_line_id))
1922: ,nvl(ORIG_SYS_HEADER_REF,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_list_header_id))
1923: from qp_qualifiers qual
1924: where list_header_id = p_list_header_id
1925: and list_line_id = p_list_line_id
1926: and qualifier_grouping_no = p_qual_grp_no