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_OWB_TREE dependencies on OWB_TREE

Line 1: PACKAGE BODY MSC_OWB_TREE AS

1: PACKAGE BODY MSC_OWB_TREE AS
2: /* $Header: MSCOSTRB.pls 120.7 2007/12/14 06:52:40 sbnaik ship $ */
3:
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
5:

Line 8: PROCEDURE extend( p_nodes IN OUT NoCopy owb_tree.noderec, extend_amount NUMBER );

4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
5:
6: /*
7:
8: PROCEDURE extend( p_nodes IN OUT NoCopy owb_tree.noderec, extend_amount NUMBER );
9: PROCEDURE extend( p_nodes IN OUT NoCopy owb_tree.nodedata, extend_amount NUMBER );
10: */
11: PROCEDURE get_next_level_nodes(p_end_pegging_id NUMBER,
12: p_session_id NUMBER,

Line 9: PROCEDURE extend( p_nodes IN OUT NoCopy owb_tree.nodedata, extend_amount NUMBER );

5:
6: /*
7:
8: PROCEDURE extend( p_nodes IN OUT NoCopy owb_tree.noderec, extend_amount NUMBER );
9: PROCEDURE extend( p_nodes IN OUT NoCopy owb_tree.nodedata, extend_amount NUMBER );
10: */
11: PROCEDURE get_next_level_nodes(p_end_pegging_id NUMBER,
12: p_session_id NUMBER,
13: p_nodes OUT NoCopy owb_tree.NodeData,

Line 13: p_nodes OUT NoCopy owb_tree.NodeData,

9: PROCEDURE extend( p_nodes IN OUT NoCopy owb_tree.nodedata, extend_amount NUMBER );
10: */
11: PROCEDURE get_next_level_nodes(p_end_pegging_id NUMBER,
12: p_session_id NUMBER,
13: p_nodes OUT NoCopy owb_tree.NodeData,
14: p_expand_level NUMBER,
15: p_current_pegging_id NUMBER);
16:
17: PROCEDURE get_supply_only_nodes(p_end_pegging_id NUMBER,

Line 19: p_nodes OUT NoCopy owb_tree.NodeData,

15: p_current_pegging_id NUMBER);
16:
17: PROCEDURE get_supply_only_nodes(p_end_pegging_id NUMBER,
18: p_session_id NUMBER,
19: p_nodes OUT NoCopy owb_tree.NodeData,
20: p_expand_level NUMBER,
21: p_current_pegging_id NUMBER);
22:
23: PROCEDURE extend( p_nodes IN OUT NoCopy owb_tree.noderec, extend_amount NUMBER ) IS

Line 23: PROCEDURE extend( p_nodes IN OUT NoCopy owb_tree.noderec, extend_amount NUMBER ) IS

19: p_nodes OUT NoCopy owb_tree.NodeData,
20: p_expand_level NUMBER,
21: p_current_pegging_id NUMBER);
22:
23: PROCEDURE extend( p_nodes IN OUT NoCopy owb_tree.noderec, extend_amount NUMBER ) IS
24: BEGIN
25: p_nodes.tree_type.extend(extend_amount);
26: p_nodes.parent_node_type.extend(extend_amount);
27: p_nodes.state.extend( extend_amount );

Line 35: PROCEDURE extend( p_nodes IN OUT NoCopy owb_tree.nodedata, extend_amount NUMBER ) IS

31: p_nodes.data.extend( extend_amount );
32: END extend;
33:
34:
35: PROCEDURE extend( p_nodes IN OUT NoCopy owb_tree.nodedata, extend_amount NUMBER ) IS
36: BEGIN
37: p_nodes.state.extend( extend_amount );
38: p_nodes.depth.extend( extend_amount );
39: p_nodes.label.extend( extend_amount );

Line 47: p_nodes IN OUT NoCopy owb_tree.noderec,

43:
44: PROCEDURE get_node
45: ( p_tree_type NUMBER,
46: p_parent NUMBER,
47: p_nodes IN OUT NoCopy owb_tree.noderec,
48: p_lookup_code NUMBER ,
49: p_state NUMBER ,
50: p_depth NUMBER,
51: p_icon VARCHAR2);

Line 56: p_nodes OUT NoCopy owb_tree.nodeRec) IS

