DBA Data[Home] [Help]

APPS.QP_UTIL dependencies on MTL_SYSTEM_ITEMS_B

Line 5166: FROM mtl_system_items_b

5162: if (p_product_context = 'ITEM')
5163: and (p_product_attribute = 'PRICING_ATTRIBUTE1') THEN
5164: begin
5165: SELECT 'VALID' INTO l_dummy
5166: FROM mtl_system_items_b
5167: where inventory_item_id = p_product_attr_val
5168: AND ((l_appl_id not in (178,201) and customer_order_flag = 'Y')
5169: or (l_appl_id in (178, 201) and NVL(PURCHASING_ENABLED_FLAG, 'N') ='Y'))
5170: and organization_id = Get_Item_Validation_Org;