APPS.PO_EMAIL_GENERATE dependencies on PO_LOOKUP_CODES

Line 2656: l_fob_lookup_desc PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

2652:
2653: l_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
2654: l_ship_via_lookup_desc ORG_FREIGHT_TL.FREIGHT_CODE_TL%TYPE;
2655: l_fob_lookup_code PO_HEADERS_ALL.FOB_LOOKUP_CODE%TYPE;
2656: l_fob_lookup_desc PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
2657: l_freight_terms_lc PO_HEADERS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;
2658: l_freight_terms_dsp PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
2659: l_payment_terms_id NUMBER;
2660: l_payment_terms ap_terms_val_v.name%TYPE;

Line 2658: l_freight_terms_dsp PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

2654: l_ship_via_lookup_desc ORG_FREIGHT_TL.FREIGHT_CODE_TL%TYPE;
2655: l_fob_lookup_code PO_HEADERS_ALL.FOB_LOOKUP_CODE%TYPE;
2656: l_fob_lookup_desc PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
2657: l_freight_terms_lc PO_HEADERS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;
2658: l_freight_terms_dsp PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
2659: l_payment_terms_id NUMBER;
2660: l_payment_terms ap_terms_val_v.name%TYPE;
2661: l_customer_acct_num PO_VENDOR_SITES.CUSTOMER_NUM%TYPE;
2662:

Line 3550: from po_lookup_codes

3546:
3547: begin
3548: select displayed_field
3549: into l_fob_lookup_desc
3550: from po_lookup_codes
3551: where lookup_type = 'FOB'
3552: and lookup_code = l_fob_lookup_code;
3553:
3554: exception