eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_WS_OTM_BPEL dependencies on MSC_SUP_DEM_ENTRIES

Line 190: from msc_sup_dem_entries

186:
187: --dbms_output.put_line('releaseNumber=' || releaseNumber);
188:
189: select count(*) into v_cnt
190: from msc_sup_dem_entries
191: where msc_sup_dem_entries.order_number = orderNumber
192: and msc_sup_dem_entries.line_number = lineNumber
193: and msc_sup_dem_entries.release_number = releaseNumber
194: and msc_sup_dem_entries.publisher_order_type in (13, 15);

Line 191: where msc_sup_dem_entries.order_number = orderNumber

187: --dbms_output.put_line('releaseNumber=' || releaseNumber);
188:
189: select count(*) into v_cnt
190: from msc_sup_dem_entries
191: where msc_sup_dem_entries.order_number = orderNumber
192: and msc_sup_dem_entries.line_number = lineNumber
193: and msc_sup_dem_entries.release_number = releaseNumber
194: and msc_sup_dem_entries.publisher_order_type in (13, 15);
195:

Line 192: and msc_sup_dem_entries.line_number = lineNumber

188:
189: select count(*) into v_cnt
190: from msc_sup_dem_entries
191: where msc_sup_dem_entries.order_number = orderNumber
192: and msc_sup_dem_entries.line_number = lineNumber
193: and msc_sup_dem_entries.release_number = releaseNumber
194: and msc_sup_dem_entries.publisher_order_type in (13, 15);
195:
196: if v_cnt = 0 then

Line 193: and msc_sup_dem_entries.release_number = releaseNumber

189: select count(*) into v_cnt
190: from msc_sup_dem_entries
191: where msc_sup_dem_entries.order_number = orderNumber
192: and msc_sup_dem_entries.line_number = lineNumber
193: and msc_sup_dem_entries.release_number = releaseNumber
194: and msc_sup_dem_entries.publisher_order_type in (13, 15);
195:
196: if v_cnt = 0 then
197: status := 'Order not in CP';

Line 194: and msc_sup_dem_entries.publisher_order_type in (13, 15);

190: from msc_sup_dem_entries
191: where msc_sup_dem_entries.order_number = orderNumber
192: and msc_sup_dem_entries.line_number = lineNumber
193: and msc_sup_dem_entries.release_number = releaseNumber
194: and msc_sup_dem_entries.publisher_order_type in (13, 15);
195:
196: if v_cnt = 0 then
197: status := 'Order not in CP';
198: return;

Line 214: update msc_sup_dem_entries

210: --dbms_output.put_line('v_old_key_date-' || v_old_key_date);
211:
212: --
213: if ( v_old_key_date <> arrivalDate ) then
214: update msc_sup_dem_entries
215: set key_date = arrivalDate,
216: receipt_date = arrivalDate,
217: LAST_UPDATE_DATE = SYSDATE,
218: LAST_UPDATED_BY = userId

Line 219: where msc_sup_dem_entries.order_number = orderNumber

215: set key_date = arrivalDate,
216: receipt_date = arrivalDate,
217: LAST_UPDATE_DATE = SYSDATE,
218: LAST_UPDATED_BY = userId
219: where msc_sup_dem_entries.order_number = orderNumber
220: and msc_sup_dem_entries.line_number = lineNumber
221: and msc_sup_dem_entries.release_number = releaseNumber
222: and msc_sup_dem_entries.last_refresh_number = v_last_refresh_number
223: and msc_sup_dem_entries.publisher_order_type in (13, 15)

Line 220: and msc_sup_dem_entries.line_number = lineNumber

216: receipt_date = arrivalDate,
217: LAST_UPDATE_DATE = SYSDATE,
218: LAST_UPDATED_BY = userId
219: where msc_sup_dem_entries.order_number = orderNumber
220: and msc_sup_dem_entries.line_number = lineNumber
221: and msc_sup_dem_entries.release_number = releaseNumber
222: and msc_sup_dem_entries.last_refresh_number = v_last_refresh_number
223: and msc_sup_dem_entries.publisher_order_type in (13, 15)
224: and msc_sup_dem_entries.plan_id = -1;

Line 221: and msc_sup_dem_entries.release_number = releaseNumber

217: LAST_UPDATE_DATE = SYSDATE,
218: LAST_UPDATED_BY = userId
219: where msc_sup_dem_entries.order_number = orderNumber
220: and msc_sup_dem_entries.line_number = lineNumber
221: and msc_sup_dem_entries.release_number = releaseNumber
222: and msc_sup_dem_entries.last_refresh_number = v_last_refresh_number
223: and msc_sup_dem_entries.publisher_order_type in (13, 15)
224: and msc_sup_dem_entries.plan_id = -1;
225:

Line 222: and msc_sup_dem_entries.last_refresh_number = v_last_refresh_number

