DBA Data[Home] [Help]

APPS.OE_DEFAULT_LINE dependencies on MTL_TRANSACTION_LOT_VAL_V

Line 2942: mtl_transaction_lot_val_v t,

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