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

Line 1122: inventory_item_name||order_sch_wb.delim||owb_tree.lookups(5) -- 'Item'

1118: and b.period_start_date <= v_period_end_date;
1119:
1120: cursor get_item_name is
1121: SELECT DISTINCT
1122: inventory_item_name||order_sch_wb.delim||owb_tree.lookups(5) -- 'Item'
1123: ||order_sch_wb.delim||source_organization_code
1124: FROM mrp_atp_schedule_temp
1125: WHERE end_pegging_id = p_end_pegging_id;
1126:

Line 1138: msc_owb_tree.get_lookups;

1134: p_cum_atp_str := NULL;
1135: p_bkd_demand_str := NULL;
1136:
1137:
1138: msc_owb_tree.get_lookups;
1139:
1140: IF NOT p_is_allocated THEN
1141:
1142: IF p_pegging_id IS NOT NULL THEN

Line 1145: inventory_item_name||order_sch_wb.delim||owb_tree.lookups(5)||order_sch_wb.delim||organization_code,

1141:
1142: IF p_pegging_id IS NOT NULL THEN
1143: SELECT Decode(department_id, NULL,
1144: Decode(supplier_id, NULL,
1145: inventory_item_name||order_sch_wb.delim||owb_tree.lookups(5)||order_sch_wb.delim||organization_code,
1146: -- 'Item'
1147: supplier_name||order_sch_wb.delim||owb_tree.lookups(17)||order_sch_wb.delim||supplier_site_name),
1148: department_code||order_sch_wb.delim||Decode(resource_code, NULL, owb_tree.lookups(18),owb_tree.lookups(6))||order_sch_wb.delim||Decode(resource_code, NULL, ' ', resource_code))
1149: -- blank above is so that pivot table will get some value to display

Line 1147: supplier_name||order_sch_wb.delim||owb_tree.lookups(17)||order_sch_wb.delim||supplier_site_name),

1143: SELECT Decode(department_id, NULL,
1144: Decode(supplier_id, NULL,
1145: inventory_item_name||order_sch_wb.delim||owb_tree.lookups(5)||order_sch_wb.delim||organization_code,
1146: -- 'Item'
1147: supplier_name||order_sch_wb.delim||owb_tree.lookups(17)||order_sch_wb.delim||supplier_site_name),
1148: department_code||order_sch_wb.delim||Decode(resource_code, NULL, owb_tree.lookups(18),owb_tree.lookups(6))||order_sch_wb.delim||Decode(resource_code, NULL, ' ', resource_code))
1149: -- blank above is so that pivot table will get some value to display
1150: -- for line. otherwise following values shift left.
1151: INTO l_pivot_hdr

Line 1148: department_code||order_sch_wb.delim||Decode(resource_code, NULL, owb_tree.lookups(18),owb_tree.lookups(6))||order_sch_wb.delim||Decode(resource_code, NULL, ' ', resource_code))

1144: Decode(supplier_id, NULL,
1145: inventory_item_name||order_sch_wb.delim||owb_tree.lookups(5)||order_sch_wb.delim||organization_code,
1146: -- 'Item'
1147: supplier_name||order_sch_wb.delim||owb_tree.lookups(17)||order_sch_wb.delim||supplier_site_name),
1148: department_code||order_sch_wb.delim||Decode(resource_code, NULL, owb_tree.lookups(18),owb_tree.lookups(6))||order_sch_wb.delim||Decode(resource_code, NULL, ' ', resource_code))
1149: -- blank above is so that pivot table will get some value to display
1150: -- for line. otherwise following values shift left.
1151: INTO l_pivot_hdr
1152: FROM mrp_atp_details_temp

Line 1356: ||order_sch_wb.delim||owb_tree.lookups(13)||order_sch_wb.delim||

1352: p_period_str := p_period_str||order_sch_wb.delim||'End';
1353:
1354: IF NOT p_is_allocated THEN
1355: p_row_hdr_str := p_row_hdr_str||order_sch_wb.delim||l_pivot_hdr
1356: ||order_sch_wb.delim||owb_tree.lookups(13)||order_sch_wb.delim||
1357: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||owb_tree.lookups(15)||order_sch_wb.delim||
1358: owb_tree.lookups(16)||order_sch_wb.delim||'End';
1359: ELSE
1360: IF p_pegging_id is null THEN

Line 1357: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||owb_tree.lookups(15)||order_sch_wb.delim||

