APPS.OE_ID_TO_VALUE dependencies on AR_LOOKUPS

Line 685: FROM OE_AR_LOOKUPS_V

681: IF p_fob_point_code IS NOT NULL THEN
682:
683: SELECT MEANING
684: INTO l_fob_point
685: FROM OE_AR_LOOKUPS_V
686: WHERE LOOKUP_CODE = p_fob_point_code
687: AND LOOKUP_TYPE = l_lookup_type;
688:
689: END IF;

Line 2010: FROM OE_AR_LOOKUPS_V

2006: IF p_tax_point_code IS NOT NULL THEN
2007:
2008: SELECT MEANING
2009: INTO l_tax_point
2010: FROM OE_AR_LOOKUPS_V
2011: WHERE LOOKUP_CODE = p_tax_point_code
2012: AND LOOKUP_TYPE = l_lookup_type;
2013:
2014: END IF;

Line 2783: FROM OE_AR_LOOKUPS_V

2779: IF p_return_reason_code IS NOT NULL THEN
2780:
2781: SELECT MEANING
2782: INTO l_return_reason
2783: FROM OE_AR_LOOKUPS_V
2784: WHERE LOOKUP_CODE = p_return_reason_code
2785: AND LOOKUP_TYPE = l_lookup_type;
2786:
2787: END IF;

Line 6196: AR_LOOKUPS ARL

6192: HZ_CUST_ACCOUNT_ROLES ACCT_ROLES,
6193: HZ_CUST_ACCOUNTS CUST_ACCT,
6194: HZ_RELATIONSHIPS PARTY_REL,
6195: HZ_PARTIES REL_PARTY,
6196: AR_LOOKUPS ARL
6197: WHERE CONTACT.owner_table_name(+) = 'HZ_PARTIES'
6198: AND CONTACT.PRIMARY_FLAG (+) = 'Y'
6199: AND CONTACT.contact_point_type (+) = 'PHONE'
6200: AND ACCT_ROLES.PARTY_ID = CONTACT.owner_table_id(+)

Line 7007: FROM AR_LOOKUPS

7003:
7004: IF l_expiration_event_code IS NOT NULL THEN
7005: SELECT MEANING
7006: INTO x_expiration_event_attribute
7007: FROM AR_LOOKUPS
7008: WHERE lookup_type='AR_EXPIRATION_EVENTS'
7009: AND lookup_code = l_expiration_event_code;
7010: END IF;
7011:

Line 7057: FROM AR_LOOKUPS

7053:
7054: IF p_revrec_event_code IS NOT NULL THEN
7055: SELECT MEANING
7056: INTO l_revrec_event
7057: FROM AR_LOOKUPS
7058: WHERE lookup_type='AR_REVREC_EVENTS'
7059: AND lookup_code = p_revrec_event_code;
7060: ELSE
7061: l_revrec_event := NULL;