APPS.QP_VALIDATE_PLL_PRICING_ATTR dependencies on FND_PROFILE

Line 425: and organization_id = fnd_profile.value('QP_ORGANIZATION_ID');

421: SELECT 'VALID' INTO l_dummy
422: FROM mtl_system_items_b
423: where inventory_item_id = p_PRICING_ATTR_rec.product_attr_value
424: AND customer_order_flag = 'Y'
425: and organization_id = fnd_profile.value('QP_ORGANIZATION_ID');
426: exception
427: WHEN NO_DATA_FOUND THEN
428:
429: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

Line 453: and organization_id = fnd_profile.value('QP_ORGANIZATION_ID')

449: begin
450: select 'VALID' INTO l_dummy
451: from mtl_item_uoms_view
452: where uom_code = p_PRICING_ATTR_rec.product_uom_code
453: and organization_id = fnd_profile.value('QP_ORGANIZATION_ID')
454: and inventory_item_id = p_PRICING_ATTR_rec.product_attr_value
455: and rownum = 1;
456: exception
457: WHEN NO_DATA_FOUND THEN

Line 499: AND MTLITM1.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')

495: FROM MTL_SYSTEM_ITEMS_B MTLITM1,
496: MTL_UOM_CONVERSIONS MTLUCV
497: WHERE MTLUOM2.UOM_CODE = MTLUCV.UOM_CODE
498: AND MTLUOM2.UOM_CODE = p_PRICING_ATTR_rec.product_uom_code
499: AND MTLITM1.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')
500: AND MTLITM1.inventory_item_id in
501: (
502: SELECT inventory_item_id FROM mtl_item_categories
503: WHERE category_id = to_number(p_PRICING_ATTR_rec.product_attr_value)

Line 504: AND organization_id = fnd_profile.value('QP_ORGANIZATION_ID')

500: AND MTLITM1.inventory_item_id in
501: (
502: SELECT inventory_item_id FROM mtl_item_categories
503: WHERE category_id = to_number(p_PRICING_ATTR_rec.product_attr_value)
504: AND organization_id = fnd_profile.value('QP_ORGANIZATION_ID')
505: )
506: AND NVL( MTLUCV.DISABLE_DATE, TRUNC(SYSDATE)+1 ) > TRUNC(SYSDATE)
507: AND
508: (