1353:
1354: IF NOT p_is_allocated THEN
1355: p_row_hdr_str := p_row_hdr_str||order_sch_wb.delim||l_pivot_hdr
1356: ||order_sch_wb.delim||owb_tree.lookups(13)||order_sch_wb.delim||
1357: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||owb_tree.lookups(15)||order_sch_wb.delim||
1358: owb_tree.lookups(16)||order_sch_wb.delim||'End';
1359: ELSE
1360: IF p_pegging_id is null THEN
1361: p_row_hdr_str:= owb_tree.lookups(6)||order_sch_wb.delim;

Line 1358: owb_tree.lookups(16)||order_sch_wb.delim||'End';

1354: IF NOT p_is_allocated THEN
1355: p_row_hdr_str := p_row_hdr_str||order_sch_wb.delim||l_pivot_hdr
1356: ||order_sch_wb.delim||owb_tree.lookups(13)||order_sch_wb.delim||
1357: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||owb_tree.lookups(15)||order_sch_wb.delim||
1358: owb_tree.lookups(16)||order_sch_wb.delim||'End';
1359: ELSE
1360: IF p_pegging_id is null THEN
1361: p_row_hdr_str:= owb_tree.lookups(6)||order_sch_wb.delim;
1362: ELSE

Line 1361: p_row_hdr_str:= owb_tree.lookups(6)||order_sch_wb.delim;

1357: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||owb_tree.lookups(15)||order_sch_wb.delim||
1358: owb_tree.lookups(16)||order_sch_wb.delim||'End';
1359: ELSE
1360: IF p_pegging_id is null THEN
1361: p_row_hdr_str:= owb_tree.lookups(6)||order_sch_wb.delim;
1362: ELSE
1363: p_row_hdr_str:= owb_tree.lookups(5)||order_sch_wb.delim;
1364: END IF;
1365: p_row_hdr_str := p_row_hdr_str||

Line 1363: p_row_hdr_str:= owb_tree.lookups(5)||order_sch_wb.delim;

1359: ELSE
1360: IF p_pegging_id is null THEN
1361: p_row_hdr_str:= owb_tree.lookups(6)||order_sch_wb.delim;
1362: ELSE
1363: p_row_hdr_str:= owb_tree.lookups(5)||order_sch_wb.delim;
1364: END IF;
1365: p_row_hdr_str := p_row_hdr_str||
1366: owb_tree.lookups(13)||order_sch_wb.delim||
1367: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||

Line 1366: owb_tree.lookups(13)||order_sch_wb.delim||

1362: ELSE
1363: p_row_hdr_str:= owb_tree.lookups(5)||order_sch_wb.delim;
1364: END IF;
1365: p_row_hdr_str := p_row_hdr_str||
1366: owb_tree.lookups(13)||order_sch_wb.delim||
1367: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||
1368: owb_tree.lookups(15)||order_sch_wb.delim||
1369: owb_tree.lookups(16)||order_sch_wb.delim||'End';
1370: END IF;

Line 1367: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||

1363: p_row_hdr_str:= owb_tree.lookups(5)||order_sch_wb.delim;
1364: END IF;
1365: p_row_hdr_str := p_row_hdr_str||
1366: owb_tree.lookups(13)||order_sch_wb.delim||
1367: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||
1368: owb_tree.lookups(15)||order_sch_wb.delim||
1369: owb_tree.lookups(16)||order_sch_wb.delim||'End';
1370: END IF;
1371:

Line 1368: owb_tree.lookups(15)||order_sch_wb.delim||

1364: END IF;
1365: p_row_hdr_str := p_row_hdr_str||
1366: owb_tree.lookups(13)||order_sch_wb.delim||
1367: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||
1368: owb_tree.lookups(15)||order_sch_wb.delim||
1369: owb_tree.lookups(16)||order_sch_wb.delim||'End';
1370: END IF;
1371:
1372: p_supply_str := p_supply_str||order_sch_wb.delim||'End';

Line 1369: owb_tree.lookups(16)||order_sch_wb.delim||'End';

1365: p_row_hdr_str := p_row_hdr_str||
1366: owb_tree.lookups(13)||order_sch_wb.delim||
1367: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||
1368: owb_tree.lookups(15)||order_sch_wb.delim||
1369: owb_tree.lookups(16)||order_sch_wb.delim||'End';
1370: END IF;
1371:
1372: p_supply_str := p_supply_str||order_sch_wb.delim||'End';
1373: p_demand_str := p_demand_str||order_sch_wb.delim||'End';