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.OE_OEOL_SCH dependencies on OE_ORDER_LINES

Line 100: FROM oe_order_lines_all

96:
97: -- Added source_type_code in the below query for bug 5880264
98: SELECT schedule_status_code, source_type_code
99: INTO l_schedule_status_code, l_source_type_code
100: FROM oe_order_lines_all
101: WHERE line_id = p_line_id;
102:
103:
104: sch_cached_line_id := p_line_id;

Line 192: ' FROM oe_order_lines_all ola, wf_item_activity_statuses wias, wf_process_activities wpa '||

188: END IF;
189: IF l_where_clause IS NOT NULL
190: THEN
191: l_stmt :=' SELECT ola.line_id '||
192: ' FROM oe_order_lines_all ola, wf_item_activity_statuses wias, wf_process_activities wpa '||
193: l_where_clause||
194: ' AND wias.item_key = to_char(ola.line_id)'||
195: ' AND wias.item_type = '||'''OEOL'''||
196: ' AND wias.process_activity = wpa.instance_id'||

Line 396: FROM oe_order_lines

392: , l_source_document_id
393: , l_source_document_line_id
394: , l_link_to_line_id -- 3000761
395: , l_line_rec.inventory_item_id
396: FROM oe_order_lines
397: WHERE line_id = to_number(itemkey);
398: --FOR UPDATE; -- 3693569 :This will be locked after parent line is locked.
399:
400: l_child_line_id := l_line_id;

Line 414: FROM oe_order_lines

410: END IF;
411:
412: SELECT line_id, top_model_line_id
413: INTO l_line_id, l_top_model_line_id
414: FROM oe_order_lines
415: WHERE line_id = l_top_model_line_id
416: FOR UPDATE;
417:
418: IF l_debug_level > 0 THEN

Line 426: FROM oe_order_lines

422: END IF;
423: -- 3693569: Lock the child line
424: SELECT line_id
425: INTO l_line_id
426: FROM oe_order_lines
427: WHERE line_id = l_child_line_id
428: FOR UPDATE;
429:
430: l_line_id := to_number(itemkey);

Line 1131: FROM OE_ORDER_LINES

1127: ATO_LINE_ID
1128: INTO l_source_type_code,
1129: l_item_type_code,
1130: l_ato_line_id
1131: FROM OE_ORDER_LINES
1132: WHERE LINE_ID = l_line_id;
1133:
1134: if (funcmode = 'RUN') then
1135:

Line 1368: FROM oe_order_lines_all

1364: -- locking the model line so that scheduling and other fields can be updated
1365: BEGIN
1366: SELECT line_id
1367: INTO l_line_id
1368: FROM oe_order_lines_all
1369: WHERE line_id = l_line_rec.line_id
1370: FOR UPDATE NOWAIT;
1371: EXCEPTION
1372: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

Line 1555: FROM oe_order_lines_all

1551:
1552: BEGIN
1553: SELECT item_type_code,schedule_status_code ,line_category_code
1554: INTO l_item_type_code,l_schedule_status_code ,l_line_category_code
1555: FROM oe_order_lines_all
1556: WHERE line_id = to_number(itemkey);
1557: EXCEPTION
1558: WHEN OTHERS THEN
1559: raise;

Line 1640: FROM oe_order_lines_all

1636: SELECT item_type_code,firm_demand_flag ,line_category_code, shipped_quantity,
1637: fulfilled_flag,open_flag,cancelled_flag,source_type_code
1638: INTO l_item_type_code,l_firm_demand_flag ,l_line_category_code, l_shipped_quantity,
1639: l_fulfilled_flag,l_open_flag,l_cancelled_flag,l_source_type_code
1640: FROM oe_order_lines_all
1641: WHERE line_id = to_number(itemkey);
1642:
1643: EXCEPTION
1644: WHEN OTHERS THEN

Line 1713: FROM oe_order_lines_all ola,

1709: l_itemkey NUMBER;
1710:
1711: CURSOR model is
1712: SELECT ola.line_id line_id
1713: FROM oe_order_lines_all ola,
1714: wf_item_activity_statuses wias,
1715: wf_process_activities wpa
1716: WHERE top_model_line_id = nvl(l_top_model_line_id, ola.top_model_line_id)
1717: And ato_line_id = nvl(l_ato_line_id, ola.ato_line_id)

Line 1739: From oe_order_lines_all

1735: Select firm_demand_flag, top_model_line_id, ato_line_id,
1736: ship_model_complete_flag
1737: Into l_firm_demand_flag, l_top_model_line_id, l_ato_line_id,
1738: l_ship_model_complete_flag
1739: From oe_order_lines_all
1740: Where line_id = to_number(itemkey);
1741:
1742: IF Nvl(l_firm_demand_flag,'N') = 'N' THEN
1743: IF l_ship_model_complete_flag= 'Y' THEN

Line 1750: From oe_order_lines

1746: oe_debug_pub.add('Ato Model ' || l_top_model_line_id );
1747: oe_debug_pub.add('SMC ' || l_ship_model_complete_flag );
1748: Select firm_demand_flag
1749: Into l_firm_demand_flag
1750: From oe_order_lines
1751: Where line_id = l_top_model_line_id
1752: For Update;
1753:
1754: Update oe_order_lines

Line 1754: Update oe_order_lines

1750: From oe_order_lines
1751: Where line_id = l_top_model_line_id
1752: For Update;
1753:
1754: Update oe_order_lines
1755: Set firm_demand_flag = 'Y'
1756: Where top_model_line_id = l_top_model_line_id;
1757:
1758: l_ato_line_id := Null;

Line 1775: From oe_order_lines

1771: ELSIF l_ato_line_id is not null THEN
1772:
1773: Select firm_demand_flag
1774: Into l_firm_demand_flag
1775: From oe_order_lines
1776: Where line_id = l_ato_line_id
1777: For Update;
1778:
1779: Update oe_order_lines

Line 1779: Update oe_order_lines

1775: From oe_order_lines
1776: Where line_id = l_ato_line_id
1777: For Update;
1778:
1779: Update oe_order_lines
1780: Set firm_demand_flag = 'Y'
1781: Where ato_line_id = l_ato_line_id;
1782:
1783: l_top_model_line_id := Null;

Line 1803: From oe_order_lines

1799: --bug 3814076
1800: l_itemkey := to_number(itemkey);
1801: Select firm_demand_flag
1802: Into l_firm_demand_flag
1803: From oe_order_lines
1804: Where line_id = l_itemkey
1805: For Update;
1806:
1807: Update oe_order_lines

Line 1807: Update oe_order_lines

1803: From oe_order_lines
1804: Where line_id = l_itemkey
1805: For Update;
1806:
1807: Update oe_order_lines
1808: Set firm_demand_flag = 'Y'
1809: Where line_id = to_number(itemkey);
1810:
1811: -- Update the firm flag and also move them from firm eligible block.