DBA Data[Home] [Help]

APPS.PON_SOURCING_OPENAPI_GRP dependencies on FND_LOOKUP_VALUES

Line 3064: v_attr_group_name fnd_lookup_values.meaning%TYPE;

3060: p_to_line_number IN NUMBER) IS
3061: v_ip_attr_default_option VARCHAR2(10);
3062: v_default_attr_group pon_auction_attributes.attr_group%TYPE;
3063: v_max_seq_number NUMBER;
3064: v_attr_group_name fnd_lookup_values.meaning%TYPE;
3065:
3066: CURSOR lines IS
3067: SELECT interface_line_number
3068: FROM pon_auc_items_interface

Line 3086: fnd_lookup_values flv

3082: flv.meaning
3083: into v_default_attr_group,
3084: v_attr_group_name
3085: from pon_party_preferences ppp,
3086: fnd_lookup_values flv
3087: where ppp.app_short_name = 'PON' and
3088: ppp.preference_name = 'LINE_ATTR_DEFAULT_GROUP' and
3089: ppp.party_id = (select trading_partner_id from pon_auction_headers_all where auction_header_id = p_document_number) and
3090: flv.lookup_type = 'PON_LINE_ATTRIBUTE_GROUPS' and