APPS.ARP_CMREQ_WF dependencies on AR_LOOKUPS

Line 440: from ar_lookups l,

436: l_freight_amount,
437: l_orig_trx_number,
438: l_tax_ex_cert_num,
439: p_internal_comment
440: from ar_lookups l,
441: ra_cm_requests r
442: where r.request_id = p_item_key
443: and r.cm_reason_code = l.lookup_code
444: and l.lookup_type = 'CREDIT_MEMO_REASON';

Line 3275: from ar_lookups

3271:
3272: -- bug fix 1202680 -- notes should reflect the reason meaning and not the code.
3273: begin
3274: select meaning into l_reason_meaning
3275: from ar_lookups
3276: where lookup_type = 'CREDIT_MEMO_REASON'
3277: and lookup_code = l_reason_code;
3278: exception
3279: when others then

Line 3293: from ar_lookups

3289: l_note_text := fnd_message.get;
3290: l_note_text1 := l_note_text;
3291: if l_comments is not NULL then
3292: select meaning into l_comment_type
3293: from ar_lookups
3294: where LOOKUP_TYPE='AR_COMMENT_CLASSIFICATION'
3295: AND LOOKUP_CODE='C';
3296: l_note_text := l_note_text || ' :' || l_comment_type || ': "' || l_comments || '"';
3297: end if;

Line 3300: from ar_lookups

3296: l_note_text := l_note_text || ' :' || l_comment_type || ': "' || l_comments || '"';
3297: end if;
3298: IF l_internal_comment is NOT NULL then
3299: select meaning into l_comment_type
3300: from ar_lookups
3301: where LOOKUP_TYPE='AR_COMMENT_CLASSIFICATION'
3302: AND LOOKUP_CODE='I';
3303: l_note_text1 := l_note_text1 || ' :' || l_comment_type || ': "' || l_internal_comment || '"';
3304: