APPS.QP_VALIDATE_PLL_PRICING_ATTR dependencies on FND_PROFILE

Line 471: fnd_profile.value('QP_ORGANIZATION_ID');

467: where inventory_item_id =
468: p_PRICING_ATTR_rec.product_attr_value
469: AND NVL( CUSTOMER_ORDER_FLAG, 'Y' ) = 'Y'
470: and organization_id =
471: fnd_profile.value('QP_ORGANIZATION_ID');
472: ELSE
473: SELECT 'VALID' INTO l_dummy
474: FROM mtl_system_items_b
475: where inventory_item_id =

Line 479: fnd_profile.value('QP_ORGANIZATION_ID');

475: where inventory_item_id =
476: p_PRICING_ATTR_rec.product_attr_value
477: AND NVL(PURCHASING_ENABLED_FLAG,'N') = 'Y'
478: and organization_id =
479: fnd_profile.value('QP_ORGANIZATION_ID');
480: END IF;
481: /** 9210809 **/
482:
483: exception

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

506: begin
507: select 'VALID' INTO l_dummy
508: from mtl_item_uoms_view
509: where uom_code = p_PRICING_ATTR_rec.product_uom_code
510: and organization_id = fnd_profile.value('QP_ORGANIZATION_ID')
511: and inventory_item_id = p_PRICING_ATTR_rec.product_attr_value
512: and rownum = 1;
513: exception
514: WHEN NO_DATA_FOUND THEN

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

552: FROM MTL_SYSTEM_ITEMS_B MTLITM1,
553: MTL_UOM_CONVERSIONS MTLUCV
554: WHERE MTLUOM2.UOM_CODE = MTLUCV.UOM_CODE
555: AND MTLUOM2.UOM_CODE = p_PRICING_ATTR_rec.product_uom_code
556: AND MTLITM1.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')
557: AND MTLITM1.inventory_item_id in
558: (
559: SELECT inventory_item_id FROM mtl_item_categories
560: WHERE category_id = to_number(p_PRICING_ATTR_rec.product_attr_value)

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

557: AND MTLITM1.inventory_item_id in
558: (
559: SELECT inventory_item_id FROM mtl_item_categories
560: WHERE category_id = to_number(p_PRICING_ATTR_rec.product_attr_value)
561: AND organization_id = fnd_profile.value('QP_ORGANIZATION_ID')
562: )
563: AND NVL( MTLUCV.DISABLE_DATE, TRUNC(SYSDATE)+1 ) > TRUNC(SYSDATE)
564: AND
565: (