APPS.OE_DEFAULT_LINE dependencies on MTL_MATERIAL_TRANSACTIONS

Line 2831: mtl_material_transactions m

2827: SELECT l.line_id
2828: INTO l_order_line_id
2829: FROM oe_order_lines l,
2830: mtl_unit_transactions_all_v u,
2831: mtl_material_transactions m
2832: WHERE l.Inventory_item_id = to_number(p_return_attribute1)
2833: AND m.transaction_source_type_id=2
2834: AND m.trx_source_line_id=l.line_id
2835: AND m.transaction_id = u.transaction_id

Line 2922: mtl_material_transactions m,

2918: CURSOR C_REF_LINE(attr1 VARCHAR2, attr2 VARCHAR2) IS
2919: SELECT /* MOAC_SQL_CHANGE */ DISTINCT l.line_id line_id
2920: FROM oe_order_lines_all l,
2921: mtl_unit_transactions_all_v u,
2922: mtl_material_transactions m,
2923: oe_order_headers h
2924: WHERE l.Inventory_item_id = to_number(attr1)
2925: AND m.transaction_source_type_id=2
2926: AND m.trx_source_line_id=l.line_id

Line 2941: FROM mtl_material_transactions m,

2937: order by l.line_id;
2938:
2939: CURSOR C_LOT_REF_LINE(attr1 VARCHAR2, attr2 VARCHAR2) IS
2940: SELECT /* MOAC_SQL_CHANGE */ DISTINCT l.line_id line_id
2941: FROM mtl_material_transactions m,
2942: mtl_transaction_lot_val_v t,
2943: mtl_unit_transactions_all_v u,
2944: oe_order_lines_all l,
2945: oe_order_headers h

Line 3438: mtl_material_transactions m

3434: SELECT l.line_id
3435: INTO l_order_line_id
3436: FROM oe_order_lines l,
3437: mtl_unit_transactions_all_v u,
3438: mtl_material_transactions m
3439: WHERE L.Inventory_item_id = to_number(p_return_attribute1)
3440: AND m.transaction_id = u.transaction_id
3441: AND l.line_category_code = 'ORDER'
3442: AND m.transaction_source_type_id=2

Line 4000: from mtl_material_transactions

3996:
3997: Begin
3998: select distinct revision
3999: into p_x_line_rec.item_revision
4000: from mtl_material_transactions
4001: where transaction_source_type_id = 2
4002: and transaction_type_id = 33
4003: and trx_source_line_id = p_x_line_rec.reference_line_id
4004: and inventory_item_id = p_x_line_rec.inventory_item_id