APPS.ARP_CMREQ_WF dependencies on AR_LOOKUPS

Line 478: from ar_lookups l,

474: l_freight_amount,
475: l_orig_trx_number,
476: l_tax_ex_cert_num,
477: p_internal_comment
478: from ar_lookups l,
479: ra_cm_requests r
480: where r.request_id = p_item_key
481: and r.cm_reason_code = l.lookup_code
482: and l.lookup_type = 'CREDIT_MEMO_REASON';

Line 3382: from ar_lookups

3378:
3379: -- bug fix 1202680 -- notes should reflect the reason meaning and not the code.
3380: begin
3381: select meaning into l_reason_meaning
3382: from ar_lookups
3383: where lookup_type = 'CREDIT_MEMO_REASON'
3384: and lookup_code = l_reason_code;
3385: exception
3386: when others then

Line 3400: from ar_lookups

3396: l_note_text := fnd_message.get;
3397: l_note_text1 := l_note_text;
3398: if l_comments is not NULL then
3399: select meaning into l_comment_type
3400: from ar_lookups
3401: where LOOKUP_TYPE='AR_COMMENT_CLASSIFICATION'
3402: AND LOOKUP_CODE='C';
3403: l_note_text := l_note_text || ' :' || l_comment_type || ': "' || l_comments || '"';
3404: end if;

Line 3407: from ar_lookups

3403: l_note_text := l_note_text || ' :' || l_comment_type || ': "' || l_comments || '"';
3404: end if;
3405: IF l_internal_comment is NOT NULL then
3406: select meaning into l_comment_type
3407: from ar_lookups
3408: where LOOKUP_TYPE='AR_COMMENT_CLASSIFICATION'
3409: AND LOOKUP_CODE='I';
3410: l_note_text1 := l_note_text1 || ' :' || l_comment_type || ': "' || l_internal_comment || '"';
3411: