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