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 202: from msc_sup_dem_entries

198:
199: lineNumber := v_line_Number; -- number to chars conversion
200:
201: select count(*) into v_cnt
202: from msc_sup_dem_entries
203: where msc_sup_dem_entries.order_number = to_char(orderNumber)
204: and msc_sup_dem_entries.line_number = to_number(lineNumber)
205: -- and msc_sup_dem_entries.release_number = releaseNumber
206: and msc_sup_dem_entries.publisher_order_type in (13, 15);

Line 203: where msc_sup_dem_entries.order_number = to_char(orderNumber)

199: lineNumber := v_line_Number; -- number to chars conversion
200:
201: select count(*) into v_cnt
202: from msc_sup_dem_entries
203: where msc_sup_dem_entries.order_number = to_char(orderNumber)
204: and msc_sup_dem_entries.line_number = to_number(lineNumber)
205: -- and msc_sup_dem_entries.release_number = releaseNumber
206: and msc_sup_dem_entries.publisher_order_type in (13, 15);
207:

Line 204: and msc_sup_dem_entries.line_number = to_number(lineNumber)

200:
201: select count(*) into v_cnt
202: from msc_sup_dem_entries
203: where msc_sup_dem_entries.order_number = to_char(orderNumber)
204: and msc_sup_dem_entries.line_number = to_number(lineNumber)
205: -- and msc_sup_dem_entries.release_number = releaseNumber
206: and msc_sup_dem_entries.publisher_order_type in (13, 15);
207:
208:

Line 205: -- and msc_sup_dem_entries.release_number = releaseNumber

201: select count(*) into v_cnt
202: from msc_sup_dem_entries
203: where msc_sup_dem_entries.order_number = to_char(orderNumber)
204: and msc_sup_dem_entries.line_number = to_number(lineNumber)
205: -- and msc_sup_dem_entries.release_number = releaseNumber
206: and msc_sup_dem_entries.publisher_order_type in (13, 15);
207:
208:
209: if v_cnt = 0 then

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

202: from msc_sup_dem_entries
203: where msc_sup_dem_entries.order_number = to_char(orderNumber)
204: and msc_sup_dem_entries.line_number = to_number(lineNumber)
205: -- and msc_sup_dem_entries.release_number = releaseNumber
206: and msc_sup_dem_entries.publisher_order_type in (13, 15);
207:
208:
209: if v_cnt = 0 then
210: status := 'Order not in CP';

Line 224: update msc_sup_dem_entries

220:
221: v_old_key_date := getKeyDate(orderNumber, lineNumber, releaseNumber, v_last_refresh_number);
222:
223: if ( v_old_key_date <> arrivalDate ) then
224: update msc_sup_dem_entries
225: set key_date = arrivalDate,
226: receipt_date = arrivalDate,
227: LAST_UPDATE_DATE = SYSDATE,
228: LAST_UPDATED_BY = userId

Line 229: where msc_sup_dem_entries.order_number = orderNumber

225: set key_date = arrivalDate,
226: receipt_date = arrivalDate,
227: LAST_UPDATE_DATE = SYSDATE,
228: LAST_UPDATED_BY = userId
229: where msc_sup_dem_entries.order_number = orderNumber
230: and msc_sup_dem_entries.line_number = lineNumber
231: -- and msc_sup_dem_entries.release_number = releaseNumber
232: and msc_sup_dem_entries.last_refresh_number = v_last_refresh_number
233: and msc_sup_dem_entries.publisher_order_type in (13, 15)

Line 230: and msc_sup_dem_entries.line_number = lineNumber

226: receipt_date = arrivalDate,
227: LAST_UPDATE_DATE = SYSDATE,
228: LAST_UPDATED_BY = userId
229: where msc_sup_dem_entries.order_number = orderNumber
230: and msc_sup_dem_entries.line_number = lineNumber
231: -- and msc_sup_dem_entries.release_number = releaseNumber
232: and msc_sup_dem_entries.last_refresh_number = v_last_refresh_number
233: and msc_sup_dem_entries.publisher_order_type in (13, 15)
234: and msc_sup_dem_entries.plan_id = -1;

Line 231: -- and msc_sup_dem_entries.release_number = releaseNumber

227: LAST_UPDATE_DATE = SYSDATE,
228: LAST_UPDATED_BY = userId
229: where msc_sup_dem_entries.order_number = orderNumber
230: and msc_sup_dem_entries.line_number = lineNumber
231: -- and msc_sup_dem_entries.release_number = releaseNumber
232: and msc_sup_dem_entries.last_refresh_number = v_last_refresh_number
233: and msc_sup_dem_entries.publisher_order_type in (13, 15)
234: and msc_sup_dem_entries.plan_id = -1;
235:

Line 232: and msc_sup_dem_entries.last_refresh_number = v_last_refresh_number