52:
53: PROCEDURE getstructure
54: (p_session_id NUMBER,
55: p_mode NUMBER,
56: p_nodes OUT NoCopy owb_tree.nodeRec) IS
57: l_current_node_depth NUMBER;
58:
59: total_excp NUMBER;
60:

Line 148: p_nodes IN OUT NoCopy owb_tree.noderec,

144:
145: PROCEDURE get_node
146: ( p_tree_type NUMBER,
147: p_parent NUMBER,
148: p_nodes IN OUT NoCopy owb_tree.noderec,
149: p_lookup_code NUMBER ,
150: p_state NUMBER ,
151: p_depth NUMBER,
152: p_icon VARCHAR2)

Line 225: IF NOT owb_tree.lookups.exists(1) THEN

221: END get_excp_count;
222:
223: PROCEDURE get_lookups IS
224: BEGIN
225: IF NOT owb_tree.lookups.exists(1) THEN
226: SELECT
227: Decode(lookup_code,
228: 0, Substr(meaning, 1,4),
229: 1, Substr(meaning, 1,13),

Line 256: bulk collect INTO owb_tree.lookups

252: 116, Substr(meaning,1,24), -- Resource Constraint
253: 117, Substr(meaning,1,24), -- Calendar Constraint
254: 119, Substr(meaning,1,40) -- Product Family Demand Spread
255: )
256: bulk collect INTO owb_tree.lookups
257: FROM mfg_lookups
258: WHERE
259: (lookup_type = 'MRP_SOURCE_TYPE' AND lookup_code IN ( 0, 1, 2, 3))
260: OR (lookup_type = 'MRP_ATP_FORM_TYPE' AND lookup_code IN

Line 283: FOR j IN 1..owb_tree.LOOKUPS_COUNT LOOP

279: -- 17. Supplier 90 15
280: -- 18. Line 100
281: -- 19. Substitute 110
282: -- 20,
283: FOR j IN 1..owb_tree.LOOKUPS_COUNT LOOP
284: msc_sch_wb.atp_debug(' lookups '||j||' '||owb_tree.lookups(j));
285: END LOOP;
286:
287: END IF;

Line 284: msc_sch_wb.atp_debug(' lookups '||j||' '||owb_tree.lookups(j));

280: -- 18. Line 100
281: -- 19. Substitute 110
282: -- 20,
283: FOR j IN 1..owb_tree.LOOKUPS_COUNT LOOP
284: msc_sch_wb.atp_debug(' lookups '||j||' '||owb_tree.lookups(j));
285: END LOOP;
286:
287: END IF;
288:

Line 298: p_nodes OUT NoCopy owb_tree.NodeData,

294: END get_lookups;
295:
296: PROCEDURE get_Sourcing_Nodes(p_end_pegging_id NUMBER,
297: p_session_id NUMBER,
298: p_nodes OUT NoCopy owb_tree.NodeData,
299: p_expand_level NUMBER,
300: p_current_node_data NUMBER,
301: p_checkbox BOOLEAN DEFAULT FALSE) IS
302: BEGIN

Line 464: p_nodes OUT NoCopy owb_tree.NodeData,

460:
461:
462: PROCEDURE get_next_level_nodes(p_end_pegging_id NUMBER,
463: p_session_id NUMBER,
464: p_nodes OUT NoCopy owb_tree.NodeData,
465: p_expand_level NUMBER,
466: p_current_pegging_id NUMBER)
467: IS
468: counter NUMBER;

Line 503: ||' '||owb_tree.lookups(10)||' '

499: Decode(department_code, NULL,
500: (ship_method||' - '||ROUND(supply_demand_quantity,6)||' '||uom_code||' - '
501: ||from_organization_code
502: ||Decode(from_location_code, NULL, '', '('||from_location_code||')')
503: ||' '||owb_tree.lookups(10)||' '
504: ||to_organization_code
505: ||Decode(to_location_code, NULL, '', '('||to_location_code||')')),
506: -- dept is not null
507: Decode(resource_code, NULL,

Line 509: owb_tree.lookups(18)||'-'||department_code,

505: ||Decode(to_location_code, NULL, '', '('||to_location_code||')')),
506: -- dept is not null
507: Decode(resource_code, NULL,
508: -- Line
509: owb_tree.lookups(18)||'-'||department_code,
510: -- Resource
511: owb_tree.lookups(8)||'-'||department_code||':'||owb_tree.lookups(7)||'-'||resource_code)
512: ||' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||uom_code||' '||owb_tree.lookups(12)||' '||fnd_date.date_to_displaydate(supply_demand_date)),
513: -- when item_name is not null

Line 511: owb_tree.lookups(8)||'-'||department_code||':'||owb_tree.lookups(7)||'-'||resource_code)

507: Decode(resource_code, NULL,
508: -- Line
509: owb_tree.lookups(18)||'-'||department_code,
510: -- Resource
511: owb_tree.lookups(8)||'-'||department_code||':'||owb_tree.lookups(7)||'-'||resource_code)
512: ||' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||uom_code||' '||owb_tree.lookups(12)||' '||fnd_date.date_to_displaydate(supply_demand_date)),
513: -- when item_name is not null
514: inventory_item_name ||' -'||Decode(number1,1, owb_tree.lookups(19)||' ',' ')
515: ||Decode(source_type, 1, owb_tree.lookups(2),2, owb_tree.lookups(3), 3, owb_tree.lookups(4),

Line 512: ||' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||uom_code||' '||owb_tree.lookups(12)||' '||fnd_date.date_to_displaydate(supply_demand_date)),

508: -- Line
509: owb_tree.lookups(18)||'-'||department_code,
510: -- Resource
511: owb_tree.lookups(8)||'-'||department_code||':'||owb_tree.lookups(7)||'-'||resource_code)
512: ||' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||uom_code||' '||owb_tree.lookups(12)||' '||fnd_date.date_to_displaydate(supply_demand_date)),
513: -- when item_name is not null
514: inventory_item_name ||' -'||Decode(number1,1, owb_tree.lookups(19)||' ',' ')
515: ||Decode(source_type, 1, owb_tree.lookups(2),2, owb_tree.lookups(3), 3, owb_tree.lookups(4),
516: 0, owb_tree.lookups(1))

Line 514: inventory_item_name ||' -'||Decode(number1,1, owb_tree.lookups(19)||' ',' ')

510: -- Resource
511: owb_tree.lookups(8)||'-'||department_code||':'||owb_tree.lookups(7)||'-'||resource_code)
512: ||' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||uom_code||' '||owb_tree.lookups(12)||' '||fnd_date.date_to_displaydate(supply_demand_date)),
513: -- when item_name is not null
514: inventory_item_name ||' -'||Decode(number1,1, owb_tree.lookups(19)||' ',' ')
515: ||Decode(source_type, 1, owb_tree.lookups(2),2, owb_tree.lookups(3), 3, owb_tree.lookups(4),
516: 0, owb_tree.lookups(1))
517: ||' '||Decode(source_type, 3, supplier_name, nvl(supplier_name,organization_code)) ||
518: ' '||supplier_site_name||

