APPS.OE_VALIDATE_LINE dependencies on OE_ORDER_LINES_ALL

Line 2962: FROM OE_ORDER_LINES_ALL

2958: Select arrival_set_id,
2959: ship_set_id
2960: Into l_arrival_set_id,
2961: l_ship_set_id
2962: FROM OE_ORDER_LINES_ALL
2963: Where line_id = p_line_rec.top_model_line_id;
2964:
2965: EXCEPTION
2966: WHEN OTHERS THEN

Line 3885: FROM oe_order_lines_all ool, mtl_material_transactions mmt

3881: CURSOR c_transaction_quantity IS
3882: SELECT ABS(mmt.transaction_quantity) transaction_quantity,
3883: mmt.transaction_uom,
3884: mmt.revision
3885: FROM oe_order_lines_all ool, mtl_material_transactions mmt
3886: WHERE ool.line_id = p_line_rec.reference_line_id
3887: AND mmt.transaction_source_type_id = 2
3888: AND mmt.transaction_type_id = 33
3889: AND mmt.trx_source_line_id = ool.line_id

Line 4895: UPDATE OE_ORDER_LINES_ALL

4891: IF l_debug_level > 0 THEN
4892: oe_debug_pub.add('ROLLBACK THE CHANGES ' ,2);
4893: END IF;
4894:
4895: UPDATE OE_ORDER_LINES_ALL
4896: SET SCHEDULE_SHIP_DATE = p_old_line_rec.schedule_ship_date,
4897: SCHEDULE_ARRIVAL_DATE = p_old_line_rec.schedule_arrival_date,
4898: SHIP_FROM_ORG_ID = p_old_line_rec.ship_from_org_id
4899: WHERE top_model_line_id = p_line_rec.top_model_line_id;