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 6222: AR_LOOKUPS ARL

6218: HZ_CUST_ACCOUNT_ROLES ACCT_ROLES,
6219: HZ_CUST_ACCOUNTS CUST_ACCT,
6220: HZ_RELATIONSHIPS PARTY_REL,
6221: HZ_PARTIES REL_PARTY,
6222: AR_LOOKUPS ARL
6223: WHERE CONTACT.owner_table_name(+) = 'HZ_PARTIES'
6224: AND CONTACT.PRIMARY_FLAG (+) = 'Y'
6225: AND CONTACT.contact_point_type (+) = 'PHONE'
6226: AND ACCT_ROLES.PARTY_ID = CONTACT.owner_table_id(+)

Line 7033: FROM AR_LOOKUPS

7029:
7030: IF l_expiration_event_code IS NOT NULL THEN
7031: SELECT MEANING
7032: INTO x_expiration_event_attribute
7033: FROM AR_LOOKUPS
7034: WHERE lookup_type='AR_EXPIRATION_EVENTS'
7035: AND lookup_code = l_expiration_event_code;
7036: END IF;
7037:

Line 7083: FROM AR_LOOKUPS

7079:
7080: IF p_revrec_event_code IS NOT NULL THEN
7081: SELECT MEANING
7082: INTO l_revrec_event
7083: FROM AR_LOOKUPS
7084: WHERE lookup_type='AR_REVREC_EVENTS'
7085: AND lookup_code = p_revrec_event_code;
7086: ELSE
7087: l_revrec_event := NULL;