Line 515: ||Decode(source_type, 1, owb_tree.lookups(2),2, owb_tree.lookups(3), 3, owb_tree.lookups(4),

511: owb_tree.lookups(8)||'-'||department_code||':'||owb_tree.lookups(7)||'-'||resource_code)
512: ||' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||uom_code||' '||owb_tree.lookups(12)||' '||fnd_date.date_to_displaydate(supply_demand_date)),
513: -- when item_name is not null
514: inventory_item_name ||' -'||Decode(number1,1, owb_tree.lookups(19)||' ',' ')
515: ||Decode(source_type, 1, owb_tree.lookups(2),2, owb_tree.lookups(3), 3, owb_tree.lookups(4),
516: 0, owb_tree.lookups(1))
517: ||' '||Decode(source_type, 3, supplier_name, nvl(supplier_name,organization_code)) ||
518: ' '||supplier_site_name||
519: ' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||owb_tree.lookups(12)||' '

Line 516: 0, owb_tree.lookups(1))

512: ||' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||uom_code||' '||owb_tree.lookups(12)||' '||fnd_date.date_to_displaydate(supply_demand_date)),
513: -- when item_name is not null
514: inventory_item_name ||' -'||Decode(number1,1, owb_tree.lookups(19)||' ',' ')
515: ||Decode(source_type, 1, owb_tree.lookups(2),2, owb_tree.lookups(3), 3, owb_tree.lookups(4),
516: 0, owb_tree.lookups(1))
517: ||' '||Decode(source_type, 3, supplier_name, nvl(supplier_name,organization_code)) ||
518: ' '||supplier_site_name||
519: ' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||owb_tree.lookups(12)||' '
520: ||fnd_date.date_to_displaydate(supply_demand_date)

