APPS.QP_MODIFIERS_ISETUP_IMP dependencies on MTL_SYSTEM_ITEMS_KFV

Line 42: FROM MTL_SYSTEM_ITEMS_KFV KFV

38: if p_product_attr_context = 'ITEM' THEN
39: IF p_product_attr = 'PRICING_ATTRIBUTE1' THEN
40: begin
41: SELECT KFV.concatenated_segments into item_id
42: FROM MTL_SYSTEM_ITEMS_KFV KFV
43: WHERE inventory_item_id = p_product_attr_val
44: AND rownum =1;
45: RETURN item_id;
46: EXCEPTION WHEN OTHERS THEN

Line 77: FROM MTL_SYSTEM_ITEMS_KFV KFV

73: if p_product_attr_context = 'ITEM' THEN
74: IF (p_product_attr = 'PRICING_ATTRIBUTE1') THEN
75: begin
76: SELECT inventory_item_id into item_id
77: FROM MTL_SYSTEM_ITEMS_KFV KFV
78: WHERE concatenated_segments = p_product_attr_val
79: AND rownum =1;
80: RETURN item_id;
81: EXCEPTION WHEN OTHERS THEN

Line 381: FROM MTL_SYSTEM_ITEMS_KFV KFV group by concatenated_segments, inventory_item_id) KFV1,

377: , LL.continuouspricebreakflag
378: FROM QP_LIST_LINES_TEMP LL,
379: QP_PRICE_FORMULAS_TL TL2,
380: (SELECT concatenated_segments, inventory_item_id
381: FROM MTL_SYSTEM_ITEMS_KFV KFV group by concatenated_segments, inventory_item_id) KFV1,
382: MTL_PARAMETERS MTL,
383: QP_PRICE_FORMULAS_TL TL3,
384: (SELECT concatenated_segments, inventory_item_id
385: FROM MTL_SYSTEM_ITEMS_KFV KFV group by concatenated_segments, inventory_item_id) KFV2

Line 385: FROM MTL_SYSTEM_ITEMS_KFV KFV group by concatenated_segments, inventory_item_id) KFV2

381: FROM MTL_SYSTEM_ITEMS_KFV KFV group by concatenated_segments, inventory_item_id) KFV1,
382: MTL_PARAMETERS MTL,
383: QP_PRICE_FORMULAS_TL TL3,
384: (SELECT concatenated_segments, inventory_item_id
385: FROM MTL_SYSTEM_ITEMS_KFV KFV group by concatenated_segments, inventory_item_id) KFV2
386: WHERE LL.LISTHEADERID = mListHeaderId
387: AND LL.PRICEBYFORMULA = TL2.NAME(+)
388: AND LL.LANGUAGE = TL2.LANGUAGE(+)
389: AND LL.ORGANIZATIONCODE = MTL.ORGANIZATION_CODE(+)