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

Line 3002: ':p_total_member_string || msc_get_name.item_name(msi.product_family_id,null,null,null) '||

2998: 'DECODE( :p_org_id,-1,-1,msi.organization_id), '||
2999: ' :NODE_REGULAR_ITEM, '||
3000: ' :org_seq, '||
3001: 'DECODE( :p_org_id,-1,:p_all_org_string ,msi.organization_code), '||
3002: ':p_total_member_string || msc_get_name.item_name(msi.product_family_id,null,null,null) '||
3003: ' FROM msc_items_tree_v msi' ||
3004: ' WHERE msi.category_set_id = :p_category_set ' ||
3005: ' AND msi.product_family_id = :p_item_list ' ||
3006: ' AND msi.plan_id = :p_plan_id';

Line 3089: 'msc_get_name.org_code(msi.organization_id,msi.sr_instance_id), '||

3085: 'msi.inventory_item_id, '||
3086: 'msi.organization_id, '||
3087: ':NODE_REGULAR_ITEM, ' ||
3088: ' :org_seq, '||
3089: 'msc_get_name.org_code(msi.organization_id,msi.sr_instance_id), '||
3090: 'msi.item_name '||
3091: ' FROM msc_system_items msi ' ||
3092: ' where msi.sr_instance_id = :p_inst_id '||
3093: 'and msi.organization_id = :p_org_list ' ||

Line 3137: 'msc_get_name.org_code(msi.organization_id,msi.sr_instance_id),'||

3133: 'msi.inventory_item_id,'||
3134: 'msi.organization_id, '||
3135: ' :NODE_REGULAR_ITEM, ' ||
3136: ' :org_seq, '||
3137: 'msc_get_name.org_code(msi.organization_id,msi.sr_instance_id),'||
3138: 'msi.item_name '||
3139: ' FROM msc_system_items msi, msc_item_categories mic' ||
3140: ' WHERE mic.organization_id = msi.organization_id ' ||
3141: 'AND mic.sr_instance_id = msi.sr_instance_id ' ||

Line 3157: ' msc_get_name.org_code(msi.organization_id,msi.sr_instance_id),'||

3153: 'msi.inventory_item_id,'||
3154: 'msi.organization_id, '||
3155: ' :NODE_REGULAR_ITEM, ' ||
3156: ' :org_seq, '||
3157: ' msc_get_name.org_code(msi.organization_id,msi.sr_instance_id),'||
3158: ' msi.item_name '||
3159: ' FROM msc_system_items msi ' ||
3160: ' where msi.inventory_item_id = :p_item_list ' ||
3161: ' AND msi.organization_id <> -1 '||

Line 3383: ' and order_type = msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',5)';

3379: ' and department_id= :p_dept_id' ||
3380: ' and resource_id = :p_res_id';
3381: if p_rowtype = 660 then
3382: sql_stmt := sql_stmt ||
3383: ' and order_type = msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',5)';
3384: ELSIF p_rowtype = 680 then
3385: sql_stmt := sql_stmt ||
3386: ' and order_type = msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',3)';
3387: ELSIF p_rowtype = 720 then

Line 3386: ' and order_type = msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',3)';

3382: sql_stmt := sql_stmt ||
3383: ' and order_type = msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',5)';
3384: ELSIF p_rowtype = 680 then
3385: sql_stmt := sql_stmt ||
3386: ' and order_type = msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',3)';
3387: ELSIF p_rowtype = 720 then
3388: sql_stmt := sql_stmt ||
3389: ' and order_type IN (msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',70),msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',92)) ';
3390: ELSIF p_rowtype = 730 then

Line 3389: ' and order_type IN (msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',70),msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',92)) ';

3385: sql_stmt := sql_stmt ||
3386: ' and order_type = msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',3)';
3387: ELSIF p_rowtype = 720 then
3388: sql_stmt := sql_stmt ||
3389: ' and order_type IN (msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',70),msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',92)) ';
3390: ELSIF p_rowtype = 730 then
3391: sql_stmt := sql_stmt ||
3392: ' and order_type = msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',79)';
3393: ELSIF p_rowtype = 740 then

