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_REL_WF dependencies on MSC_GET_NAME

Line 248: msc_get_name.org_code(ms.organization_id,ms.sr_instance_id),

244:
245: Cursor po_attri IS
246: select mp.compile_designator,
247: msi.item_name,
248: msc_get_name.org_code(ms.organization_id,ms.sr_instance_id),
249: msc_get_name.supplier(ms.supplier_id),
250: DECODE(ms.order_type,5,to_char(ms.transaction_id),ms.order_number),
251: msc_get_name.lookup_meaning('MRP_ORDER_TYPE',ms.order_type),
252: ms.new_schedule_date,

Line 249: msc_get_name.supplier(ms.supplier_id),

245: Cursor po_attri IS
246: select mp.compile_designator,
247: msi.item_name,
248: msc_get_name.org_code(ms.organization_id,ms.sr_instance_id),
249: msc_get_name.supplier(ms.supplier_id),
250: DECODE(ms.order_type,5,to_char(ms.transaction_id),ms.order_number),
251: msc_get_name.lookup_meaning('MRP_ORDER_TYPE',ms.order_type),
252: ms.new_schedule_date,
253: ms.implement_date,

Line 251: msc_get_name.lookup_meaning('MRP_ORDER_TYPE',ms.order_type),

247: msi.item_name,
248: msc_get_name.org_code(ms.organization_id,ms.sr_instance_id),
249: msc_get_name.supplier(ms.supplier_id),
250: DECODE(ms.order_type,5,to_char(ms.transaction_id),ms.order_number),
251: msc_get_name.lookup_meaning('MRP_ORDER_TYPE',ms.order_type),
252: ms.new_schedule_date,
253: ms.implement_date,
254: ms.new_order_quantity,
255: msi.buyer_name

Line 418: msc_get_name.item_name(ms.inventory_item_id, null,null,null),

414: and mpc.partner_type =1;
415:
416: Cursor detail_attri IS
417: select mp.compile_designator,
418: msc_get_name.item_name(ms.inventory_item_id, null,null,null),
419: msc_get_name.org_code(ms.organization_id,ms.sr_instance_id),
420: DECODE(ms.order_type,5,to_char(ms.transaction_id),ms.order_number),
421: msc_get_name.lookup_meaning('MRP_ORDER_TYPE',ms.order_type),
422: ms.new_schedule_date,

Line 419: msc_get_name.org_code(ms.organization_id,ms.sr_instance_id),

415:
416: Cursor detail_attri IS
417: select mp.compile_designator,
418: msc_get_name.item_name(ms.inventory_item_id, null,null,null),
419: msc_get_name.org_code(ms.organization_id,ms.sr_instance_id),
420: DECODE(ms.order_type,5,to_char(ms.transaction_id),ms.order_number),
421: msc_get_name.lookup_meaning('MRP_ORDER_TYPE',ms.order_type),
422: ms.new_schedule_date,
423: ms.implement_date,

Line 421: msc_get_name.lookup_meaning('MRP_ORDER_TYPE',ms.order_type),

417: select mp.compile_designator,
418: msc_get_name.item_name(ms.inventory_item_id, null,null,null),
419: msc_get_name.org_code(ms.organization_id,ms.sr_instance_id),
420: DECODE(ms.order_type,5,to_char(ms.transaction_id),ms.order_number),
421: msc_get_name.lookup_meaning('MRP_ORDER_TYPE',ms.order_type),
422: ms.new_schedule_date,
423: ms.implement_date,
424: ms.new_order_quantity
425: from msc_plans mp,

Line 2460: select msc_get_name.org_code(s.organization_id,s.sr_instance_id),

2456: p_transaction_id in number,
2457: p_query_id in number,
2458: p_dblink in varchar2) IS
2459: cursor supply_cur IS
2460: select msc_get_name.org_code(s.organization_id,s.sr_instance_id),
2461: msc_get_name.supplier(s.supplier_id),
2462: msc_get_name.supplier_site(s.supplier_site_id),
2463: msc_get_name.lookup_meaning('MRP_ORDER_TYPE',s.order_type),
2464: DECODE(s.order_type,5,to_char(s.transaction_id),s.order_number),

Line 2461: msc_get_name.supplier(s.supplier_id),

2457: p_query_id in number,
2458: p_dblink in varchar2) IS
2459: cursor supply_cur IS
2460: select msc_get_name.org_code(s.organization_id,s.sr_instance_id),
2461: msc_get_name.supplier(s.supplier_id),
2462: msc_get_name.supplier_site(s.supplier_site_id),
2463: msc_get_name.lookup_meaning('MRP_ORDER_TYPE',s.order_type),
2464: DECODE(s.order_type,5,to_char(s.transaction_id),s.order_number),
2465: s.new_schedule_date,

Line 2462: msc_get_name.supplier_site(s.supplier_site_id),

2458: p_dblink in varchar2) IS
2459: cursor supply_cur IS
2460: select msc_get_name.org_code(s.organization_id,s.sr_instance_id),
2461: msc_get_name.supplier(s.supplier_id),
2462: msc_get_name.supplier_site(s.supplier_site_id),
2463: msc_get_name.lookup_meaning('MRP_ORDER_TYPE',s.order_type),
2464: DECODE(s.order_type,5,to_char(s.transaction_id),s.order_number),
2465: s.new_schedule_date,
2466: s.new_order_quantity,

