APPS.QP_VALIDATE_PLL_PRICING_ATTR dependencies on MTL_SYSTEM_ITEMS_B

Line 466: FROM mtl_system_items_b

462: begin
463: /** 9210809 **/
464: IF(fnd_global.resp_appl_id not in (178,201)) THEN
465: SELECT 'VALID' INTO l_dummy
466: FROM mtl_system_items_b
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 =

Line 474: FROM mtl_system_items_b

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 =
476: p_PRICING_ATTR_rec.product_attr_value
477: AND NVL(PURCHASING_ENABLED_FLAG,'N') = 'Y'
478: and organization_id =

Line 499: -- inserted for validation with the mtl_system_items_b

495: null;
496: end;
497: end if;
498: end if;
499: -- inserted for validation with the mtl_system_items_b
500:
501:
502:
503: -- Begin fix for bug#4039819

Line 552: FROM MTL_SYSTEM_ITEMS_B MTLITM1,

548: WHERE
549: EXISTS
550: (
551: SELECT /*+no_unnest*--/ 1
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')