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_LIMIT_BALANCE_CHECK_PVT dependencies on QP_LIMIT_ATTRIBUTES

Line 1893: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMIT_ATTRIBUTES_N1,LIMIT_ID,1

1889: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_ldets_tmp_N4,PRICING_STATUS_CODE,1
1890: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_ldets_tmp_N4,HEADER_LIMIT_EXISTS,2
1891: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMITS_N1,LIST_HEADER_ID,1
1892: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMITS_N1,LIST_LINE_ID,2
1893: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMIT_ATTRIBUTES_N1,LIMIT_ID,1
1894: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
1895: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
1896: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
1897: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4

Line 1939: qp_limit_attributes a, qp_npreq_line_attrs_tmp rl, qp_npreq_lines_tmp q

1935: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
1936: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
1937: q.priced_quantity quantity_wanted
1938: FROM qp_npreq_ldets_tmp r, qp_limits l,
1939: qp_limit_attributes a, qp_npreq_line_attrs_tmp rl, qp_npreq_lines_tmp q
1940: WHERE r.created_from_list_header_id = l.list_header_id
1941: AND r.created_from_list_line_id = l.list_line_id
1942: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
1943: AND r.applied_flag = 'Y' -- [5385851/5322832]

Line 1969: from qp_limit_attributes la

1965: l.multival_attr2_context, l.multival_attribute2,
1966: l.multival_attr2_type, l.multival_attr2_datatype,
1967: q.priced_quantity, q.line_type_code
1968: HAVING count(*) = (select count(*)
1969: from qp_limit_attributes la
1970: where la.limit_id = l.limit_id)
1971:
1972: UNION
1973:

Line 2053: qp_limit_attributes a, qp_npreq_line_attrs_tmp rl, qp_npreq_lines_tmp q

2049: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
2050: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
2051: q.priced_quantity quantity_wanted
2052: FROM qp_npreq_ldets_tmp r, qp_limits l,
2053: qp_limit_attributes a, qp_npreq_line_attrs_tmp rl, qp_npreq_lines_tmp q
2054: WHERE r.created_from_list_header_id = l.list_header_id
2055: AND l.list_line_id = -1
2056: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2057: AND r.applied_flag = 'Y' -- [5385851/5322832]

Line 2083: from qp_limit_attributes la

2079: l.multival_attr2_context, l.multival_attribute2,
2080: l.multival_attr2_type, l.multival_attr2_datatype,
2081: q.priced_quantity, q.line_type_code
2082: HAVING count(*) = (select count(*)
2083: from qp_limit_attributes la
2084: where la.limit_id = l.limit_id)
2085:
2086: UNION
2087: