DBA Data[Home] [Help]

APPS.GML_PO_INTERFACE dependencies on AP_TERMS

Line 70: v_terms_name AP_TERMS.NAME%TYPE;

66: v_agent_id PO_HEADERS_ALL.AGENT_ID%TYPE;
67: v_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
68: v_bill_to_location_id PO_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE;
69: v_terms_id PO_HEADERS_ALL.TERMS_ID%TYPE;
70: v_terms_name AP_TERMS.NAME%TYPE;
71: v_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
72: v_start_date PO_HEADERS_ALL.START_DATE%TYPE;
73: v_end_date PO_HEADERS_ALL.END_DATE%TYPE;
74: v_terms_code PO_HEADERS_ALL.SHIP_VIA_LOOKUP_CODE%TYPE;

Line 257: FROM ap_terms

253: /* T.Ricci 10/15/98 added terms_name_cur for terms code fix for OPM 11.0*/
254: CURSOR terms_name_cur
255: IS
256: SELECT name
257: FROM ap_terms
258: WHERE term_id = v_terms_id;
259:
260: /* T.Ricci 11/10/98 added shipper_code_cur to retreive correct shipper_code
261: 4 char value from op_ship_mst*/