DBA Data[Home] [Help]

APPS.PO_EMAIL_GENERATE dependencies on AP_TERMS_VAL_V

Line 2439: l_payment_terms ap_terms_val_v.name%TYPE;

2435: l_fob_lookup_desc PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
2436: l_freight_terms_lc PO_HEADERS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;
2437: l_freight_terms_dsp PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
2438: l_payment_terms_id NUMBER;
2439: l_payment_terms ap_terms_val_v.name%TYPE;
2440: l_customer_acct_num PO_VENDOR_SITES.CUSTOMER_NUM%TYPE;
2441:
2442: x_orgid NUMBER;
2443:

Line 3396: from ap_terms_val_v apv

3392: end;
3393:
3394: begin
3395: select name into l_payment_terms
3396: from ap_terms_val_v apv
3397: where apv.TERM_ID = l_payment_terms_id;
3398: exception
3399: when others then
3400: l_payment_terms := '';