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_X_WFNOTIFY_PKG dependencies on MSC_SUP_DEM_ENTRIES

Line 257: l_company_name msc_sup_dem_entries.publisher_name%type;

253: l_real_name Varchar2(240);
254: l_exception_detail_id Number;
255: l_sr_instance_id Number;
256: l_company_id Number;
257: l_company_name msc_sup_dem_entries.publisher_name%type;
258: l_company_site_id Number;
259: l_company_site_name msc_sup_dem_entries.publisher_site_name%type;
260: l_item_id Number;
261: l_item_name msc_items.item_name%type;

Line 259: l_company_site_name msc_sup_dem_entries.publisher_site_name%type;

255: l_sr_instance_id Number;
256: l_company_id Number;
257: l_company_name msc_sup_dem_entries.publisher_name%type;
258: l_company_site_id Number;
259: l_company_site_name msc_sup_dem_entries.publisher_site_name%type;
260: l_item_id Number;
261: l_item_name msc_items.item_name%type;
262: l_item_desc msc_x_exception_details.item_description%type;
263: l_exception_group Number;

Line 267: l_supplier_name msc_sup_dem_entries.supplier_name%type;

263: l_exception_group Number;
264: l_exception_type Number;
265: l_exception_type_name fnd_lookup_values.meaning%type;
266: l_supplier_id Number;
267: l_supplier_name msc_sup_dem_entries.supplier_name%type;
268: l_supplier_site_id Number;
269: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
270: l_supplier_item_name msc_sup_dem_entries.trading_partner_item_name%type;
271: l_customer_id Number;

Line 269: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;

265: l_exception_type_name fnd_lookup_values.meaning%type;
266: l_supplier_id Number;
267: l_supplier_name msc_sup_dem_entries.supplier_name%type;
268: l_supplier_site_id Number;
269: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
270: l_supplier_item_name msc_sup_dem_entries.trading_partner_item_name%type;
271: l_customer_id Number;
272: l_customer_name msc_sup_dem_entries.customer_name%type;
273: l_customer_site_id Number;

Line 270: l_supplier_item_name msc_sup_dem_entries.trading_partner_item_name%type;

266: l_supplier_id Number;
267: l_supplier_name msc_sup_dem_entries.supplier_name%type;
268: l_supplier_site_id Number;
269: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
270: l_supplier_item_name msc_sup_dem_entries.trading_partner_item_name%type;
271: l_customer_id Number;
272: l_customer_name msc_sup_dem_entries.customer_name%type;
273: l_customer_site_id Number;
274: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;

Line 272: l_customer_name msc_sup_dem_entries.customer_name%type;

268: l_supplier_site_id Number;
269: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
270: l_supplier_item_name msc_sup_dem_entries.trading_partner_item_name%type;
271: l_customer_id Number;
272: l_customer_name msc_sup_dem_entries.customer_name%type;
273: l_customer_site_id Number;
274: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
275: l_customer_item_name msc_sup_dem_entries.trading_partner_item_name%type;
276: l_order_number msc_sup_dem_entries.order_number%type;

Line 274: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;

270: l_supplier_item_name msc_sup_dem_entries.trading_partner_item_name%type;
271: l_customer_id Number;
272: l_customer_name msc_sup_dem_entries.customer_name%type;
273: l_customer_site_id Number;
274: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
275: l_customer_item_name msc_sup_dem_entries.trading_partner_item_name%type;
276: l_order_number msc_sup_dem_entries.order_number%type;
277: l_release_number msc_sup_dem_entries.release_number%type;
278: l_line_number msc_sup_dem_entries.line_number%type;

Line 275: l_customer_item_name msc_sup_dem_entries.trading_partner_item_name%type;

271: l_customer_id Number;
272: l_customer_name msc_sup_dem_entries.customer_name%type;
273: l_customer_site_id Number;
274: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
275: l_customer_item_name msc_sup_dem_entries.trading_partner_item_name%type;
276: l_order_number msc_sup_dem_entries.order_number%type;
277: l_release_number msc_sup_dem_entries.release_number%type;
278: l_line_number msc_sup_dem_entries.line_number%type;
279: l_end_order_number msc_sup_dem_entries.end_order_number%type;

Line 276: l_order_number msc_sup_dem_entries.order_number%type;

272: l_customer_name msc_sup_dem_entries.customer_name%type;
273: l_customer_site_id Number;
274: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
275: l_customer_item_name msc_sup_dem_entries.trading_partner_item_name%type;
276: l_order_number msc_sup_dem_entries.order_number%type;
277: l_release_number msc_sup_dem_entries.release_number%type;
278: l_line_number msc_sup_dem_entries.line_number%type;
279: l_end_order_number msc_sup_dem_entries.end_order_number%type;
280: l_end_order_rel_number msc_sup_dem_entries.end_order_rel_number%type;

Line 277: l_release_number msc_sup_dem_entries.release_number%type;

