APPS.JAI_CMN_SETUP_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 47: from jai_cmn_inventory_orgs

43: /*added by vkaranam for bug #6030615*/
44: --start
45: cursor c_org_type (cp_organization_id in number , cp_location_id in number ) IS
46: select manufacturing , trading
47: from jai_cmn_inventory_orgs
48: where organization_id = cp_organization_id
49: and location_id = cp_location_id;
50:
51: r_org_type c_org_type%rowtype;

Line 93: FROM JAI_CMN_INVENTORY_ORGS A

89: for update;
90:
91: CURSOR c_Tr_ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
92: SELECT A.Organization_Id, A.Location_Id
93: FROM JAI_CMN_INVENTORY_ORGS A
94: WHERE A.Tr_Ec_Code IN
95: (
96: SELECT B.Tr_Ec_Code
97: FROM JAI_CMN_INVENTORY_ORGS B

Line 97: FROM JAI_CMN_INVENTORY_ORGS B

93: FROM JAI_CMN_INVENTORY_ORGS A
94: WHERE A.Tr_Ec_Code IN
95: (
96: SELECT B.Tr_Ec_Code
97: FROM JAI_CMN_INVENTORY_ORGS B
98: WHERE B.Organization_Id = p_organization_id
99: AND B.Location_Id = p_location_id
100: );
101:

Line 107: FROM JAI_CMN_INVENTORY_ORGS A

103: --AND nvl(EXCISE_INVNO_AT_EC_CODE, 'N') = 'Y' --Added by nprashar for bug # 7319628;
104: */
105: CURSOR c_ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
106: SELECT A.Organization_Id, A.Location_Id
107: FROM JAI_CMN_INVENTORY_ORGS A
108: WHERE A.Ec_Code IN
109: (
110: SELECT B.Ec_Code
111: FROM JAI_CMN_INVENTORY_ORGS B

Line 111: FROM JAI_CMN_INVENTORY_ORGS B

107: FROM JAI_CMN_INVENTORY_ORGS A
108: WHERE A.Ec_Code IN
109: (
110: SELECT B.Ec_Code
111: FROM JAI_CMN_INVENTORY_ORGS B
112: WHERE B.Organization_Id = p_organization_id
113: AND B.Location_Id = p_location_id
114: )
115: AND nvl(EXCISE_INVNO_AT_EC_CODE, 'N') = 'Y' /*Added by nprashar for bug # 7319628*/;

Line 130: from JAI_CMN_INVENTORY_ORGS

126:
127:
128: Cursor c_master_org is
129: Select ec_code , master_org_flag , master_organization_id, EXCISE_INVNO_AT_EC_CODE
130: from JAI_CMN_INVENTORY_ORGS
131: where organization_id = p_organization_id
132: and location_id = p_location_id;
133:
134:

Line 137: from JAI_CMN_INVENTORY_ORGS

133:
134:
135: Cursor c_mstr_org(p_orgn_id Number, p_ec_code Varchar2) is
136: select organization_id , EXCISE_INVNO_AT_EC_CODE , location_id
137: from JAI_CMN_INVENTORY_ORGS
138: where organization_id = p_orgn_id
139: and ec_code = p_ec_code
140: and master_org_flag = 'Y';
141:

Line 145: from JAI_CMN_INVENTORY_ORGS

141:
142: --JMEENA for bug#7719911 FP of bug#7505975
143: Cursor c_master_trade_org is
144: Select tr_ec_code , master_org_flag , master_organization_id
145: from JAI_CMN_INVENTORY_ORGS
146: where organization_id = p_organization_id
147: and location_id = p_location_id;
148:
149:

Line 152: from JAI_CMN_INVENTORY_ORGS

148:
149:
150: Cursor c_trade_org(p_orgn_id Number, p_ec_code Varchar2) is
151: select organization_id , location_id
152: from JAI_CMN_INVENTORY_ORGS
153: where organization_id = p_orgn_id
154: and tr_ec_code = p_ec_code
155: and master_org_flag = 'Y';
156:

Line 405: FROM JAI_CMN_INVENTORY_ORGS A

401: AND register_code IS NULL
402: and (organization_id, location_id)
403: in
404: (SELECT A.Organization_Id, A.Location_Id
405: FROM JAI_CMN_INVENTORY_ORGS A
406: WHERE A.Ec_Code IN
407: (
408: SELECT B.Ec_Code
409: FROM JAI_CMN_INVENTORY_ORGS B

Line 409: FROM JAI_CMN_INVENTORY_ORGS B

405: FROM JAI_CMN_INVENTORY_ORGS A
406: WHERE A.Ec_Code IN
407: (
408: SELECT B.Ec_Code
409: FROM JAI_CMN_INVENTORY_ORGS B
410: WHERE B.Organization_Id = v_act_organization_id
411: AND B.Location_Id = v_act_location_id
412: )
413: );

Line 946: FROM JAI_CMN_INVENTORY_ORGS

942: WHERE UPPER(LOCATION_CODE) = UPPER(v_From_Whse) ;
943:
944: Cursor C_From_Org_Id ( v_loc_id IN Number ) Is
945: SELECT ORGANIZATION_ID
946: FROM JAI_CMN_INVENTORY_ORGS
947: WHERE LOCATION_ID = v_loc_id ;
948:
949: /* Vijay Shankar for Bug# 3151103
950: Cursor C_From_Org_code ( v_From_org_id In Number ) Is