DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_UTIL dependencies on AR_LOOKUPS

Line 2551: select meaning into l_customer_name from ar_lookups where lookup_code=

2547: where party_id = to_number(p_attribute_value_code);
2548: END;
2549: END IF;
2550: elsif (p_attribute_code = 'QUALIFIER_ATTRIBUTE1') then
2551: select meaning into l_customer_name from ar_lookups where lookup_code=
2552: p_attribute_value_code and lookup_type= 'CUSTOMER CLASS';
2553: end if;
2554: return l_customer_name;
2555: exception

Line 2760: AR_LOOKUPS ARL,

2756: MTL_CUSTOMER_ITEMS MCIM, ( SELECT B.TERRITORY_CODE
2757: FROM FND_TERRITORIES_TL T, FND_TERRITORIES B
2758: WHERE B.TERRITORY_CODE = T.TERRITORY_CODE
2759: AND T.LANGUAGE = USERENV('LANG')) TERR,
2760: AR_LOOKUPS ARL,
2761: MFG_LOOKUPS MFL, mtl_customer_item_xrefs xref
2762: WHERE MCI.CUSTOMER_ID = HZC.CUST_ACCOUNT_ID
2763: AND MCI.ADDRESS_ID = RAD.ADDRESS_ID(+)
2764: AND MCI.COMMODITY_CODE_ID = MCC.COMMODITY_CODE_ID