DBA Data[Home] [Help]

APPS.OE_DEFAULT_LINE dependencies on MTL_TRANSACTION_LOT_VAL_V

Line 2823: mtl_transaction_lot_val_v t,

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