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 1283: FROM QP_LIST_HEADERS_B

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

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

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

Line 1610: ,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))

1606: , QUALIFY_HIER_DESCENDENTS_FLAG -- Added for TCA
1607: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1608: ,to_char(qualifier_id)
1609: ,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))
1610: ,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))
1611: from qp_qualifiers qual
1612: where list_header_id = p_list_header_id
1613: and list_line_id = p_list_line_id
1614: and ((p_qual_grp_no = -1

Line 1778: ,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))

1774: , QUALIFY_HIER_DESCENDENTS_FLAG -- Added for TCA
1775: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1776: ,to_char(qual.qualifier_id)
1777: ,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))
1778: ,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))
1779: from qp_qualifiers qual
1780: where qualifier_id = p_qual_id;
1781: END IF;--SQL%ROWCOUNT
1782: --AUTONOMOUS commit

Line 1923: ,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))

1919: , QUALIFY_HIER_DESCENDENTS_FLAG -- Added for TCA
1920: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1921: ,to_char(qualifier_id)
1922: ,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))
1923: ,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))
1924: from qp_qualifiers qual
1925: where list_header_id = p_list_header_id
1926: and list_line_id = p_list_line_id
1927: and qualifier_grouping_no = p_qual_grp_no