DBA Data[Home] [Help]

APPS.QP_QUALIFIERS_UTIL dependencies on QP_LIST_LINES

Line 1431: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_QUALIFIERS_rec.list_line_id)

1427: , p_QUALIFIERS_rec.distinct_row_count
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');

Line 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))

1605: , p_transaction_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

Line 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))

1773: , p_transaction_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

Line 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))

1918: , p_transaction_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