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_RESOLVE_INCOMPATABILITY_PVT dependencies on QP_NPREQ_RLTD_LINES_TMP

Line 1687: FROM QP_NPREQ_RLTD_LINES_TMP y,qp_npreq_ldets_tmp z

1683: UPDATE qp_npreq_ldets_tmp x-- upd2
1684: SET PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL
1685: WHERE CREATED_FROM_LIST_LINE_ID in
1686: (select RELATED_LIST_LINE_ID
1687: FROM QP_NPREQ_RLTD_LINES_TMP y,qp_npreq_ldets_tmp z
1688: WHERE y.LIST_LINE_ID =z.CREATED_FROM_LIST_LINE_ID
1689: AND y.LINE_DETAIL_INDEX = z.LINE_DETAIL_INDEX
1690: AND z.PRICING_STATUS_CODE=QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL
1691: );

Line 1763: UPDATE qp_npreq_rltd_lines_tmp

1759: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,
1760: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,240)
1761: WHERE LINE_INDEX = p_line_index_tbl(i);
1762: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST
1763: UPDATE qp_npreq_rltd_lines_tmp
1764: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,
1765: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,240)
1766: WHERE RELATED_LINE_INDEX = p_line_index_tbl(i);
1767: EXCEPTION

Line 1789: FROM qp_npreq_rltd_lines_tmp

1785: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,
1786: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,2000)
1787: WHERE LINE_DETAIL_INDEX = p_line_detail_index_tbl(i) OR
1788: EXISTS (SELECT 1 --[julin/4671446] also deleting children ldets
1789: FROM qp_npreq_rltd_lines_tmp
1790: WHERE LINE_DETAIL_INDEX = p_line_detail_index_tbl(i)
1791: AND RELATED_LINE_DETAIL_INDEX = a.LINE_DETAIL_INDEX);
1792: FORALL i IN p_line_detail_index_tbl.FIRST..p_line_detail_index_tbl.LAST
1793: UPDATE qp_npreq_rltd_lines_tmp

Line 1793: UPDATE qp_npreq_rltd_lines_tmp

1789: FROM qp_npreq_rltd_lines_tmp
1790: WHERE LINE_DETAIL_INDEX = p_line_detail_index_tbl(i)
1791: AND RELATED_LINE_DETAIL_INDEX = a.LINE_DETAIL_INDEX);
1792: FORALL i IN p_line_detail_index_tbl.FIRST..p_line_detail_index_tbl.LAST
1793: UPDATE qp_npreq_rltd_lines_tmp
1794: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,
1795: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,240)
1796: WHERE (LINE_DETAIL_INDEX = p_line_detail_index_tbl(i) OR
1797: RELATED_LINE_DETAIL_INDEX = p_line_detail_index_tbl(i)); --[julin/4671446] also deleting children ldets

Line 1818: FROM qp_npreq_ldets_tmp ldets, qp_npreq_rltd_lines_tmp rltd

1814: -- [prarasto/4141235] find loser prg line indexes to be deleted, incompatibility group
1815: --frontported fix done in 4134088
1816: CURSOR l_del_prg_lines_grp_cur IS
1817: SELECT rltd.RELATED_LINE_INDEX
1818: FROM qp_npreq_ldets_tmp ldets, qp_npreq_rltd_lines_tmp rltd
1819: WHERE ldets.INCOMPATABILITY_GRP_CODE = p_incomp_grp_id
1820: AND ldets.LINE_INDEX = p_line_index
1821: AND ldets.PRICING_PHASE_ID = p_pricing_phase_id
1822: AND ldets.CREATED_FROM_LIST_LINE_ID <> p_list_line_id

Line 1832: FROM qp_npreq_ldets_tmp ldets, qp_npreq_rltd_lines_tmp rltd

1828: -- [prarasto/4141235] find loser prg line indexes to be deleted, incompatibility group
1829: --frontported fix done in 4134088
1830: CURSOR l_del_oid_ldets_grp_cur IS
1831: SELECT rltd.RELATED_LINE_DETAIL_INDEX
1832: FROM qp_npreq_ldets_tmp ldets, qp_npreq_rltd_lines_tmp rltd
1833: WHERE ldets.INCOMPATABILITY_GRP_CODE = p_incomp_grp_id
1834: AND ldets.LINE_INDEX = p_line_index
1835: AND ldets.PRICING_PHASE_ID = p_pricing_phase_id
1836: AND ldets.CREATED_FROM_LIST_LINE_ID <> p_list_line_id

Line 1846: FROM qp_npreq_ldets_tmp ldets, qp_npreq_rltd_lines_tmp rltd

1842: -- [prarasto/4141235] find loser prg line indexes to be deleted, incompatibility group
1843: --frontported fix done in 4134088
1844: CURSOR l_del_prg_lines_excl_cur IS
1845: SELECT rltd.RELATED_LINE_INDEX
1846: FROM qp_npreq_ldets_tmp ldets, qp_npreq_rltd_lines_tmp rltd
1847: WHERE ldets.LINE_INDEX = p_line_index
1848: AND ldets.PRICING_PHASE_ID = p_pricing_phase_id
1849: AND ldets.CREATED_FROM_LIST_LINE_ID <> p_list_line_id
1850: AND ldets.LINE_DETAIL_TYPE_CODE <> QP_PREQ_GRP.G_CHILD_DETAIL_TYPE

Line 1859: FROM qp_npreq_ldets_tmp ldets, qp_npreq_rltd_lines_tmp rltd

1855: -- [prarasto/4141235] find loser prg line indexes to be deleted, incompatibility group
1856: --frontported fix done in 4134088
1857: CURSOR l_del_oid_ldets_excl_cur IS
1858: SELECT rltd.RELATED_LINE_DETAIL_INDEX
1859: FROM qp_npreq_ldets_tmp ldets, qp_npreq_rltd_lines_tmp rltd
1860: WHERE ldets.LINE_INDEX = p_line_index
1861: AND ldets.PRICING_PHASE_ID = p_pricing_phase_id
1862: AND ldets.CREATED_FROM_LIST_LINE_ID <> p_list_line_id
1863: AND ldets.LINE_DETAIL_TYPE_CODE <> QP_PREQ_GRP.G_CHILD_DETAIL_TYPE