DBA Data[Home] [Help]

APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_LOT_NUMBERS

Line 1863: FROM mtl_lot_numbers

1859: CURSOR mtl_lot_num_csr (p_org_id In NUMBER,
1860: p_inventory_item_id IN NUMBER,
1861: p_lot_number IN VARCHAR2) IS
1862: SELECT 'x'
1863: FROM mtl_lot_numbers
1864: WHERE organization_id = p_org_id
1865: AND inventory_item_id = p_inventory_item_id
1866: AND lot_number = p_lot_number
1867: AND nvl(disable_flag,2) = 2;