APPS.OE_OEOL_SCH dependencies on OE_ORDER_LINES_ALL

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 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