DBA Data[Home] [Help]

APPS.JAI_AVLIST_VALIDATE_PKG dependencies on QP_PRICING_ATTRIBUTES

Line 116: , qp_pricing_attributes qp1

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

Line 119: , qp_pricing_attributes qp2

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)
123: AND micv.inventory_item_id = NVL( pn_inventory_item_id, micv.inventory_item_id)

Line 149: , qp_pricing_attributes qp

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
153: micv.category_id

Line 170: , qp_pricing_attributes qp

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