APPS.AR_AME_CMWF_API dependencies on AR_LOOKUPS

Line 1272: FROM ar_lookups l, ra_cm_requests r

1268: r.freight_amount,
1269: r.ORIG_TRX_NUMBER,
1270: r.TAX_EX_CERT_NUM,
1271: r.internal_comment
1272: FROM ar_lookups l, ra_cm_requests r
1273: WHERE r.request_id = p_item_key
1274: AND r.cm_reason_code = l.lookup_code
1275: AND l.lookup_type = 'CREDIT_MEMO_REASON';
1276:

Line 3979: from ar_lookups

3975: -- bug fix 1202680 -- notes should reflect meaning and not the code.
3976:
3977: BEGIN
3978: SELECT meaning into l_reason_meaning
3979: from ar_lookups
3980: WHERE lookup_type = 'CREDIT_MEMO_REASON'
3981: and lookup_code = l_reason_code;
3982: EXCEPTION
3983: when others then

Line 3998: from ar_lookups

3994: l_note_text1 := l_note_text;
3995:
3996: IF l_comments is NOT NULL then
3997: select meaning into l_comment_type
3998: from ar_lookups
3999: where LOOKUP_TYPE='AR_COMMENT_CLASSIFICATION'
4000: AND LOOKUP_CODE='C';
4001: l_note_text := l_note_text || ' :' || l_comment_type || ': "' || l_comments || '"';
4002: END IF;

Line 4007: from ar_lookups

4003:
4004: /*bug 7367350 Changes to insert internla commen notes in invoice maintenance */
4005: IF l_internal_comment is NOT NULL then
4006: select meaning into l_comment_type
4007: from ar_lookups
4008: where LOOKUP_TYPE='AR_COMMENT_CLASSIFICATION'
4009: AND LOOKUP_CODE='I';
4010: l_note_text1 := l_note_text1 || ' :' || l_comment_type || ': "' || l_internal_comment || '"';
4011: