APPS.OE_VALIDATE_LINE dependencies on OE_ORDER_LINES_ALL

Line 2837: FROM OE_ORDER_LINES_ALL

2833: Select arrival_set_id,
2834: ship_set_id
2835: Into l_arrival_set_id,
2836: l_ship_set_id
2837: FROM OE_ORDER_LINES_ALL
2838: Where line_id = p_line_rec.top_model_line_id;
2839:
2840: EXCEPTION
2841: WHEN OTHERS THEN

Line 3753: FROM oe_order_lines_all ool, mtl_material_transactions mmt

3749: CURSOR c_transaction_quantity IS
3750: SELECT ABS(mmt.transaction_quantity) transaction_quantity,
3751: mmt.transaction_uom,
3752: mmt.revision
3753: FROM oe_order_lines_all ool, mtl_material_transactions mmt
3754: WHERE ool.line_id = p_line_rec.reference_line_id
3755: AND mmt.transaction_source_type_id = 2
3756: AND mmt.transaction_type_id = 33
3757: AND mmt.trx_source_line_id = ool.line_id

Line 4579: UPDATE OE_ORDER_LINES_ALL

4575: IF l_debug_level > 0 THEN
4576: oe_debug_pub.add('ROLLBACK THE CHANGES ' ,2);
4577: END IF;
4578:
4579: UPDATE OE_ORDER_LINES_ALL
4580: SET SCHEDULE_SHIP_DATE = p_old_line_rec.schedule_ship_date,
4581: SCHEDULE_ARRIVAL_DATE = p_old_line_rec.schedule_arrival_date,
4582: SHIP_FROM_ORG_ID = p_old_line_rec.ship_from_org_id
4583: WHERE top_model_line_id = p_line_rec.top_model_line_id;