Line 519: ' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||owb_tree.lookups(12)||' '

515: ||Decode(source_type, 1, owb_tree.lookups(2),2, owb_tree.lookups(3), 3, owb_tree.lookups(4),
516: 0, owb_tree.lookups(1))
517: ||' '||Decode(source_type, 3, supplier_name, nvl(supplier_name,organization_code)) ||
518: ' '||supplier_site_name||
519: ' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||owb_tree.lookups(12)||' '
520: ||fnd_date.date_to_displaydate(supply_demand_date)
521: ) || ' '
522: ||decode(constraint_type,null,null,
523: 1, '{'||owb_tree.lookups(20)||'}',

Line 523: 1, '{'||owb_tree.lookups(20)||'}',

519: ' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||owb_tree.lookups(12)||' '
520: ||fnd_date.date_to_displaydate(supply_demand_date)
521: ) || ' '
522: ||decode(constraint_type,null,null,
523: 1, '{'||owb_tree.lookups(20)||'}',
524: 2, '{'||owb_tree.lookups(21)||' '||fnd_date.date_to_displaydate(constraint_date)||'}',
525: 3, '{'||owb_tree.lookups(22)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',
526: 4, '{'||owb_tree.lookups(23)||' '||fnd_date.date_to_displaydate(constraint_date)||'}',
527: 5, '{'||owb_tree.lookups(24)||' ' || fnd_date.date_to_displaydate(constraint_date)||'}',

Line 524: 2, '{'||owb_tree.lookups(21)||' '||fnd_date.date_to_displaydate(constraint_date)||'}',

520: ||fnd_date.date_to_displaydate(supply_demand_date)
521: ) || ' '
522: ||decode(constraint_type,null,null,
523: 1, '{'||owb_tree.lookups(20)||'}',
524: 2, '{'||owb_tree.lookups(21)||' '||fnd_date.date_to_displaydate(constraint_date)||'}',
525: 3, '{'||owb_tree.lookups(22)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',
526: 4, '{'||owb_tree.lookups(23)||' '||fnd_date.date_to_displaydate(constraint_date)||'}',
527: 5, '{'||owb_tree.lookups(24)||' ' || fnd_date.date_to_displaydate(constraint_date)||'}',
528: 6, '{'||owb_tree.lookups(25)||'}',

Line 525: 3, '{'||owb_tree.lookups(22)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',

521: ) || ' '
522: ||decode(constraint_type,null,null,
523: 1, '{'||owb_tree.lookups(20)||'}',
524: 2, '{'||owb_tree.lookups(21)||' '||fnd_date.date_to_displaydate(constraint_date)||'}',
525: 3, '{'||owb_tree.lookups(22)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',
526: 4, '{'||owb_tree.lookups(23)||' '||fnd_date.date_to_displaydate(constraint_date)||'}',
527: 5, '{'||owb_tree.lookups(24)||' ' || fnd_date.date_to_displaydate(constraint_date)||'}',
528: 6, '{'||owb_tree.lookups(25)||'}',
529: 7 , '{'||owb_tree.lookups(26)||'}')