273: l_customer_site_id Number;
274: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
275: l_customer_item_name msc_sup_dem_entries.trading_partner_item_name%type;
276: l_order_number msc_sup_dem_entries.order_number%type;
277: l_release_number msc_sup_dem_entries.release_number%type;
278: l_line_number msc_sup_dem_entries.line_number%type;
279: l_end_order_number msc_sup_dem_entries.end_order_number%type;
280: l_end_order_rel_number msc_sup_dem_entries.end_order_rel_number%type;
281: l_end_order_line_number msc_sup_dem_entries.end_order_line_number%type;

Line 278: l_line_number msc_sup_dem_entries.line_number%type;

274: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
275: l_customer_item_name msc_sup_dem_entries.trading_partner_item_name%type;
276: l_order_number msc_sup_dem_entries.order_number%type;
277: l_release_number msc_sup_dem_entries.release_number%type;
278: l_line_number msc_sup_dem_entries.line_number%type;
279: l_end_order_number msc_sup_dem_entries.end_order_number%type;
280: l_end_order_rel_number msc_sup_dem_entries.end_order_rel_number%type;
281: l_end_order_line_number msc_sup_dem_entries.end_order_line_number%type;
282: l_quantity Number;

Line 279: l_end_order_number msc_sup_dem_entries.end_order_number%type;

275: l_customer_item_name msc_sup_dem_entries.trading_partner_item_name%type;
276: l_order_number msc_sup_dem_entries.order_number%type;
277: l_release_number msc_sup_dem_entries.release_number%type;
278: l_line_number msc_sup_dem_entries.line_number%type;
279: l_end_order_number msc_sup_dem_entries.end_order_number%type;
280: l_end_order_rel_number msc_sup_dem_entries.end_order_rel_number%type;
281: l_end_order_line_number msc_sup_dem_entries.end_order_line_number%type;
282: l_quantity Number;
283: l_transaction_id1 Number;

Line 280: l_end_order_rel_number msc_sup_dem_entries.end_order_rel_number%type;

276: l_order_number msc_sup_dem_entries.order_number%type;
277: l_release_number msc_sup_dem_entries.release_number%type;
278: l_line_number msc_sup_dem_entries.line_number%type;
279: l_end_order_number msc_sup_dem_entries.end_order_number%type;
280: l_end_order_rel_number msc_sup_dem_entries.end_order_rel_number%type;
281: l_end_order_line_number msc_sup_dem_entries.end_order_line_number%type;
282: l_quantity Number;
283: l_transaction_id1 Number;
284: l_transaction_id2 Number;

Line 281: l_end_order_line_number msc_sup_dem_entries.end_order_line_number%type;

277: l_release_number msc_sup_dem_entries.release_number%type;
278: l_line_number msc_sup_dem_entries.line_number%type;
279: l_end_order_number msc_sup_dem_entries.end_order_number%type;
280: l_end_order_rel_number msc_sup_dem_entries.end_order_rel_number%type;
281: l_end_order_line_number msc_sup_dem_entries.end_order_line_number%type;
282: l_quantity Number;
283: l_transaction_id1 Number;
284: l_transaction_id2 Number;
285: l_quantity1 Number;

Line 1374: FROM msc_sup_dem_entries sd

1370: sd.customer_id,
1371: sd.customer_name,
1372: sd.customer_site_id,
1373: sd.customer_site_name
1374: FROM msc_sup_dem_entries sd
1375: WHERE sd.publisher_order_type = p_publish_program_type and
1376: sd.plan_id = -1 and
1377: sd.publisher_id = 1 and
1378: exists (select cs.company_site_id

Line 1458: FROM msc_sup_dem_entries sd

1454:
1455: SELECT distinct sd.inventory_item_id,
1456: sd.item_name,
1457: sd.item_description
1458: FROM msc_sup_dem_entries sd
1459: WHERE sd.publisher_order_type = 2 and
1460: sd.plan_id = -1 and
1461: sd.publisher_id = p_company_id and
1462: sd.publisher_site_id = p_company_site_id and

Line 1504: FROM msc_sup_dem_entries sd

1500: sd.customer_id,
1501: sd.customer_name,
1502: sd.customer_site_id,
1503: sd.customer_site_name
1504: FROM msc_sup_dem_entries sd
1505: WHERE sd.publisher_order_type = p_publish_program_type and
1506: sd.plan_id = -1 and
1507: sd.publisher_id = 1 and
1508: sd.publisher_site_id IN (select cs.company_site_id

Line 1579: FROM msc_sup_dem_entries sd

1575:
1576: SELECT distinct sd.inventory_item_id,
1577: sd.item_name,
1578: sd.item_description
1579: FROM msc_sup_dem_entries sd
1580: WHERE sd.publisher_order_type = 3 and
1581: sd.plan_id = -1 and
1582: sd.publisher_id = p_company_id and
1583: sd.publisher_site_id = p_company_site_id and