APPS.GR_PROCESS_ORDERS dependencies on SY_ADDR_MST_V

Line 21: G_ADDR1 SY_ADDR_MST_V.addr1%TYPE;

17: G_DEFAULT_WHSE MTL_PARAMETERS.process_orgn_code%TYPE;
18: G_DEFAULT_ORGID MTL_PARAMETERS.organization_id%TYPE;
19:
20: G_CUST_NAME OP_CUST_MST.cust_name%TYPE;
21: G_ADDR1 SY_ADDR_MST_V.addr1%TYPE;
22: G_ADDR2 SY_ADDR_MST_V.addr2%TYPE;
23: G_ADDR3 SY_ADDR_MST_V.addr3%TYPE;
24: G_ADDR4 SY_ADDR_MST_V.addr4%TYPE;
25: G_STATE_CODE SY_ADDR_MST_V.state_code%TYPE;

Line 22: G_ADDR2 SY_ADDR_MST_V.addr2%TYPE;

18: G_DEFAULT_ORGID MTL_PARAMETERS.organization_id%TYPE;
19:
20: G_CUST_NAME OP_CUST_MST.cust_name%TYPE;
21: G_ADDR1 SY_ADDR_MST_V.addr1%TYPE;
22: G_ADDR2 SY_ADDR_MST_V.addr2%TYPE;
23: G_ADDR3 SY_ADDR_MST_V.addr3%TYPE;
24: G_ADDR4 SY_ADDR_MST_V.addr4%TYPE;
25: G_STATE_CODE SY_ADDR_MST_V.state_code%TYPE;
26: G_COUNTRY_CODE SY_ADDR_MST_V.country_code%TYPE;

Line 23: G_ADDR3 SY_ADDR_MST_V.addr3%TYPE;

19:
20: G_CUST_NAME OP_CUST_MST.cust_name%TYPE;
21: G_ADDR1 SY_ADDR_MST_V.addr1%TYPE;
22: G_ADDR2 SY_ADDR_MST_V.addr2%TYPE;
23: G_ADDR3 SY_ADDR_MST_V.addr3%TYPE;
24: G_ADDR4 SY_ADDR_MST_V.addr4%TYPE;
25: G_STATE_CODE SY_ADDR_MST_V.state_code%TYPE;
26: G_COUNTRY_CODE SY_ADDR_MST_V.country_code%TYPE;
27: G_POSTAL_CODE SY_ADDR_MST_V.postal_code%TYPE;

Line 24: G_ADDR4 SY_ADDR_MST_V.addr4%TYPE;

20: G_CUST_NAME OP_CUST_MST.cust_name%TYPE;
21: G_ADDR1 SY_ADDR_MST_V.addr1%TYPE;
22: G_ADDR2 SY_ADDR_MST_V.addr2%TYPE;
23: G_ADDR3 SY_ADDR_MST_V.addr3%TYPE;
24: G_ADDR4 SY_ADDR_MST_V.addr4%TYPE;
25: G_STATE_CODE SY_ADDR_MST_V.state_code%TYPE;
26: G_COUNTRY_CODE SY_ADDR_MST_V.country_code%TYPE;
27: G_POSTAL_CODE SY_ADDR_MST_V.postal_code%TYPE;
28:

Line 25: G_STATE_CODE SY_ADDR_MST_V.state_code%TYPE;

21: G_ADDR1 SY_ADDR_MST_V.addr1%TYPE;
22: G_ADDR2 SY_ADDR_MST_V.addr2%TYPE;
23: G_ADDR3 SY_ADDR_MST_V.addr3%TYPE;
24: G_ADDR4 SY_ADDR_MST_V.addr4%TYPE;
25: G_STATE_CODE SY_ADDR_MST_V.state_code%TYPE;
26: G_COUNTRY_CODE SY_ADDR_MST_V.country_code%TYPE;
27: G_POSTAL_CODE SY_ADDR_MST_V.postal_code%TYPE;
28:
29: /*

Line 26: G_COUNTRY_CODE SY_ADDR_MST_V.country_code%TYPE;

22: G_ADDR2 SY_ADDR_MST_V.addr2%TYPE;
23: G_ADDR3 SY_ADDR_MST_V.addr3%TYPE;
24: G_ADDR4 SY_ADDR_MST_V.addr4%TYPE;
25: G_STATE_CODE SY_ADDR_MST_V.state_code%TYPE;
26: G_COUNTRY_CODE SY_ADDR_MST_V.country_code%TYPE;
27: G_POSTAL_CODE SY_ADDR_MST_V.postal_code%TYPE;
28:
29: /*
30: ** Global numeric variables

Line 27: G_POSTAL_CODE SY_ADDR_MST_V.postal_code%TYPE;

23: G_ADDR3 SY_ADDR_MST_V.addr3%TYPE;
24: G_ADDR4 SY_ADDR_MST_V.addr4%TYPE;
25: G_STATE_CODE SY_ADDR_MST_V.state_code%TYPE;
26: G_COUNTRY_CODE SY_ADDR_MST_V.country_code%TYPE;
27: G_POSTAL_CODE SY_ADDR_MST_V.postal_code%TYPE;
28:
29: /*
30: ** Global numeric variables
31: */

Line 143: sy_addr_mst_v am

139: IS
140: SELECT ra.addr_id,
141: am.addr1
142: FROM gr_recipient_addresses ra,
143: sy_addr_mst_v am
144: WHERE ra.recipient_code = g_recipient_code
145: AND ra.addr_id = am.addr_id;
146: GlobalOtherAddrRecord g_get_other_addresses%ROWTYPE;
147: