DBA Data[Home] [Help]

APPS.INV_GMI_RSV_BRANCH dependencies on MTL_PARAMETERS

Line 42: FROM mtl_parameters p,

38: SELECT p.organization_id,
39: w.whse_code,
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

Line 59: organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE

55: -- Record type Definition Of A process_org
56:
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: );

Line 76: organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE

72: -- Record type Definition Of A discrete_org
73:
74: TYPE discrete_org_rec is RECORD
75: (
76: organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE
77: );
78:
79:
80: