APPS.JAI_CMN_SETUP_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 41: from jai_cmn_inventory_orgs

37: /*added by vkaranam for bug #6030615*/
38: --start
39: cursor c_org_type (cp_organization_id in number , cp_location_id in number ) IS
40: select manufacturing , trading
41: from jai_cmn_inventory_orgs
42: where organization_id = cp_organization_id
43: and location_id = cp_location_id;
44:
45: r_org_type c_org_type%rowtype;

Line 87: FROM JAI_CMN_INVENTORY_ORGS A

83: for update;
84:
85: CURSOR c_Tr_ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
86: SELECT A.Organization_Id, A.Location_Id
87: FROM JAI_CMN_INVENTORY_ORGS A
88: WHERE A.Tr_Ec_Code IN
89: (
90: SELECT B.Tr_Ec_Code
91: FROM JAI_CMN_INVENTORY_ORGS B

Line 91: FROM JAI_CMN_INVENTORY_ORGS B

87: FROM JAI_CMN_INVENTORY_ORGS A
88: WHERE A.Tr_Ec_Code IN
89: (
90: SELECT B.Tr_Ec_Code
91: FROM JAI_CMN_INVENTORY_ORGS B
92: WHERE B.Organization_Id = p_organization_id
93: AND B.Location_Id = p_location_id
94: );
95:

Line 101: FROM JAI_CMN_INVENTORY_ORGS A

97: --AND nvl(EXCISE_INVNO_AT_EC_CODE, 'N') = 'Y' --Added by nprashar for bug # 7319628;
98: */
99: CURSOR c_ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
100: SELECT A.Organization_Id, A.Location_Id
101: FROM JAI_CMN_INVENTORY_ORGS A
102: WHERE A.Ec_Code IN
103: (
104: SELECT B.Ec_Code
105: FROM JAI_CMN_INVENTORY_ORGS B

Line 105: FROM JAI_CMN_INVENTORY_ORGS B

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

Line 124: from JAI_CMN_INVENTORY_ORGS

120:
121:
122: Cursor c_master_org is
123: Select ec_code , master_org_flag , master_organization_id, EXCISE_INVNO_AT_EC_CODE
124: from JAI_CMN_INVENTORY_ORGS
125: where organization_id = p_organization_id
126: and location_id = p_location_id;
127:
128:

Line 131: from JAI_CMN_INVENTORY_ORGS

127:
128:
129: Cursor c_mstr_org(p_orgn_id Number, p_ec_code Varchar2) is
130: select organization_id , EXCISE_INVNO_AT_EC_CODE , location_id
131: from JAI_CMN_INVENTORY_ORGS
132: where organization_id = p_orgn_id
133: and ec_code = p_ec_code
134: and master_org_flag = 'Y';
135:

Line 139: from JAI_CMN_INVENTORY_ORGS

135:
136: --JMEENA for bug#7719911 FP of bug#7505975
137: Cursor c_master_trade_org is
138: Select tr_ec_code , master_org_flag , master_organization_id
139: from JAI_CMN_INVENTORY_ORGS
140: where organization_id = p_organization_id
141: and location_id = p_location_id;
142:
143:

Line 146: from JAI_CMN_INVENTORY_ORGS

142:
143:
144: Cursor c_trade_org(p_orgn_id Number, p_ec_code Varchar2) is
145: select organization_id , location_id
146: from JAI_CMN_INVENTORY_ORGS
147: where organization_id = p_orgn_id
148: and tr_ec_code = p_ec_code
149: and master_org_flag = 'Y';
150:

Line 380: FROM JAI_CMN_INVENTORY_ORGS A

376: AND register_code IS NULL
377: and (organization_id, location_id)
378: in
379: (SELECT A.Organization_Id, A.Location_Id
380: FROM JAI_CMN_INVENTORY_ORGS A
381: WHERE A.Ec_Code IN
382: (
383: SELECT B.Ec_Code
384: FROM JAI_CMN_INVENTORY_ORGS B

Line 384: FROM JAI_CMN_INVENTORY_ORGS B

380: FROM JAI_CMN_INVENTORY_ORGS A
381: WHERE A.Ec_Code IN
382: (
383: SELECT B.Ec_Code
384: FROM JAI_CMN_INVENTORY_ORGS B
385: WHERE B.Organization_Id = v_act_organization_id
386: AND B.Location_Id = v_act_location_id
387: )
388: );

Line 891: FROM JAI_CMN_INVENTORY_ORGS

887: WHERE UPPER(LOCATION_CODE) = UPPER(v_From_Whse) ;
888:
889: Cursor C_From_Org_Id ( v_loc_id IN Number ) Is
890: SELECT ORGANIZATION_ID
891: FROM JAI_CMN_INVENTORY_ORGS
892: WHERE LOCATION_ID = v_loc_id ;
893:
894: /* Vijay Shankar for Bug# 3151103
895: Cursor C_From_Org_code ( v_From_org_id In Number ) Is