Line 2463: msc_get_name.lookup_meaning('MRP_ORDER_TYPE',s.order_type),

2459: cursor supply_cur IS
2460: select msc_get_name.org_code(s.organization_id,s.sr_instance_id),
2461: msc_get_name.supplier(s.supplier_id),
2462: msc_get_name.supplier_site(s.supplier_site_id),
2463: msc_get_name.lookup_meaning('MRP_ORDER_TYPE',s.order_type),
2464: DECODE(s.order_type,5,to_char(s.transaction_id),s.order_number),
2465: s.new_schedule_date,
2466: s.new_order_quantity,
2467: mp.compile_designator,

Line 3414: msc_get_name.customer(md.customer_id) customer_name,

3410: cursor all_c is
3411: select msi.item_name,
3412: md.order_number,
3413: msi.description item_desc,
3414: msc_get_name.customer(md.customer_id) customer_name,
3415: msc_get_name.customer_site(md.customer_site_id) customer_site,
3416: msc_get_name.org_code(nvl(md.prev_subst_org, md.original_org_id),
3417: md.original_inst_id) org_code,
3418: msc_get_name.org_code(md.organization_id,md.sr_instance_id) to_org,

Line 3415: msc_get_name.customer_site(md.customer_site_id) customer_site,

3411: select msi.item_name,
3412: md.order_number,
3413: msi.description item_desc,
3414: msc_get_name.customer(md.customer_id) customer_name,
3415: msc_get_name.customer_site(md.customer_site_id) customer_site,
3416: msc_get_name.org_code(nvl(md.prev_subst_org, md.original_org_id),
3417: md.original_inst_id) org_code,
3418: msc_get_name.org_code(md.organization_id,md.sr_instance_id) to_org,
3419: msoi.schedule_ship_date new_ship_date,

Line 3416: msc_get_name.org_code(nvl(md.prev_subst_org, md.original_org_id),

3412: md.order_number,
3413: msi.description item_desc,
3414: msc_get_name.customer(md.customer_id) customer_name,
3415: msc_get_name.customer_site(md.customer_site_id) customer_site,
3416: msc_get_name.org_code(nvl(md.prev_subst_org, md.original_org_id),
3417: md.original_inst_id) org_code,
3418: msc_get_name.org_code(md.organization_id,md.sr_instance_id) to_org,
3419: msoi.schedule_ship_date new_ship_date,
3420: md.schedule_ship_date old_ship_date,

Line 3418: msc_get_name.org_code(md.organization_id,md.sr_instance_id) to_org,

3414: msc_get_name.customer(md.customer_id) customer_name,
3415: msc_get_name.customer_site(md.customer_site_id) customer_site,
3416: msc_get_name.org_code(nvl(md.prev_subst_org, md.original_org_id),
3417: md.original_inst_id) org_code,
3418: msc_get_name.org_code(md.organization_id,md.sr_instance_id) to_org,
3419: msoi.schedule_ship_date new_ship_date,
3420: md.schedule_ship_date old_ship_date,
3421: msoi.schedule_arrival_date new_arrival_date,
3422: md.schedule_arrival_date old_arrival_date,

Line 3436: msc_get_name.lookup_meaning('SYS_YES_NO',msoi.return_status) atp_override_flag,

3432: md.sr_instance_id,
3433: md.plan_id,
3434: mp.compile_designator plan_name,
3435: msoi.line_number line_number,
3436: msc_get_name.lookup_meaning('SYS_YES_NO',msoi.return_status) atp_override_flag,
3437: msc_get_name.item_name(nvl(md.prev_subst_item,md.original_item_id),
3438: null,null,null)
3439: orig_item_name,
3440: msc_get_name.item_desc(nvl(md.prev_subst_item,md.original_item_id),

Line 3437: msc_get_name.item_name(nvl(md.prev_subst_item,md.original_item_id),

3433: md.plan_id,
3434: mp.compile_designator plan_name,
3435: msoi.line_number line_number,
3436: msc_get_name.lookup_meaning('SYS_YES_NO',msoi.return_status) atp_override_flag,
3437: msc_get_name.item_name(nvl(md.prev_subst_item,md.original_item_id),
3438: null,null,null)
3439: orig_item_name,
3440: msc_get_name.item_desc(nvl(md.prev_subst_item,md.original_item_id),
3441: nvl(md.prev_subst_org, md.original_org_id),

Line 3440: msc_get_name.item_desc(nvl(md.prev_subst_item,md.original_item_id),

3436: msc_get_name.lookup_meaning('SYS_YES_NO',msoi.return_status) atp_override_flag,
3437: msc_get_name.item_name(nvl(md.prev_subst_item,md.original_item_id),
3438: null,null,null)
3439: orig_item_name,
3440: msc_get_name.item_desc(nvl(md.prev_subst_item,md.original_item_id),
3441: nvl(md.prev_subst_org, md.original_org_id),
3442: md.plan_id,md.original_inst_id)
3443: orig_item_desc
3444: from msc_system_items msi,