218: LAST_UPDATED_BY = userId
219: where msc_sup_dem_entries.order_number = orderNumber
220: and msc_sup_dem_entries.line_number = lineNumber
221: and msc_sup_dem_entries.release_number = releaseNumber
222: and msc_sup_dem_entries.last_refresh_number = v_last_refresh_number
223: and msc_sup_dem_entries.publisher_order_type in (13, 15)
224: and msc_sup_dem_entries.plan_id = -1;
225:
226: /*dbms_output.put_line('arrivalDate= ' || arrivalDate || ' orderNumber=' || orderNumber||

Line 223: and msc_sup_dem_entries.publisher_order_type in (13, 15)

219: where msc_sup_dem_entries.order_number = orderNumber
220: and msc_sup_dem_entries.line_number = lineNumber
221: and msc_sup_dem_entries.release_number = releaseNumber
222: and msc_sup_dem_entries.last_refresh_number = v_last_refresh_number
223: and msc_sup_dem_entries.publisher_order_type in (13, 15)
224: and msc_sup_dem_entries.plan_id = -1;
225:
226: /*dbms_output.put_line('arrivalDate= ' || arrivalDate || ' orderNumber=' || orderNumber||
227: ' lineNumber=' || lineNumber || ' releaseNumber= ' || releaseNumber ||

Line 224: and msc_sup_dem_entries.plan_id = -1;

220: and msc_sup_dem_entries.line_number = lineNumber
221: and msc_sup_dem_entries.release_number = releaseNumber
222: and msc_sup_dem_entries.last_refresh_number = v_last_refresh_number
223: and msc_sup_dem_entries.publisher_order_type in (13, 15)
224: and msc_sup_dem_entries.plan_id = -1;
225:
226: /*dbms_output.put_line('arrivalDate= ' || arrivalDate || ' orderNumber=' || orderNumber||
227: ' lineNumber=' || lineNumber || ' releaseNumber= ' || releaseNumber ||
228: ' v_last_refresh_number=' || v_last_refresh_number);*/

Line 276: msc_sup_dem_entries

272: cursor get_last(orN VARCHAR2, lN VARCHAR2, rN VARCHAR2) is
273: SELECT
274: last_refresh_number
275: FROM
276: msc_sup_dem_entries
277: WHERE
278: msc_sup_dem_entries.order_number = orN
279: and msc_sup_dem_entries.line_number = lN
280: and msc_sup_dem_entries.release_number = rN

Line 278: msc_sup_dem_entries.order_number = orN

274: last_refresh_number
275: FROM
276: msc_sup_dem_entries
277: WHERE
278: msc_sup_dem_entries.order_number = orN
279: and msc_sup_dem_entries.line_number = lN
280: and msc_sup_dem_entries.release_number = rN
281: ORDER BY last_refresh_number DESC;
282:

Line 279: and msc_sup_dem_entries.line_number = lN

275: FROM
276: msc_sup_dem_entries
277: WHERE
278: msc_sup_dem_entries.order_number = orN
279: and msc_sup_dem_entries.line_number = lN
280: and msc_sup_dem_entries.release_number = rN
281: ORDER BY last_refresh_number DESC;
282:
283: begin

Line 280: and msc_sup_dem_entries.release_number = rN

276: msc_sup_dem_entries
277: WHERE
278: msc_sup_dem_entries.order_number = orN
279: and msc_sup_dem_entries.line_number = lN
280: and msc_sup_dem_entries.release_number = rN
281: ORDER BY last_refresh_number DESC;
282:
283: begin
284: -- don't loop , bring just the first element

Line 303: msc_sup_dem_entries

299: begin
300: SELECT
301: key_date into v_old_key_date
302: FROM
303: msc_sup_dem_entries
304: WHERE
305: msc_sup_dem_entries.order_number = orderNumber
306: and msc_sup_dem_entries.line_number = lineNumber
307: and msc_sup_dem_entries.release_number = releaseNumber

Line 305: msc_sup_dem_entries.order_number = orderNumber

301: key_date into v_old_key_date
302: FROM
303: msc_sup_dem_entries
304: WHERE
305: msc_sup_dem_entries.order_number = orderNumber
306: and msc_sup_dem_entries.line_number = lineNumber
307: and msc_sup_dem_entries.release_number = releaseNumber
308: and msc_sup_dem_entries.last_refresh_number = lastRefreshNumber;
309:

Line 306: and msc_sup_dem_entries.line_number = lineNumber

302: FROM
303: msc_sup_dem_entries
304: WHERE
305: msc_sup_dem_entries.order_number = orderNumber
306: and msc_sup_dem_entries.line_number = lineNumber
307: and msc_sup_dem_entries.release_number = releaseNumber
308: and msc_sup_dem_entries.last_refresh_number = lastRefreshNumber;
309:
310: return v_old_key_date;

Line 307: and msc_sup_dem_entries.release_number = releaseNumber

303: msc_sup_dem_entries
304: WHERE
305: msc_sup_dem_entries.order_number = orderNumber
306: and msc_sup_dem_entries.line_number = lineNumber
307: and msc_sup_dem_entries.release_number = releaseNumber
308: and msc_sup_dem_entries.last_refresh_number = lastRefreshNumber;
309:
310: return v_old_key_date;
311: end getKeyDate;

Line 308: and msc_sup_dem_entries.last_refresh_number = lastRefreshNumber;

304: WHERE
305: msc_sup_dem_entries.order_number = orderNumber
306: and msc_sup_dem_entries.line_number = lineNumber
307: and msc_sup_dem_entries.release_number = releaseNumber
308: and msc_sup_dem_entries.last_refresh_number = lastRefreshNumber;
309:
310: return v_old_key_date;
311: end getKeyDate;
312: