DBA Data[Home] [Help]

APPS.INV_GMI_RSV_BRANCH dependencies on SY_ORGN_MST

Line 44: sy_orgn_mst s

40: s.co_code,
41: s.orgn_code
42: FROM mtl_parameters p,
43: ic_whse_mst w,
44: sy_orgn_mst s
45: WHERE
46: w.mtl_organization_id = p.organization_id
47: AND p.ORGANIZATION_ID = p_organization_id
48: AND s.orgn_code = w.orgn_code

Line 61: , co_code SY_ORGN_MST.PARENT_ORGN_CODE%TYPE

57: TYPE process_org_rec is RECORD
58: (
59: organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE
60: , whse_code IC_WHSE_MST.WHSE_CODE%TYPE
61: , co_code SY_ORGN_MST.PARENT_ORGN_CODE%TYPE
62: , orgn_code SY_ORGN_MST.ORGN_CODE%TYPE
63: );
64:
65:

Line 62: , orgn_code SY_ORGN_MST.ORGN_CODE%TYPE

58: (
59: organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE
60: , whse_code IC_WHSE_MST.WHSE_CODE%TYPE
61: , co_code SY_ORGN_MST.PARENT_ORGN_CODE%TYPE
62: , orgn_code SY_ORGN_MST.ORGN_CODE%TYPE
63: );
64:
65:
66: