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 FND_DATE

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 520: ||fnd_date.date_to_displaydate(supply_demand_date)

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)||'}',
524: 2, '{'||owb_tree.lookups(21)||' '||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 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 642: ||fnd_date.date_to_displaydate(supply_demand_date)

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) ||'}',
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)||'}',

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,