DBA Data[Home] [Help]

APPS.GR_PROCESS_ORDERS dependencies on SY_ADDR_MST_V

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