APPS.GMD_QCR05USR_XMLP_PKG dependencies on MTL_MATERIAL_STATUSES

Line 214: -- 14779924 get from id from R12 table MTL_MATERIAL_STATUSES

210: IF TO_LOTSTATUS IS NULL THEN
211: RETURN (' ');
212: END IF;
213: ELSE
214: -- 14779924 get from id from R12 table MTL_MATERIAL_STATUSES
215: SELECT
216: STATUS_ID
217: INTO L_FROM_STATUS_ID
218: FROM

Line 219: MTL_MATERIAL_STATUSES

215: SELECT
216: STATUS_ID
217: INTO L_FROM_STATUS_ID
218: FROM
219: MTL_MATERIAL_STATUSES
220: WHERE STATUS_CODE = FROM_LOTSTATUS;
221:
222: IF TO_LOTSTATUS IS NULL THEN
223: RETURN (' AND stat.status_code >= ''' || FROM_LOTSTATUS || ''''); -- -- 14779924

Line 227: -- 14779924 get to id from R12 table MTL_MATERIAL_STATUSES

223: RETURN (' AND stat.status_code >= ''' || FROM_LOTSTATUS || ''''); -- -- 14779924
224: --RETURN (' AND mln.status_id >= ''' || L_FROM_STATUS_ID || ''''); -- -- 14779924
225: --RETURN (' AND mln.status_id >= ''' || FROM_LOTSTATUS || '''');
226: ELSE
227: -- 14779924 get to id from R12 table MTL_MATERIAL_STATUSES
228: SELECT
229: STATUS_ID
230: INTO L_TO_STATUS_ID
231: FROM

Line 232: MTL_MATERIAL_STATUSES

228: SELECT
229: STATUS_ID
230: INTO L_TO_STATUS_ID
231: FROM
232: MTL_MATERIAL_STATUSES
233: WHERE STATUS_CODE = TO_LOTSTATUS;
234: RETURN (' AND stat.status_code >=''' || FROM_LOTSTATUS || ''' and stat.status_code <=''' || TO_LOTSTATUS || ''''); -- -- 14779924
235: --RETURN (' AND mln.status_id >=''' || L_FROM_STATUS_ID || ''' and mln.status_id <=''' || L_TO_STATUS_ID || ''''); -- -- 14779924
236: --RETURN (' AND mln.status_id >=''' || FROM_LOTSTATUS || ''' and mln.status_id <=''' || TO_LOTSTATUS || '''');