Line 3392: ' and order_type = msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',79)';

3388: sql_stmt := sql_stmt ||
3389: ' and order_type IN (msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',70),msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',92)) ';
3390: ELSIF p_rowtype = 730 then
3391: sql_stmt := sql_stmt ||
3392: ' and order_type = msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',79)';
3393: ELSIF p_rowtype = 740 then
3394: sql_stmt := sql_stmt ||
3395: ' and order_type = msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',74)';
3396: end if;

Line 3395: ' and order_type = msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',74)';

3391: sql_stmt := sql_stmt ||
3392: ' and order_type = msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',79)';
3393: ELSIF p_rowtype = 740 then
3394: sql_stmt := sql_stmt ||
3395: ' and order_type = msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'',74)';
3396: end if;
3397: END IF;
3398:
3399: EXECUTE IMMEDIATE sql_stmt using l_query_id,p_start_date,p_end_date,

Line 3583: ' FROM '||msc_get_name.get_order_view(p_plan_type, p_plan_id) ||

3579: else -- regular item
3580: sql_stmt := '';
3581: sql_stmt := sql_stmt_1 ||
3582: ' transaction_id '||
3583: ' FROM '||msc_get_name.get_order_view(p_plan_type, p_plan_id) ||
3584: ' WHERE plan_id = :p_plan_id' ||
3585: ' AND organization_id = :p_org_id'||
3586: ' AND sr_instance_id = :p_inst_id'||
3587: ' and inventory_item_id = :p_item_id';

Line 3618: sql_stmt := sql_stmt || ' AND trunc(nvl(firm_date,new_due_date)) <= '''|| p_end_date|| '''AND (order_type not in (70,77,78,81,11) OR (order_type=70 and produces_to_stock=msc_get_name.lookup_meaning(''SYS_YES_NO'',1))) AND item_type_value = 1';

3614: p_start_date||''' AND '''|| p_end_date|| '''';
3615: END IF;
3616: ELSIF ((l_isHp = true AND p_rowtype in (110,150)) OR -- POH, PAB /*Added order type 70 ,PTS yes for bug 12731259*/
3617: (l_isDrp = true AND p_rowtype in (280,290,300))) THEN -- POH,PAB,UNC_PAB
3618: sql_stmt := sql_stmt || ' AND trunc(nvl(firm_date,new_due_date)) <= '''|| p_end_date|| '''AND (order_type not in (70,77,78,81,11) OR (order_type=70 and produces_to_stock=msc_get_name.lookup_meaning(''SYS_YES_NO'',1))) AND item_type_value = 1';
3619: -- ---------------------------
3620: -- New Row Types added for USAF HP
3621: -- ---------------------------
3622: ELSIF (l_isHp = true AND p_rowtype = 325) THEN -- POH, PAB def /*Added item_type_value for bug 12427785*/

Line 3735: ' AND (order_type in (1,2,3,5,7,8,11,12,13,14,15,17,27,28,29,32,49,51,53,79,74) OR (order_type=70 and produces_to_stock=msc_get_name.lookup_meaning(''SYS_YES_NO'',1)) and AND item_type_value = 1) ';

3731: ELSIF ((l_isHp = true AND p_rowtype = 100) OR
3732: -- Total Supply: should not include request arrival /*Added order type 70 ,PTS yes for bug 12730764*/
3733: (l_isDrp = true AND p_rowtype = 260)) THEN
3734: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3735: ' AND (order_type in (1,2,3,5,7,8,11,12,13,14,15,17,27,28,29,32,49,51,53,79,74) OR (order_type=70 and produces_to_stock=msc_get_name.lookup_meaning(''SYS_YES_NO'',1)) and AND item_type_value = 1) ';
3736: ELSIF ((l_isHp = true AND p_rowtype = 105) OR -- Beginning on Hand /*Added item_type_value for bug 12534589*/
3737: (l_isDrp = true AND p_rowtype = 130)) THEN
3738: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3739: ' AND order_type = 18 AND item_type_value = 1';