APPS.PO_EMAIL_GENERATE dependencies on PO_LOOKUP_CODES

Line 2435: l_fob_lookup_desc PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

2431:
2432: l_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
2433: l_ship_via_lookup_desc ORG_FREIGHT_TL.FREIGHT_CODE_TL%TYPE;
2434: l_fob_lookup_code PO_HEADERS_ALL.FOB_LOOKUP_CODE%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;

Line 2437: l_freight_terms_dsp PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

2433: l_ship_via_lookup_desc ORG_FREIGHT_TL.FREIGHT_CODE_TL%TYPE;
2434: l_fob_lookup_code PO_HEADERS_ALL.FOB_LOOKUP_CODE%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:

Line 3119: from po_lookup_codes

3115:
3116: begin
3117: select displayed_field
3118: into l_fob_lookup_desc
3119: from po_lookup_codes
3120: where lookup_type = 'FOB'
3121: and lookup_code = l_fob_lookup_code;
3122:
3123: exception