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 2209: select msc_get_name.org_code(s.organization_id,s.sr_instance_id),

2205: p_transaction_id in number,
2206: p_query_id in number,
2207: p_dblink in varchar2) IS
2208: cursor supply_cur IS
2209: select msc_get_name.org_code(s.organization_id,s.sr_instance_id),
2210: msc_get_name.supplier(s.supplier_id),
2211: msc_get_name.supplier_site(s.supplier_site_id),
2212: msc_get_name.lookup_meaning('MRP_ORDER_TYPE',s.order_type),
2213: DECODE(s.order_type,5,to_char(s.transaction_id),s.order_number),

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

2206: p_query_id in number,
2207: p_dblink in varchar2) IS
2208: cursor supply_cur IS
2209: select msc_get_name.org_code(s.organization_id,s.sr_instance_id),
2210: msc_get_name.supplier(s.supplier_id),
2211: msc_get_name.supplier_site(s.supplier_site_id),
2212: msc_get_name.lookup_meaning('MRP_ORDER_TYPE',s.order_type),
2213: DECODE(s.order_type,5,to_char(s.transaction_id),s.order_number),
2214: s.new_schedule_date,

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

2207: p_dblink in varchar2) IS
2208: cursor supply_cur IS
2209: select msc_get_name.org_code(s.organization_id,s.sr_instance_id),
2210: msc_get_name.supplier(s.supplier_id),
2211: msc_get_name.supplier_site(s.supplier_site_id),
2212: msc_get_name.lookup_meaning('MRP_ORDER_TYPE',s.order_type),
2213: DECODE(s.order_type,5,to_char(s.transaction_id),s.order_number),
2214: s.new_schedule_date,
2215: s.new_order_quantity,

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

2208: cursor supply_cur IS
2209: select msc_get_name.org_code(s.organization_id,s.sr_instance_id),
2210: msc_get_name.supplier(s.supplier_id),
2211: msc_get_name.supplier_site(s.supplier_site_id),
2212: msc_get_name.lookup_meaning('MRP_ORDER_TYPE',s.order_type),
2213: DECODE(s.order_type,5,to_char(s.transaction_id),s.order_number),
2214: s.new_schedule_date,
2215: s.new_order_quantity,
2216: mp.compile_designator,

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

3131: cursor all_c is
3132: select msi.item_name,
3133: md.order_number,
3134: msi.description item_desc,
3135: msc_get_name.customer(md.customer_id) customer_name,
3136: msc_get_name.customer_site(md.customer_site_id) customer_site,
3137: msc_get_name.org_code(nvl(md.prev_subst_org, md.original_org_id),
3138: md.original_inst_id) org_code,
3139: msc_get_name.org_code(md.organization_id,md.sr_instance_id) to_org,

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

3132: select msi.item_name,
3133: md.order_number,
3134: msi.description item_desc,
3135: msc_get_name.customer(md.customer_id) customer_name,
3136: msc_get_name.customer_site(md.customer_site_id) customer_site,
3137: msc_get_name.org_code(nvl(md.prev_subst_org, md.original_org_id),
3138: md.original_inst_id) org_code,
3139: msc_get_name.org_code(md.organization_id,md.sr_instance_id) to_org,
3140: msoi.schedule_ship_date new_ship_date,

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

3133: md.order_number,
3134: msi.description item_desc,
3135: msc_get_name.customer(md.customer_id) customer_name,
3136: msc_get_name.customer_site(md.customer_site_id) customer_site,
3137: msc_get_name.org_code(nvl(md.prev_subst_org, md.original_org_id),
3138: md.original_inst_id) org_code,
3139: msc_get_name.org_code(md.organization_id,md.sr_instance_id) to_org,
3140: msoi.schedule_ship_date new_ship_date,
3141: md.schedule_ship_date old_ship_date,

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

3135: msc_get_name.customer(md.customer_id) customer_name,
3136: msc_get_name.customer_site(md.customer_site_id) customer_site,
3137: msc_get_name.org_code(nvl(md.prev_subst_org, md.original_org_id),
3138: md.original_inst_id) org_code,
3139: msc_get_name.org_code(md.organization_id,md.sr_instance_id) to_org,
3140: msoi.schedule_ship_date new_ship_date,
3141: md.schedule_ship_date old_ship_date,
3142: msoi.schedule_arrival_date new_arrival_date,
3143: md.schedule_arrival_date old_arrival_date,

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

3153: md.sr_instance_id,
3154: md.plan_id,
3155: mp.compile_designator plan_name,
3156: msoi.line_number line_number,
3157: msc_get_name.lookup_meaning('SYS_YES_NO',msoi.return_status) atp_override_flag,
3158: msc_get_name.item_name(nvl(md.prev_subst_item,md.original_item_id),
3159: null,null,null)
3160: orig_item_name,
3161: msc_get_name.item_desc(nvl(md.prev_subst_item,md.original_item_id),

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

3154: md.plan_id,
3155: mp.compile_designator plan_name,
3156: msoi.line_number line_number,
3157: msc_get_name.lookup_meaning('SYS_YES_NO',msoi.return_status) atp_override_flag,
3158: msc_get_name.item_name(nvl(md.prev_subst_item,md.original_item_id),
3159: null,null,null)
3160: orig_item_name,
3161: msc_get_name.item_desc(nvl(md.prev_subst_item,md.original_item_id),
3162: nvl(md.prev_subst_org, md.original_org_id),

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

3157: msc_get_name.lookup_meaning('SYS_YES_NO',msoi.return_status) atp_override_flag,
3158: msc_get_name.item_name(nvl(md.prev_subst_item,md.original_item_id),
3159: null,null,null)
3160: orig_item_name,
3161: msc_get_name.item_desc(nvl(md.prev_subst_item,md.original_item_id),
3162: nvl(md.prev_subst_org, md.original_org_id),
3163: md.plan_id,md.original_inst_id)
3164: orig_item_desc
3165: from msc_system_items msi,