DBA Data[Home] [Help]

APPS.OE_ORDER_CACHE dependencies on STANDARD

Line 469: SELECT STANDARD_TERMS

465: -- Fetch payment term
466:
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:

Line 573: SELECT STANDARD_TERMS

569: -- Fetch payment term
570:
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:

Line 869: SELECT STANDARD_TERMS

865: -- Fetch payment term
866:
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;