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_PREQ_PUB dependencies on QP_INT_LINES

Line 1555: FROM qp_int_lines line, oe_price_adjustments adj,

1551: , NULL BREAK_UOM_CODE
1552: , NULL BREAK_UOM_CONTEXT
1553: , NULL BREAK_UOM_ATTRIBUTE
1554: , NULL PROCESS_CODE -- 3215497
1555: FROM qp_int_lines line, oe_price_adjustments adj,
1556: qp_list_headers_b qplh
1557: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES
1558: AND line.process_status IN (QP_PREQ_PUB.G_STATUS_UPDATED,
1559: QP_PREQ_PUB.G_STATUS_NEW,

Line 1672: FROM qp_int_lines line, oe_price_adjustments adj,

1668: , NULL BREAK_UOM_CODE
1669: , NULL BREAK_UOM_CONTEXT
1670: , NULL BREAK_UOM_ATTRIBUTE
1671: , NULL PROCESS_CODE -- 3215497
1672: FROM qp_int_lines line, oe_price_adjustments adj,
1673: qp_list_headers_b qplh
1674: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES
1675: AND line.process_status IN (QP_PREQ_PUB.G_STATUS_UPDATED,
1676: QP_PREQ_PUB.G_STATUS_NEW,

Line 1718: FROM qp_int_lines line

1714: ass.rltd_price_adj_id related_line_detail_index,
1715: adj_pbh.list_line_id list_line_id,
1716: adj.list_line_id related_list_line_id,
1717: 'INSERTED FOR CALCULATION' pricing_status_text
1718: FROM qp_int_lines line
1719: , oe_price_adjustments adj_pbh
1720: , oe_price_adj_assocs ass
1721: , oe_price_adjustments adj
1722: , qp_pricing_attributes attr

Line 1763: FROM qp_int_lines line

1759: ass.rltd_price_adj_id related_line_detail_index,
1760: adj_prg.list_line_id list_line_id,
1761: adj.list_line_id related_list_line_id,
1762: 'INSERTED FOR CALCULATION' pricing_status_text
1763: FROM qp_int_lines line
1764: , oe_price_adjustments adj_prg
1765: , oe_price_adj_assocs ass
1766: , oe_price_adjustments adj
1767: , qp_int_lines getline

Line 1767: , qp_int_lines getline

1763: FROM qp_int_lines line
1764: , oe_price_adjustments adj_prg
1765: , oe_price_adj_assocs ass
1766: , oe_price_adjustments adj
1767: , qp_int_lines getline
1768: WHERE prg_exist_flag = 'Y'
1769: AND QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES
1770: AND line.line_type_code = QP_PREQ_PUB.G_LINE_LEVEL
1771: --and line.price_flag in (QP_PREQ_PUB.G_YES, QP_PREQ_PUB.G_PHASE)

Line 1793: qp_int_lines line,

1789:
1790: CURSOR l_pbh_adj_exists_cur IS
1791: SELECT /*+ index(adj OE_PRICE_ADJUSTMENTS_N2) */ 'Y'
1792: FROM
1793: qp_int_lines line,
1794: oe_price_adjustments adj
1795: WHERE adj.line_id = line.line_id
1796: AND line.line_type_code = QP_PREQ_PUB.G_LINE_LEVEL
1797: AND adj.list_line_type_code = QP_PREQ_PUB.G_PRICE_BREAK_TYPE

Line 1819: qp_int_lines line,

1815: QP_PREQ_PUB.G_YES))))
1816: UNION
1817: SELECT /*+ index(adj OE_PRICE_ADJUSTMENTS_N1) */ 'Y'
1818: FROM
1819: qp_int_lines line,
1820: oe_price_adjustments adj
1821: WHERE adj.header_id = line.line_id
1822: AND line.line_type_code = QP_PREQ_PUB.G_ORDER_LEVEL
1823: AND adj.list_line_type_code = QP_PREQ_PUB.G_PRICE_BREAK_TYPE

Line 1845: FROM qp_int_lines line,

1841:
1842:
1843: CURSOR l_prg_adj_exists_cur IS
1844: SELECT /*+ index(adj OE_PRICE_ADJUSTMENTS_N2) */ 'Y'
1845: FROM qp_int_lines line,
1846: oe_price_adjustments adj
1847: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES
1848: AND adj.line_id = line.line_id
1849: AND line.line_type_code = QP_PREQ_PUB.G_LINE_LEVEL

Line 1925: FROM qp_int_lines getline, oe_price_adjustments adj,

1921: , NULL BREAK_UOM_CODE
1922: , NULL BREAK_UOM_CONTEXT
1923: , NULL BREAK_UOM_ATTRIBUTE
1924: , NULL PROCESS_CODE -- 3215497
1925: FROM qp_int_lines getline, oe_price_adjustments adj,
1926: qp_int_ldets ldet, oe_price_adj_assocs ass
1927: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES
1928: AND ldet.CREATED_FROM_LIST_LINE_TYPE = 'PRG'
1929: AND ass.price_adjustment_id = ldet.price_adjustment_id

Line 4141: UPDATE qp_int_lines line

4137: AND ldet.process_code IN (G_STATUS_NEW, G_STATUS_UPDATED)
4138: AND ldet.applied_flag = G_YES))
4139: );
4140: ELSE
4141: UPDATE qp_int_lines line
4142: SET pricing_status_code = G_STATUS_UPDATED
4143: --for bug 2812738 not to update if back_calc_error/gsa_violatn
4144: WHERE line.pricing_status_code = G_STATUS_UNCHANGED
4145: --fix for bug 3425569 where frozen lines were set to status updated

Line 12672: FROM QP_INT_LINES;

12668: PROCESS_STATUS,
12669: CATCHWEIGHT_QTY,
12670: ACTUAL_ORDER_QUANTITY,
12671: ORDER_UOM_SELLING_PRICE
12672: FROM QP_INT_LINES;
12673:
12674: /*
12675: INDX,QP_PREQ_GRP.populate_output_int.l_ldets_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
12676: INDX,QP_PREQ_GRP.populate_output_int.l_ldets_cur,QP_INT_LDETS_N4,PRICING_STATUS_CODE,1

Line 14867: FROM QP_INT_LINES

14863: INTO x_line_unit_price,
14864: x_adjusted_unit_price,
14865: x_pricing_status_code,
14866: x_pricing_status_text
14867: FROM QP_INT_LINES
14868: WHERE line_index = p_line_index;
14869: ELSIF p_line_id IS NOT NULL THEN
14870: SELECT line_unit_price,
14871: order_uom_selling_price,

Line 14878: FROM QP_INT_LINES

14874: INTO x_line_unit_price,
14875: x_adjusted_unit_price,
14876: x_pricing_status_code,
14877: x_pricing_status_text
14878: FROM QP_INT_LINES
14879: WHERE line_id = p_line_id;
14880: ELSE
14881: x_return_status := FND_API.G_RET_STS_ERROR;
14882: x_pricing_status_text := 'Must pass either p_line_index or p_line_id while calling ' || l_routine;