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.JAI_OM_UTILS_PKG dependencies on QP_LIST_LINES

Line 70: FROM qp_list_lines qpll,

66: AND unit_code = unt
67: AND price_list_id = new_list; */ /*Changed cursor query for bug 16574430 */
68:
69: SELECT qpll.operand list_price
70: FROM qp_list_lines qpll,
71: qp_pricing_attributes qppr
72: WHERE qppr.list_line_id = qpll.list_line_id
73: AND qpll.list_header_id = new_list
74: AND qppr.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM'

Line 159: qp_list_lines b,

155: qlhb.currency_code /* Added for bug#8844209 */
156:
157: FROM
158: JAI_CMN_CUS_ADDRESSES a,
159: qp_list_lines b,
160: qp_pricing_attributes c ,
161: qp_list_headers_b qlhb /* Added for bug#8844209 */
162: WHERE
163: a.customer_id = p_customer_id AND

Line 193: qp_list_lines b,

189: c.product_uom_code list_price_uom_code ,
190: qlhb.currency_code /* Added for bug#8844209 */
191: FROM
192: JAI_CMN_CUS_ADDRESSES a,
193: qp_list_lines b,
194: qp_pricing_attributes c,
195: qp_list_headers_b qlhb /* Added for bug#8844209 */
196: WHERE
197: a.customer_id = p_customer_id AND

Line 222: qp_list_lines b,

218: c.product_uom_code list_price_uom_code ,
219: qlhb.currency_code /* Added for bug#8844209 */
220: FROM
221: JAI_CMN_CUS_ADDRESSES a,
222: qp_list_lines b,
223: qp_pricing_attributes c,
224: qp_list_headers_b qlhb /* Added for bug#8844209 */
225: WHERE
226: a.customer_id = p_customer_id AND

Line 285: , qp_list_lines b

281: , c.product_uom_code list_price_uom_code,
282: qlhb.currency_code /* Added for bug#8844209 */
283: FROM
284: jai_cmn_cus_addresses a
285: , qp_list_lines b
286: , qp_pricing_attributes c ,
287: qp_list_headers_b qlhb /* Added for bug#8844209 */
288: WHERE a.customer_id = pn_party_id
289: AND a.address_id = pn_address_id

Line 321: , qp_list_lines b

317: , c.product_uom_code list_price_uom_code,
318: qlhb.currency_code /* Added for bug#8844209 */
319: FROM
320: jai_cmn_cus_addresses a
321: , qp_list_lines b
322: , qp_pricing_attributes c ,
323: qp_list_headers_b qlhb /* Added for bug#8844209 */
324: WHERE a.customer_id = pn_party_id
325: AND a.address_id = pn_address_id

Line 356: , qp_list_lines b

352: , c.product_uom_code list_price_uom_code,
353: qlhb.currency_code /* Added for bug#8844209 */
354: FROM
355: jai_cmn_cus_addresses a
356: , qp_list_lines b
357: , qp_pricing_attributes c ,
358: qp_list_headers_b qlhb /* Added for bug#8844209 */
359: WHERE a.customer_id = pn_party_id
360: AND a.address_id = pn_address_id

Line 902: FROM qp_list_lines qpll,

898: NVL(START_DATE_ACTIVE,SYSDATE)
899: AND NVL(END_DATE_ACTIVE,SYSDATE);*/ /*Changed cursor query for bug 16574430 */
900:
901: SELECT qpll.operand list_price
902: FROM qp_list_lines qpll,
903: qp_pricing_attributes qppr
904: WHERE qppr.list_line_id = qpll.list_line_id
905: AND qpll.list_header_id = new_no
906: AND qppr.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM'