DBA Data[Home] [Help]

APPS.QP_QUALIFIERS_UTIL dependencies on QP_LIST_LINES

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

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

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

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

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

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

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

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