APPS.OE_DEFAULT_LINE dependencies on MTL_UNIT_TRANSACTIONS_ALL_V

Line 2830: mtl_unit_transactions_all_v u,

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

Line 2921: mtl_unit_transactions_all_v u,

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

Line 2943: mtl_unit_transactions_all_v u,

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
2946: WHERE u.Inventory_item_id = to_number(attr1)
2947: AND u.ORGANIZATION_ID = t.ORGANIZATION_ID

Line 3437: mtl_unit_transactions_all_v u,

3433:
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'