DBA Data[Home] [Help]

APPS.OE_ORDER_CACHE dependencies on HZ_CUSTOMER_PROFILES

Line 471: FROM HZ_CUSTOMER_PROFILES

467: BEGIN
468:
469: SELECT STANDARD_TERMS
470: INTO g_ship_to_rec.payment_term_id
471: FROM HZ_CUSTOMER_PROFILES
472: WHERE SITE_USE_ID = p_key;
473:
474: EXCEPTION
475:

Line 575: FROM HZ_CUSTOMER_PROFILES

571: BEGIN
572:
573: SELECT STANDARD_TERMS
574: INTO g_invoice_to_rec.payment_term_id
575: FROM HZ_CUSTOMER_PROFILES
576: WHERE SITE_USE_ID = p_key;
577:
578: EXCEPTION
579:

Line 871: FROM HZ_CUSTOMER_PROFILES

867: BEGIN
868:
869: SELECT STANDARD_TERMS
870: INTO g_sold_to_rec.payment_term_id
871: FROM HZ_CUSTOMER_PROFILES
872: WHERE CUST_ACCOUNT_ID = p_key
873: AND SITE_USE_ID IS NULL;
874:
875: EXCEPTION