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.BOM_MIXED_MODEL_MAP_PVT dependencies on STANDARD

Line 337: FROM bom_standard_operations bso,

333: -- MUST BE MEMBERS OF THE GIVEN FAMILY.
334:
335: CURSOR c1 IS
336: SELECT distinct bso.operation_code OC, bso.sequence_num SN
337: FROM bom_standard_operations bso,
338: bom_operation_sequences bos,
339: bom_operational_routings bor
340: WHERE bor.mixed_model_map_flag = 1
341: AND bor.line_id = p_line_id

Line 346: AND bso.standard_operation_id = bos.standard_operation_id

342: AND bor.organization_id = p_org_id
343: AND bor.common_routing_sequence_id = bos.routing_sequence_id
344: AND bos.operation_type = p_operation_type
345: AND NVL(bos.eco_for_production,2) = 2
346: AND bso.standard_operation_id = bos.standard_operation_id
347: AND (p_family_item_id is null
348: OR
349: EXISTS (SELECT 'x'
350: FROM mtl_system_items msi

Line 360: FROM bom_standard_operations bso,

356:
357: -- SAME AS C1, EXCEPT ORDER BY IS DIFFERENT
358: CURSOR c2 IS
359: SELECT distinct bso.operation_code OC, bso.sequence_num SN
360: FROM bom_standard_operations bso,
361: bom_operation_sequences bos,
362: bom_operational_routings bor
363: WHERE bor.mixed_model_map_flag = 1
364: AND bor.line_id = p_line_id

Line 369: AND bso.standard_operation_id = bos.standard_operation_id

365: AND bor.organization_id = p_org_id
366: AND bor.common_routing_sequence_id = bos.routing_sequence_id
367: AND bos.operation_type = p_operation_type
368: AND NVL(bos.eco_for_production,2) = 2
369: AND bso.standard_operation_id = bos.standard_operation_id
370: AND (p_family_item_id is null
371: OR
372: EXISTS (SELECT 'x'
373: FROM mtl_system_items msi

Line 713: AND SL1.ITEM_TYPE_CODE in ('STANDARD', 'CONFIG', 'INCLUDED', 'OPTION')

709: AND MSI1.INVENTORY_ITEM_ID = SL1.INVENTORY_ITEM_ID
710: AND SL1.ORDERED_QUANTITY > 0
711: AND SL1.VISIBLE_DEMAND_FLAG = 'Y'
712: AND SL1.OPEN_FLAG = 'Y'
713: AND SL1.ITEM_TYPE_CODE in ('STANDARD', 'CONFIG', 'INCLUDED', 'OPTION')
714: AND OE_INSTALL.GET_ACTIVE_PRODUCT = 'ONT'
715: AND wl.organization_id = sl1.ship_from_org_id
716: AND wl.line_id in (select line_id
717: from bom_operational_routings bor2

Line 1485: bos1.standard_operation_id std_op_id,

1481: -- Cursor to Get Resource Details
1482: CURSOR ResourceDetails IS
1483: select bor.resource_id resource_id,
1484: nvl(bor.activity_id, -1) activity_id,
1485: bos1.standard_operation_id std_op_id,
1486: brtg.assembly_item_id assy_item_id,
1487: sum(bor.usage_rate_or_amount * nvl(con.conversion_rate, 0) /
1488: nvl(l_hour_conv, 1) *
1489: nvl(bos1.net_planning_percent, 100) / 100 /

Line 1512: group by bor.resource_id, nvl(bor.activity_id, -1), bos1.standard_operation_id, brtg.assembly_item_id

1508: ( bos1.operation_type = 2
1509: and bos2.process_op_seq_id = bos1.operation_sequence_id
1510: and p_operation_type = 2))
1511: and bos2.operation_sequence_id = bor.operation_sequence_id
1512: group by bor.resource_id, nvl(bor.activity_id, -1), bos1.standard_operation_id, brtg.assembly_item_id
1513: order by bor.resource_id, nvl(bor.activity_id, -1), bos1.standard_operation_id, brtg.assembly_item_id;
1514:
1515: -- Local Types
1516:

Line 1513: order by bor.resource_id, nvl(bor.activity_id, -1), bos1.standard_operation_id, brtg.assembly_item_id;

1509: and bos2.process_op_seq_id = bos1.operation_sequence_id
1510: and p_operation_type = 2))
1511: and bos2.operation_sequence_id = bor.operation_sequence_id
1512: group by bor.resource_id, nvl(bor.activity_id, -1), bos1.standard_operation_id, brtg.assembly_item_id
1513: order by bor.resource_id, nvl(bor.activity_id, -1), bos1.standard_operation_id, brtg.assembly_item_id;
1514:
1515: -- Local Types
1516:
1517: TYPE l_demand_rec_type IS RECORD (

Line 1522: standard_operation_id number,

1518: assembly_item_id number,
1519: average_demand number);
1520:
1521: TYPE l_process_lop_rec_type IS RECORD (
1522: standard_operation_id number,
1523: process_volume number,
1524: process_takt number);
1525:
1526: TYPE l_resource_detail_rec_type IS RECORD (

Line 1530: standard_operation_id number,

1526: TYPE l_resource_detail_rec_type IS RECORD (
1527: resource_id number,
1528: --resource_code varchar2(10),
1529: activity_id number,
1530: standard_operation_id number,
1531: resource_needed number);
1532:
1533: TYPE l_demand_tbl_type IS TABLE OF l_demand_rec_type
1534: INDEX BY BINARY_INTEGER;

Line 1603: select bos.standard_operation_id op,

1599: IF l_demand_table(l_index).average_demand > 0 THEN
1600: l_assy_id := l_demand_table(l_index).assembly_item_id;
1601: DECLARE
1602: CURSOR seqs IS
1603: select bos.standard_operation_id op,
1604: bos.reverse_cumulative_yield yld,
1605: bos.net_planning_percent pct
1606: from bom_operation_sequences bos,
1607: bom_operational_routings bor

Line 1621: l_process_lop_table(seq.op).standard_operation_id := seq.op;

1617: -- Count it In
1618: IF l_process_lop_table.EXISTS(seq.op) THEN
1619: l_process_lop_table(seq.op).process_volume := l_process_lop_table(seq.op).process_volume + l_volume;
1620: ELSE
1621: l_process_lop_table(seq.op).standard_operation_id := seq.op;
1622: l_process_lop_table(seq.op).process_volume := l_volume;
1623: END IF;
1624: END LOOP;
1625: END;

Line 1642: /* l_text := 'process volume '|| l_num || ' operation id: '||l_process_lop_table(l_index).standard_operation_id||' volume: '||l_process_lop_table(l_index).process_volume;

1638: p_hours_per_day/l_process_lop_table(l_index).process_volume;
1639: --converttime(p_hours_per_day/l_process_lop_table(l_index).process_volume,
1640: --p_time_uom);
1641:
1642: /* l_text := 'process volume '|| l_num || ' operation id: '||l_process_lop_table(l_index).standard_operation_id||' volume: '||l_process_lop_table(l_index).process_volume;
1643: l_num := l_num+1;
1644: insert into lm_temp (
1645: text
1646: )values(

Line 1674: l_res_detail_table(l_index).standard_operation_id := res.std_op_id;

1670: IF l_index = 0 THEN
1671: l_res_detail_table(l_index).resource_id := res.resource_id;
1672: -- l_res_detail_table(l_index).resource_code := res.resource_code;
1673: l_res_detail_table(l_index).activity_id := res.activity_id;
1674: l_res_detail_table(l_index).standard_operation_id := res.std_op_id;
1675: l_resource_needed := res.resource_needed * l_demand_table(res.assy_item_id).average_demand;
1676: --l_demand_sum := l_demand_table(res.assy_item_id).average_demand;
1677: l_index := l_index + 1;
1678: ELSIF l_res_detail_table(l_index-1).resource_id = res.resource_id and

Line 1681: l_res_detail_table(l_index-1).standard_operation_id = res.std_op_id THEN -- same group

1677: l_index := l_index + 1;
1678: ELSIF l_res_detail_table(l_index-1).resource_id = res.resource_id and
1679: -- l_res_detail_table(l_index-1).resource_code = res.resource_code and
1680: nvl(l_res_detail_table(l_index-1).activity_id, -1) = nvl(res.activity_id, -1) and
1681: l_res_detail_table(l_index-1).standard_operation_id = res.std_op_id THEN -- same group
1682: l_resource_needed := l_resource_needed +
1683: res.resource_needed * l_demand_table(res.assy_item_id).average_demand;
1684: --l_demand_sum := l_demand_sum +
1685: --l_demand_table(res.assy_item_id).average_demand;

Line 1688: l_std_op_id := l_res_detail_table(l_index-1).standard_operation_id;

1684: --l_demand_sum := l_demand_sum +
1685: --l_demand_table(res.assy_item_id).average_demand;
1686: ELSE -- a new one
1687: -- finalize the previous one
1688: l_std_op_id := l_res_detail_table(l_index-1).standard_operation_id;
1689: IF (l_resource_needed > 0) and
1690: (l_process_lop_table(l_std_op_id).process_volume > 0) THEN
1691: l_res_detail_table(l_index-1).resource_needed :=
1692: l_resource_needed/l_process_lop_table(l_std_op_id).process_volume/

Line 1700: l_res_detail_table(l_index).standard_operation_id := res.std_op_id;

1696: END IF;
1697: l_res_detail_table(l_index).resource_id := res.resource_id;
1698: -- l_res_detail_table(l_index).resource_code := res.resource_code;
1699: l_res_detail_table(l_index).activity_id := res.activity_id;
1700: l_res_detail_table(l_index).standard_operation_id := res.std_op_id;
1701: l_resource_needed := res.resource_needed * l_demand_table(res.assy_item_id).average_demand;
1702: --l_demand_sum := l_demand_table(res.assy_item_id).average_demand;
1703: l_index := l_index + 1;
1704: end if;

Line 1707: l_std_op_id := l_res_detail_table(l_index-1).standard_operation_id;

1703: l_index := l_index + 1;
1704: end if;
1705: END LOOP;
1706: -- The last one
1707: l_std_op_id := l_res_detail_table(l_index-1).standard_operation_id;
1708: IF (l_resource_needed > 0) and
1709: (l_process_lop_table(l_std_op_id).process_volume > 0) THEN
1710: l_res_detail_table(l_index-1).resource_needed :=
1711: l_resource_needed/l_process_lop_table(l_std_op_id).process_volume/

Line 1727: standard_operation_id,

1723: resource_id,
1724: resource_code,
1725: activity_id,
1726: activity,
1727: standard_operation_id,
1728: operation_code,
1729: resource_type,
1730: organization_id,
1731: resource_needed

Line 1739: l_res_detail_table(l_index).standard_operation_id,

1735: l_res_detail_table(l_index).resource_id,
1736: br.resource_code,
1737: l_res_detail_table(l_index).activity_id,
1738: ca.activity,
1739: l_res_detail_table(l_index).standard_operation_id,
1740: bso.operation_code,
1741: br.resource_type,
1742: p_org_id,
1743: l_res_detail_table(l_index).resource_needed

Line 1745: bom_standard_operations bso,

1741: br.resource_type,
1742: p_org_id,
1743: l_res_detail_table(l_index).resource_needed
1744: from cst_activities ca,
1745: bom_standard_operations bso,
1746: bom_resources br
1747: where ca.activity_id = l_res_detail_table(l_index).activity_id
1748: and bso.standard_operation_id = l_res_detail_table(l_index).standard_operation_id
1749: and br.resource_id = l_res_detail_table(l_index).resource_id;

Line 1748: and bso.standard_operation_id = l_res_detail_table(l_index).standard_operation_id

1744: from cst_activities ca,
1745: bom_standard_operations bso,
1746: bom_resources br
1747: where ca.activity_id = l_res_detail_table(l_index).activity_id
1748: and bso.standard_operation_id = l_res_detail_table(l_index).standard_operation_id
1749: and br.resource_id = l_res_detail_table(l_index).resource_id;
1750: else
1751: insert into BOM_MIXED_MODEL_MAP_RES (
1752: mixed_model_map_id,

Line 1757: standard_operation_id,

1753: resource_id,
1754: resource_code,
1755: activity_id,
1756: activity,
1757: standard_operation_id,
1758: operation_code,
1759: resource_type,
1760: organization_id,
1761: resource_needed

Line 1769: l_res_detail_table(l_index).standard_operation_id,

1765: l_res_detail_table(l_index).resource_id,
1766: br.resource_code,
1767: null,
1768: null,
1769: l_res_detail_table(l_index).standard_operation_id,
1770: bso.operation_code,
1771: br.resource_type,
1772: p_org_id,
1773: l_res_detail_table(l_index).resource_needed

Line 1774: from bom_standard_operations bso,

1770: bso.operation_code,
1771: br.resource_type,
1772: p_org_id,
1773: l_res_detail_table(l_index).resource_needed
1774: from bom_standard_operations bso,
1775: bom_resources br
1776: where bso.standard_operation_id = l_res_detail_table(l_index).standard_operation_id
1777: and br.resource_id = l_res_detail_table(l_index).resource_id;
1778: end if;

Line 1776: where bso.standard_operation_id = l_res_detail_table(l_index).standard_operation_id

1772: p_org_id,
1773: l_res_detail_table(l_index).resource_needed
1774: from bom_standard_operations bso,
1775: bom_resources br
1776: where bso.standard_operation_id = l_res_detail_table(l_index).standard_operation_id
1777: and br.resource_id = l_res_detail_table(l_index).resource_id;
1778: end if;
1779: EXIT WHEN l_index = l_res_detail_table.LAST;
1780: l_index := l_res_detail_table.NEXT(l_index);

Line 2108: FROM bom_standard_operations bso,

2104: ((1 + nvl((p_boost_percent * .01), 0)) *
2105: nvl((1/(avg(decode(nvl(reverse_cumulative_yield, 1),0,1,nvl(reverse_cumulative_yield,1))))),1) *
2106: nvl(avg(nvl((net_planning_percent * .01), 1)),1) * l_demand)
2107: process_volume
2108: FROM bom_standard_operations bso,
2109: bom_operation_sequences bos,
2110: bom_operational_routings bor
2111: WHERE bor.assembly_item_id = c1rec.AII
2112: AND bor.mixed_model_map_flag = 1

Line 2116: AND bos.standard_operation_id = bso.standard_operation_id

2112: AND bor.mixed_model_map_flag = 1
2113: AND bor.organization_id = p_org_id
2114: AND bor.line_id = p_line_id
2115: AND bor.common_routing_sequence_id = bos.routing_sequence_id
2116: AND bos.standard_operation_id = bso.standard_operation_id
2117: AND NVL(bos.eco_for_production,2) = 2
2118: AND bso.operation_code = l_op_code
2119: AND bso.organization_id = p_org_id
2120: AND bso.line_id = p_line_id