Line 526: 4, '{'||owb_tree.lookups(23)||' '||fnd_date.date_to_displaydate(constraint_date)||'}',

522: ||decode(constraint_type,null,null,
523: 1, '{'||owb_tree.lookups(20)||'}',
524: 2, '{'||owb_tree.lookups(21)||' '||fnd_date.date_to_displaydate(constraint_date)||'}',
525: 3, '{'||owb_tree.lookups(22)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',
526: 4, '{'||owb_tree.lookups(23)||' '||fnd_date.date_to_displaydate(constraint_date)||'}',
527: 5, '{'||owb_tree.lookups(24)||' ' || fnd_date.date_to_displaydate(constraint_date)||'}',
528: 6, '{'||owb_tree.lookups(25)||'}',
529: 7 , '{'||owb_tree.lookups(26)||'}')
530: ||decode(char1,null, null, ' ('||get_cust_hier_string(char1)||')'),

Line 527: 5, '{'||owb_tree.lookups(24)||' ' || fnd_date.date_to_displaydate(constraint_date)||'}',

523: 1, '{'||owb_tree.lookups(20)||'}',
524: 2, '{'||owb_tree.lookups(21)||' '||fnd_date.date_to_displaydate(constraint_date)||'}',
525: 3, '{'||owb_tree.lookups(22)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',
526: 4, '{'||owb_tree.lookups(23)||' '||fnd_date.date_to_displaydate(constraint_date)||'}',
527: 5, '{'||owb_tree.lookups(24)||' ' || fnd_date.date_to_displaydate(constraint_date)||'}',
528: 6, '{'||owb_tree.lookups(25)||'}',
529: 7 , '{'||owb_tree.lookups(26)||'}')
530: ||decode(char1,null, null, ' ('||get_cust_hier_string(char1)||')'),
531: decode(supply_demand_type,1, ICON_DEMAND,

Line 528: 6, '{'||owb_tree.lookups(25)||'}',

524: 2, '{'||owb_tree.lookups(21)||' '||fnd_date.date_to_displaydate(constraint_date)||'}',
525: 3, '{'||owb_tree.lookups(22)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',
526: 4, '{'||owb_tree.lookups(23)||' '||fnd_date.date_to_displaydate(constraint_date)||'}',
527: 5, '{'||owb_tree.lookups(24)||' ' || fnd_date.date_to_displaydate(constraint_date)||'}',
528: 6, '{'||owb_tree.lookups(25)||'}',
529: 7 , '{'||owb_tree.lookups(26)||'}')
530: ||decode(char1,null, null, ' ('||get_cust_hier_string(char1)||')'),
531: decode(supply_demand_type,1, ICON_DEMAND,
532: decode(inventory_item_name, NULL,

Line 529: 7 , '{'||owb_tree.lookups(26)||'}')

525: 3, '{'||owb_tree.lookups(22)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',
526: 4, '{'||owb_tree.lookups(23)||' '||fnd_date.date_to_displaydate(constraint_date)||'}',
527: 5, '{'||owb_tree.lookups(24)||' ' || fnd_date.date_to_displaydate(constraint_date)||'}',
528: 6, '{'||owb_tree.lookups(25)||'}',
529: 7 , '{'||owb_tree.lookups(26)||'}')
530: ||decode(char1,null, null, ' ('||get_cust_hier_string(char1)||')'),
531: decode(supply_demand_type,1, ICON_DEMAND,
532: decode(inventory_item_name, NULL,
533: decode(constraint_type,NULL,ICON_RESOURCE_CAP, -- Dept Res

Line 585: p_nodes OUT NoCopy owb_tree.NodeData,

581: END get_next_level_nodes;
582:
583: PROCEDURE get_supply_only_nodes (p_end_pegging_id NUMBER,
584: p_session_id NUMBER,
585: p_nodes OUT NoCopy owb_tree.NodeData,
586: p_expand_level NUMBER,
587: p_current_pegging_id NUMBER)
588: IS
589: counter NUMBER;

Line 592: msc_sch_wb.atp_debug('get_supply_only_nodes: ' || 'Cholpon check ' || owb_tree.lookups(21));

588: IS
589: counter NUMBER;
590: BEGIN
591: IF PG_DEBUG in ('Y', 'C') THEN
592: msc_sch_wb.atp_debug('get_supply_only_nodes: ' || 'Cholpon check ' || owb_tree.lookups(21));
593: END IF;
594: SELECT
595: Decode(inventory_item_name, NULL,
596: Decode(department_code, NULL,leaf_node,

Line 625: ||' '||owb_tree.lookups(10)||' '

621: Decode(department_code, NULL,
622: (ship_method||' - '||ROUND(supply_demand_quantity,6)||' '||uom_code||' - '
623: ||from_organization_code
624: ||Decode(from_location_code, NULL, '', '('||from_location_code||')')
625: ||' '||owb_tree.lookups(10)||' '
626: ||to_organization_code
627: ||Decode(to_location_code, NULL, '', '('||to_location_code||')')),
628: -- dept is not null
629: Decode(resource_code, NULL,

Line 631: owb_tree.lookups(18)||'-'||department_code,

627: ||Decode(to_location_code, NULL, '', '('||to_location_code||')')),
628: -- dept is not null
629: Decode(resource_code, NULL,
630: -- Line
631: owb_tree.lookups(18)||'-'||department_code,
632: -- Resource
633: owb_tree.lookups(8)||'-'||department_code||':'||owb_tree.lookups(7)||'-'||resource_code)
634: ||' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||uom_code||' '||owb_tree.lookups(12)||' '||fnd_date.date_to_displaydate(supply_demand_date)),
635: -- when item_name is not null

Line 633: owb_tree.lookups(8)||'-'||department_code||':'||owb_tree.lookups(7)||'-'||resource_code)

629: Decode(resource_code, NULL,
630: -- Line
631: owb_tree.lookups(18)||'-'||department_code,
632: -- Resource
633: owb_tree.lookups(8)||'-'||department_code||':'||owb_tree.lookups(7)||'-'||resource_code)
634: ||' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||uom_code||' '||owb_tree.lookups(12)||' '||fnd_date.date_to_displaydate(supply_demand_date)),
635: -- when item_name is not null
636: inventory_item_name ||' -'||Decode(number1,1, owb_tree.lookups(19)||' ',' ')
637: ||Decode(source_type, 1, owb_tree.lookups(2),2, owb_tree.lookups(3), 3, owb_tree.lookups(4),

Line 634: ||' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||uom_code||' '||owb_tree.lookups(12)||' '||fnd_date.date_to_displaydate(supply_demand_date)),

630: -- Line
631: owb_tree.lookups(18)||'-'||department_code,
632: -- Resource
633: owb_tree.lookups(8)||'-'||department_code||':'||owb_tree.lookups(7)||'-'||resource_code)
634: ||' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||uom_code||' '||owb_tree.lookups(12)||' '||fnd_date.date_to_displaydate(supply_demand_date)),
635: -- when item_name is not null
636: inventory_item_name ||' -'||Decode(number1,1, owb_tree.lookups(19)||' ',' ')
637: ||Decode(source_type, 1, owb_tree.lookups(2),2, owb_tree.lookups(3), 3, owb_tree.lookups(4),
638: 0, owb_tree.lookups(1))

Line 636: inventory_item_name ||' -'||Decode(number1,1, owb_tree.lookups(19)||' ',' ')

632: -- Resource
633: owb_tree.lookups(8)||'-'||department_code||':'||owb_tree.lookups(7)||'-'||resource_code)
634: ||' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||uom_code||' '||owb_tree.lookups(12)||' '||fnd_date.date_to_displaydate(supply_demand_date)),
635: -- when item_name is not null
636: inventory_item_name ||' -'||Decode(number1,1, owb_tree.lookups(19)||' ',' ')
637: ||Decode(source_type, 1, owb_tree.lookups(2),2, owb_tree.lookups(3), 3, owb_tree.lookups(4),
638: 0, owb_tree.lookups(1))
639: ||' '||Decode(source_type, 3, supplier_name, nvl(supplier_name,organization_code))||
640: ' '||supplier_site_name||

Line 637: ||Decode(source_type, 1, owb_tree.lookups(2),2, owb_tree.lookups(3), 3, owb_tree.lookups(4),

633: owb_tree.lookups(8)||'-'||department_code||':'||owb_tree.lookups(7)||'-'||resource_code)
634: ||' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||uom_code||' '||owb_tree.lookups(12)||' '||fnd_date.date_to_displaydate(supply_demand_date)),
635: -- when item_name is not null
636: inventory_item_name ||' -'||Decode(number1,1, owb_tree.lookups(19)||' ',' ')
637: ||Decode(source_type, 1, owb_tree.lookups(2),2, owb_tree.lookups(3), 3, owb_tree.lookups(4),
638: 0, owb_tree.lookups(1))
639: ||' '||Decode(source_type, 3, supplier_name, nvl(supplier_name,organization_code))||
640: ' '||supplier_site_name||
641: ' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||owb_tree.lookups(12)||' '

Line 638: 0, owb_tree.lookups(1))

634: ||' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||uom_code||' '||owb_tree.lookups(12)||' '||fnd_date.date_to_displaydate(supply_demand_date)),
635: -- when item_name is not null
636: inventory_item_name ||' -'||Decode(number1,1, owb_tree.lookups(19)||' ',' ')
637: ||Decode(source_type, 1, owb_tree.lookups(2),2, owb_tree.lookups(3), 3, owb_tree.lookups(4),
638: 0, owb_tree.lookups(1))
639: ||' '||Decode(source_type, 3, supplier_name, nvl(supplier_name,organization_code))||
640: ' '||supplier_site_name||
641: ' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||owb_tree.lookups(12)||' '
642: ||fnd_date.date_to_displaydate(supply_demand_date)

Line 641: ' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||owb_tree.lookups(12)||' '

637: ||Decode(source_type, 1, owb_tree.lookups(2),2, owb_tree.lookups(3), 3, owb_tree.lookups(4),
638: 0, owb_tree.lookups(1))
639: ||' '||Decode(source_type, 3, supplier_name, nvl(supplier_name,organization_code))||
640: ' '||supplier_site_name||
641: ' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||owb_tree.lookups(12)||' '
642: ||fnd_date.date_to_displaydate(supply_demand_date)
643: ) ||
644: ' ' ||decode(constraint_type,null,null,
645: 1 , '{'||owb_tree.lookups(20)||' '||fnd_date.date_to_displaydate(constraint_date) ||'}',

Line 645: 1 , '{'||owb_tree.lookups(20)||' '||fnd_date.date_to_displaydate(constraint_date) ||'}',

641: ' '||owb_tree.lookups(11)||' '||ROUND(supply_demand_quantity,6)||' '||owb_tree.lookups(12)||' '
642: ||fnd_date.date_to_displaydate(supply_demand_date)
643: ) ||
644: ' ' ||decode(constraint_type,null,null,
645: 1 , '{'||owb_tree.lookups(20)||' '||fnd_date.date_to_displaydate(constraint_date) ||'}',
646: 2, '{'||owb_tree.lookups(21)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}', 3, '{'||owb_tree.lookups(22)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',
647: 4, '{'||owb_tree.lookups(23)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',
648: 5, '{'||owb_tree.lookups(24)||' '||fnd_date.date_to_displaydate(constraint_date) ||'}',
649: 6, '{'||owb_tree.lookups(25) || '}',

Line 646: 2, '{'||owb_tree.lookups(21)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}', 3, '{'||owb_tree.lookups(22)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',

642: ||fnd_date.date_to_displaydate(supply_demand_date)
643: ) ||
644: ' ' ||decode(constraint_type,null,null,
645: 1 , '{'||owb_tree.lookups(20)||' '||fnd_date.date_to_displaydate(constraint_date) ||'}',
646: 2, '{'||owb_tree.lookups(21)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}', 3, '{'||owb_tree.lookups(22)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',
647: 4, '{'||owb_tree.lookups(23)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',
648: 5, '{'||owb_tree.lookups(24)||' '||fnd_date.date_to_displaydate(constraint_date) ||'}',
649: 6, '{'||owb_tree.lookups(25) || '}',
650: 7 , '{'||owb_tree.lookups(26)||'}')

Line 647: 4, '{'||owb_tree.lookups(23)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',

643: ) ||
644: ' ' ||decode(constraint_type,null,null,
645: 1 , '{'||owb_tree.lookups(20)||' '||fnd_date.date_to_displaydate(constraint_date) ||'}',
646: 2, '{'||owb_tree.lookups(21)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}', 3, '{'||owb_tree.lookups(22)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',
647: 4, '{'||owb_tree.lookups(23)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',
648: 5, '{'||owb_tree.lookups(24)||' '||fnd_date.date_to_displaydate(constraint_date) ||'}',
649: 6, '{'||owb_tree.lookups(25) || '}',
650: 7 , '{'||owb_tree.lookups(26)||'}')
651: ||decode(char1,null, null, ' ('||get_cust_hier_string(char1)||')'),

Line 648: 5, '{'||owb_tree.lookups(24)||' '||fnd_date.date_to_displaydate(constraint_date) ||'}',

644: ' ' ||decode(constraint_type,null,null,
645: 1 , '{'||owb_tree.lookups(20)||' '||fnd_date.date_to_displaydate(constraint_date) ||'}',
646: 2, '{'||owb_tree.lookups(21)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}', 3, '{'||owb_tree.lookups(22)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',
647: 4, '{'||owb_tree.lookups(23)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',
648: 5, '{'||owb_tree.lookups(24)||' '||fnd_date.date_to_displaydate(constraint_date) ||'}',
649: 6, '{'||owb_tree.lookups(25) || '}',
650: 7 , '{'||owb_tree.lookups(26)||'}')
651: ||decode(char1,null, null, ' ('||get_cust_hier_string(char1)||')'),
652: decode(supply_demand_type,1, ICON_DEMAND,

Line 649: 6, '{'||owb_tree.lookups(25) || '}',

645: 1 , '{'||owb_tree.lookups(20)||' '||fnd_date.date_to_displaydate(constraint_date) ||'}',
646: 2, '{'||owb_tree.lookups(21)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}', 3, '{'||owb_tree.lookups(22)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',
647: 4, '{'||owb_tree.lookups(23)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',
648: 5, '{'||owb_tree.lookups(24)||' '||fnd_date.date_to_displaydate(constraint_date) ||'}',
649: 6, '{'||owb_tree.lookups(25) || '}',
650: 7 , '{'||owb_tree.lookups(26)||'}')
651: ||decode(char1,null, null, ' ('||get_cust_hier_string(char1)||')'),
652: decode(supply_demand_type,1, ICON_DEMAND,
653: decode(inventory_item_name, NULL,

Line 650: 7 , '{'||owb_tree.lookups(26)||'}')

646: 2, '{'||owb_tree.lookups(21)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}', 3, '{'||owb_tree.lookups(22)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',
647: 4, '{'||owb_tree.lookups(23)||' ' ||fnd_date.date_to_displaydate(constraint_date)||'}',
648: 5, '{'||owb_tree.lookups(24)||' '||fnd_date.date_to_displaydate(constraint_date) ||'}',
649: 6, '{'||owb_tree.lookups(25) || '}',
650: 7 , '{'||owb_tree.lookups(26)||'}')
651: ||decode(char1,null, null, ' ('||get_cust_hier_string(char1)||')'),
652: decode(supply_demand_type,1, ICON_DEMAND,
653: decode(inventory_item_name, NULL,
654: decode(constraint_type,NULL,ICON_RESOURCE_CAP, -- Dept Res

Line 711: END MSC_OWB_TREE;

707:
708:
709:
710:
711: END MSC_OWB_TREE;