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_AVLIST_VALIDATE_PKG dependencies on QP_LIST_LINES

Line 115: qp_list_lines ql1

111: IS
112: SELECT
113: micv.category_id category_id
114: FROM
115: qp_list_lines ql1
116: , qp_pricing_attributes qp1
117: , mtl_item_categories_v micv
118: , qp_list_lines ql2
119: , qp_pricing_attributes qp2

Line 118: , qp_list_lines ql2

114: FROM
115: qp_list_lines ql1
116: , qp_pricing_attributes qp1
117: , mtl_item_categories_v micv
118: , qp_list_lines ql2
119: , qp_pricing_attributes qp2
120: WHERE ql1.list_header_id = pn_list_header_id
121: AND ql1.list_line_id = qp1.list_line_id
122: AND qp1.product_attr_value = TO_CHAR(micv.category_id)

Line 148: qp_list_lines ql

144: /*SELECT
145: qp.product_uom_code uom_code
146: , COUNT(qp.product_attr_value) category_number
147: FROM
148: qp_list_lines ql
149: , qp_pricing_attributes qp
150: WHERE ql.list_header_id = pn_list_header_id
151: AND ql.list_line_id = qp.list_line_id
152: AND EXISTS ( SELECT

Line 169: qp_list_lines ql

165: qp.product_uom_code uom_code
166: , COUNT(distinct qp.product_attr_value) category_number
167: ,micv.inventory_item_id
168: FROM
169: qp_list_lines ql
170: , qp_pricing_attributes qp
171: , mtl_item_categories_v micv
172: WHERE ql.list_header_id = pn_list_header_id
173: AND ql.list_line_id = qp.list_line_id

Line 189: from qp_list_lines a, qp_list_lines_v b

185: ( pn_list_header_id NUMBER
186: )
187: IS
188: select count(1)
189: from qp_list_lines a, qp_list_lines_v b
190: where a.list_line_id = b.list_line_id
191: and b.product_attribute = 'PRICING_ATTRIBUTE2'
192: and a.list_header_id = pn_list_header_id;
193: