APPS.GR_PROCESS_ORDERS dependencies on SY_ADDR_MST

Line 4355: L_ADDRESS_ID SY_ADDR_MST.addr_id%TYPE;

4351: /*
4352: ** Numeric Variables
4353: */
4354: L_CUSTOMER_ID OP_CUST_MST.cust_id%TYPE;
4355: L_ADDRESS_ID SY_ADDR_MST.addr_id%TYPE;
4356:
4357: X_MSG_COUNT NUMBER;
4358: L_FIRST_SPACE NUMBER;
4359:

Line 4393: L_ADDR_LINE SY_ADDR_MST.addr1%TYPE;

4389: L_MSG_DATA VARCHAR2(2000);
4390: L_TELEPHONE_NUMBER VARCHAR2(70);
4391:
4392: L_LABEL_CODE GR_LABELS_B.label_code%TYPE;
4393: L_ADDR_LINE SY_ADDR_MST.addr1%TYPE;
4394: L_DEFAULT_ORGN SY_ORGN_MST.orgn_code%TYPE;
4395:
4396: X_MSG_DATA VARCHAR2(2000);
4397:

Line 4455: sy_addr_mst_v oa,

4451: oc.evening_telephone,
4452: oc.evening_extension,
4453: oc.evening_area_code
4454: FROM gr_organization_contacts oc,
4455: sy_addr_mst_v oa,
4456: sy_orgn_mst om
4457: WHERE om.orgn_code = g_default_orgn
4458: AND om.addr_id = oa.addr_id
4459: AND oc.orgn_code = om.orgn_code;

Line 4484: sy_addr_mst_v oa,

4480: oc.evening_telephone,
4481: oc.evening_extension,
4482: oc.evening_area_code
4483: FROM gr_organization_contacts oc,
4484: sy_addr_mst_v oa,
4485: hr_operating_units hou,
4486: gl_plcy_mst gl,
4487: sy_orgn_mst om
4488: WHERE om.orgn_code = g_default_orgn