APPS.OE_DEFAULT_LINE dependencies on MTL_MATERIAL_TRANSACTIONS

Line 2712: mtl_material_transactions m

2708: SELECT l.line_id
2709: INTO l_order_line_id
2710: FROM oe_order_lines l,
2711: mtl_unit_transactions_all_v u,
2712: mtl_material_transactions m
2713: WHERE l.Inventory_item_id = to_number(p_return_attribute1)
2714: AND m.transaction_source_type_id=2
2715: AND m.trx_source_line_id=l.line_id
2716: AND m.transaction_id = u.transaction_id

Line 2803: mtl_material_transactions m,

2799: CURSOR C_REF_LINE(attr1 VARCHAR2, attr2 VARCHAR2) IS
2800: SELECT /* MOAC_SQL_CHANGE */ DISTINCT l.line_id line_id
2801: FROM oe_order_lines_all l,
2802: mtl_unit_transactions_all_v u,
2803: mtl_material_transactions m,
2804: oe_order_headers h
2805: WHERE l.Inventory_item_id = to_number(attr1)
2806: AND m.transaction_source_type_id=2
2807: AND m.trx_source_line_id=l.line_id

Line 2822: FROM mtl_material_transactions m,

2818: order by l.line_id;
2819:
2820: CURSOR C_LOT_REF_LINE(attr1 VARCHAR2, attr2 VARCHAR2) IS
2821: SELECT /* MOAC_SQL_CHANGE */ DISTINCT l.line_id line_id
2822: FROM mtl_material_transactions m,
2823: mtl_transaction_lot_val_v t,
2824: mtl_unit_transactions_all_v u,
2825: oe_order_lines_all l,
2826: oe_order_headers h

Line 3319: mtl_material_transactions m

3315: SELECT l.line_id
3316: INTO l_order_line_id
3317: FROM oe_order_lines l,
3318: mtl_unit_transactions_all_v u,
3319: mtl_material_transactions m
3320: WHERE L.Inventory_item_id = to_number(p_return_attribute1)
3321: AND m.transaction_id = u.transaction_id
3322: AND l.line_category_code = 'ORDER'
3323: AND m.transaction_source_type_id=2

Line 3873: from mtl_material_transactions

3869:
3870: Begin
3871: select distinct revision
3872: into p_x_line_rec.item_revision
3873: from mtl_material_transactions
3874: where transaction_source_type_id = 2
3875: and transaction_type_id = 33
3876: and trx_source_line_id = p_x_line_rec.reference_line_id
3877: and inventory_item_id = p_x_line_rec.inventory_item_id