228: LAST_UPDATED_BY = userId
229: where msc_sup_dem_entries.order_number = orderNumber
230: and msc_sup_dem_entries.line_number = lineNumber
231: -- and msc_sup_dem_entries.release_number = releaseNumber
232: and msc_sup_dem_entries.last_refresh_number = v_last_refresh_number
233: and msc_sup_dem_entries.publisher_order_type in (13, 15)
234: and msc_sup_dem_entries.plan_id = -1;
235:
236: -- dbms_output.put_line('arrivalDate= ' || arrivalDate || ' orderNumber=' || orderNumber||

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

229: where msc_sup_dem_entries.order_number = orderNumber
230: and msc_sup_dem_entries.line_number = lineNumber
231: -- and msc_sup_dem_entries.release_number = releaseNumber
232: and msc_sup_dem_entries.last_refresh_number = v_last_refresh_number
233: and msc_sup_dem_entries.publisher_order_type in (13, 15)
234: and msc_sup_dem_entries.plan_id = -1;
235:
236: -- dbms_output.put_line('arrivalDate= ' || arrivalDate || ' orderNumber=' || orderNumber||
237: -- ' lineNumber=' || lineNumber || ' releaseNumber= ' || releaseNumber ||

Line 234: and msc_sup_dem_entries.plan_id = -1;

230: and msc_sup_dem_entries.line_number = lineNumber
231: -- and msc_sup_dem_entries.release_number = releaseNumber
232: and msc_sup_dem_entries.last_refresh_number = v_last_refresh_number
233: and msc_sup_dem_entries.publisher_order_type in (13, 15)
234: and msc_sup_dem_entries.plan_id = -1;
235:
236: -- dbms_output.put_line('arrivalDate= ' || arrivalDate || ' orderNumber=' || orderNumber||
237: -- ' lineNumber=' || lineNumber || ' releaseNumber= ' || releaseNumber ||
238: -- ' v_last_refresh_number=' || v_last_refresh_number);

Line 300: msc_sup_dem_entries

296: cursor get_last(orN VARCHAR2, lN VARCHAR2) is
297: SELECT
298: last_refresh_number
299: FROM
300: msc_sup_dem_entries
301: WHERE
302: msc_sup_dem_entries.order_number = orN
303: and msc_sup_dem_entries.line_number = lN
304: -- and msc_sup_dem_entries.release_number = rN

Line 302: msc_sup_dem_entries.order_number = orN

298: last_refresh_number
299: FROM
300: msc_sup_dem_entries
301: WHERE
302: msc_sup_dem_entries.order_number = orN
303: and msc_sup_dem_entries.line_number = lN
304: -- and msc_sup_dem_entries.release_number = rN
305: ORDER BY last_refresh_number DESC;
306:

Line 303: and msc_sup_dem_entries.line_number = lN

299: FROM
300: msc_sup_dem_entries
301: WHERE
302: msc_sup_dem_entries.order_number = orN
303: and msc_sup_dem_entries.line_number = lN
304: -- and msc_sup_dem_entries.release_number = rN
305: ORDER BY last_refresh_number DESC;
306:
307: begin

Line 304: -- and msc_sup_dem_entries.release_number = rN

300: msc_sup_dem_entries
301: WHERE
302: msc_sup_dem_entries.order_number = orN
303: and msc_sup_dem_entries.line_number = lN
304: -- and msc_sup_dem_entries.release_number = rN
305: ORDER BY last_refresh_number DESC;
306:
307: begin
308: -- don't loop , bring just the first element

Line 328: msc_sup_dem_entries

324: begin
325: SELECT
326: key_date into v_old_key_date
327: FROM
328: msc_sup_dem_entries
329: WHERE
330: msc_sup_dem_entries.order_number = orderNumber
331: and msc_sup_dem_entries.line_number = lineNumber
332: --and msc_sup_dem_entries.release_number = releaseNumber

Line 330: msc_sup_dem_entries.order_number = orderNumber

326: key_date into v_old_key_date
327: FROM
328: msc_sup_dem_entries
329: WHERE
330: msc_sup_dem_entries.order_number = orderNumber
331: and msc_sup_dem_entries.line_number = lineNumber
332: --and msc_sup_dem_entries.release_number = releaseNumber
333: and msc_sup_dem_entries.last_refresh_number = lastRefreshNumber;
334:

Line 331: and msc_sup_dem_entries.line_number = lineNumber

327: FROM
328: msc_sup_dem_entries
329: WHERE
330: msc_sup_dem_entries.order_number = orderNumber
331: and msc_sup_dem_entries.line_number = lineNumber
332: --and msc_sup_dem_entries.release_number = releaseNumber
333: and msc_sup_dem_entries.last_refresh_number = lastRefreshNumber;
334:
335: return v_old_key_date;

Line 332: --and msc_sup_dem_entries.release_number = releaseNumber

328: msc_sup_dem_entries
329: WHERE
330: msc_sup_dem_entries.order_number = orderNumber
331: and msc_sup_dem_entries.line_number = lineNumber
332: --and msc_sup_dem_entries.release_number = releaseNumber
333: and msc_sup_dem_entries.last_refresh_number = lastRefreshNumber;
334:
335: return v_old_key_date;
336: end getKeyDate;

Line 333: and msc_sup_dem_entries.last_refresh_number = lastRefreshNumber;

329: WHERE
330: msc_sup_dem_entries.order_number = orderNumber
331: and msc_sup_dem_entries.line_number = lineNumber
332: --and msc_sup_dem_entries.release_number = releaseNumber
333: and msc_sup_dem_entries.last_refresh_number = lastRefreshNumber;
334:
335: return v_old_key_date;
336: end getKeyDate;
337: