APPS.AR_AME_CMWF_API dependencies on AR_LOOKUPS

Line 1311: FROM ar_lookups l, ra_cm_requests r

1307: r.freight_amount,
1308: r.ORIG_TRX_NUMBER,
1309: r.TAX_EX_CERT_NUM,
1310: r.internal_comment
1311: FROM ar_lookups l, ra_cm_requests r
1312: WHERE r.request_id = p_item_key
1313: AND r.cm_reason_code = l.lookup_code
1314: AND l.lookup_type = 'CREDIT_MEMO_REASON';
1315:

Line 4079: from ar_lookups

4075: -- bug fix 1202680 -- notes should reflect meaning and not the code.
4076:
4077: BEGIN
4078: SELECT meaning into l_reason_meaning
4079: from ar_lookups
4080: WHERE lookup_type = 'CREDIT_MEMO_REASON'
4081: and lookup_code = l_reason_code;
4082: EXCEPTION
4083: when others then

Line 4098: from ar_lookups

4094: l_note_text1 := l_note_text;
4095:
4096: IF l_comments is NOT NULL then
4097: select meaning into l_comment_type
4098: from ar_lookups
4099: where LOOKUP_TYPE='AR_COMMENT_CLASSIFICATION'
4100: AND LOOKUP_CODE='C';
4101: l_note_text := l_note_text || ' :' || l_comment_type || ': "' || l_comments || '"';
4102: END IF;

Line 4107: from ar_lookups

4103:
4104: /*bug 7367350 Changes to insert internla commen notes in invoice maintenance */
4105: IF l_internal_comment is NOT NULL then
4106: select meaning into l_comment_type
4107: from ar_lookups
4108: where LOOKUP_TYPE='AR_COMMENT_CLASSIFICATION'
4109: AND LOOKUP_CODE='I';
4110: l_note_text1 := l_note_text1 || ' :' || l_comment_type || ': "' || l_internal_comment || '"';
4111: