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 MTL_ITEM_CATEGORIES_V

Line 117: , mtl_item_categories_v micv

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
120: WHERE ql1.list_header_id = pn_list_header_id
121: AND ql1.list_line_id = qp1.list_line_id

Line 155: mtl_item_categories_v micv

151: AND ql.list_line_id = qp.list_line_id
152: AND EXISTS ( SELECT
153: micv.category_id
154: FROM
155: mtl_item_categories_v micv
156: WHERE micv.inventory_item_id = NVL( pn_inventory_item_id, micv.inventory_item_id)
157: AND micv.category_set_name = lv_category_set_name
158: AND TO_CHAR(micv.category_id) = qp.product_attr_value
159: )

Line 171: , mtl_item_categories_v micv

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
174: AND micv.inventory_item_id = NVL( pn_inventory_item_id, micv.inventory_item_id)
175: AND micv.category_set_name = lv_category_set_name