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 416: FROM oe_order_lines

412: , l_line_rec.inventory_item_id
413: , l_ship_set_id
414: , l_arrival_set_id
415: , l_subscription_enable_flag --sol_ord_er #16014165
416: FROM oe_order_lines
417: WHERE line_id = to_number(itemkey);
418: --FOR UPDATE; -- 3693569 :This will be locked after parent line is locked.
419:
420: l_child_line_id := l_line_id;

Line 435: FROM oe_order_lines

431:
432: BEGIN
433: SELECT line_id, top_model_line_id
434: INTO l_line_id, l_top_model_line_id
435: FROM oe_order_lines
436: WHERE line_id = l_top_model_line_id
437: FOR UPDATE NOWAIT; --11868761
438:
439: IF l_debug_level > 0 THEN

Line 456: FROM oe_order_lines

452: -- 3693569: Lock the child line
453: BEGIN
454: SELECT line_id
455: INTO l_line_id
456: FROM oe_order_lines
457: WHERE line_id = l_child_line_id
458: FOR UPDATE NOWAIT; --11868761
459:
460: EXCEPTION

Line 1251: FROM OE_ORDER_LINES

1247: ATO_LINE_ID
1248: INTO l_source_type_code,
1249: l_item_type_code,
1250: l_ato_line_id
1251: FROM OE_ORDER_LINES
1252: WHERE LINE_ID = l_line_id;
1253:
1254: if (funcmode = 'RUN') then
1255:

Line 1489: FROM oe_order_lines_all

1485: -- locking the model line so that scheduling and other fields can be updated
1486: BEGIN
1487: SELECT line_id
1488: INTO l_line_id
1489: FROM oe_order_lines_all
1490: WHERE line_id = l_line_rec.line_id
1491: FOR UPDATE NOWAIT;
1492: EXCEPTION
1493: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

Line 1679: FROM oe_order_lines_all

1675: SELECT item_type_code,schedule_status_code ,line_category_code,
1676: subscription_enable_flag --sol_ord_er #16014165
1677: INTO l_item_type_code,l_schedule_status_code ,l_line_category_code,
1678: l_subscription_enable_flag --sol_ord_er #16014165
1679: FROM oe_order_lines_all
1680: WHERE line_id = to_number(itemkey);
1681: EXCEPTION
1682: WHEN OTHERS THEN
1683: raise;

Line 1769: FROM oe_order_lines_all

1765: subscription_enable_flag --sol_ord_er #16014165
1766: INTO l_item_type_code,l_firm_demand_flag ,l_line_category_code, l_shipped_quantity,
1767: l_fulfilled_flag,l_open_flag,l_cancelled_flag,l_source_type_code,
1768: l_subscription_enable_flag --sol_ord_er #16014165
1769: FROM oe_order_lines_all
1770: WHERE line_id = to_number(itemkey);
1771:
1772: EXCEPTION
1773: WHEN OTHERS THEN

Line 1844: FROM oe_order_lines_all ola,

1840: l_itemkey NUMBER;
1841:
1842: CURSOR model is
1843: SELECT ola.line_id line_id
1844: FROM oe_order_lines_all ola,
1845: wf_item_activity_statuses wias,
1846: wf_process_activities wpa
1847: WHERE top_model_line_id = nvl(l_top_model_line_id, ola.top_model_line_id)
1848: And ato_line_id = nvl(l_ato_line_id, ola.ato_line_id)

Line 1870: From oe_order_lines_all

1866: Select firm_demand_flag, top_model_line_id, ato_line_id,
1867: ship_model_complete_flag
1868: Into l_firm_demand_flag, l_top_model_line_id, l_ato_line_id,
1869: l_ship_model_complete_flag
1870: From oe_order_lines_all
1871: Where line_id = to_number(itemkey);
1872:
1873: IF Nvl(l_firm_demand_flag,'N') = 'N' THEN
1874: IF l_ship_model_complete_flag= 'Y' THEN

Line 1881: From oe_order_lines

1877: oe_debug_pub.add('Ato Model ' || l_top_model_line_id );
1878: oe_debug_pub.add('SMC ' || l_ship_model_complete_flag );
1879: Select firm_demand_flag
1880: Into l_firm_demand_flag
1881: From oe_order_lines
1882: Where line_id = l_top_model_line_id
1883: For Update;
1884:
1885: Update oe_order_lines

Line 1885: Update oe_order_lines

1881: From oe_order_lines
1882: Where line_id = l_top_model_line_id
1883: For Update;
1884:
1885: Update oe_order_lines
1886: Set firm_demand_flag = 'Y'
1887: Where top_model_line_id = l_top_model_line_id;
1888:
1889: l_ato_line_id := Null;

Line 1913: From oe_order_lines

1909: ELSIF l_ato_line_id is not null THEN
1910:
1911: Select firm_demand_flag
1912: Into l_firm_demand_flag
1913: From oe_order_lines
1914: Where line_id = l_ato_line_id
1915: For Update;
1916:
1917: Update oe_order_lines

Line 1917: Update oe_order_lines

1913: From oe_order_lines
1914: Where line_id = l_ato_line_id
1915: For Update;
1916:
1917: Update oe_order_lines
1918: Set firm_demand_flag = 'Y'
1919: Where ato_line_id = l_ato_line_id;
1920:
1921: l_top_model_line_id := Null;

Line 1948: From oe_order_lines

1944: --bug 3814076
1945: l_itemkey := to_number(itemkey);
1946: Select firm_demand_flag
1947: Into l_firm_demand_flag
1948: From oe_order_lines
1949: Where line_id = l_itemkey
1950: For Update;
1951:
1952: Update oe_order_lines

Line 1952: Update oe_order_lines

1948: From oe_order_lines
1949: Where line_id = l_itemkey
1950: For Update;
1951:
1952: Update oe_order_lines
1953: Set firm_demand_flag = 'Y'
1954: Where line_id = to_number(itemkey);
1955:
1956: -- Update the firm flag and also move them from firm eligible block.